Yea, I know, I know... I forgot all about the quotes - I tried all the other ways. Can I ask you one more ques...
is there any logical reason why the loop works, the TableUpdate(.T.) returns a TRUE, but the records in the
DB don't update? The view has key & modified fields, SQL update and the qtystart, qtyend are marked.
Once again, thanks for all your help!!!!
>You COULD have found out the same way I did - run a test :-)
>
>No, you can just put the field name in quotes IF the correct table is SELECTed. It's safer to use the table name as well.
>
>>Barbara....
>>
>>Do you need to put the full field name in the oldval? veventbar.qtystart?
>>
>>
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!