valid REPLACE statement?

[kenndot]

I am not sure if this is even valid, can someone tell me? If it isn't, is there a similar way of accomplishing this?

replace intbills.prevproc WITH .t. ;
FOR adddate = DATE() ;
while claimno IN (select claimno FROM csrOld)

Can I do a lookup like that within a REPLACE statement? I get the function missing error so I'm assuming I just can't do that last clause..

thanks

 

[rgbean]

No, this isn't valid syntax. Check out the SQL UPDATE command for a similar capability.

Rick

 

[SqueakinSweep]

A little code like this will do the trick

select crsold
scan for adddate = date()
   update intbills set prevproc = .T. where claimno = crsold.claimno
endscan

WTrueman
...if it works dont mess with it

 

[kenndot]

i did end up with an update statement, thanks guys