If you try to create a view in the View Designer, you will see a Tab named "Update Criteria". It is necessary to set values for key fields, updatable fields, and send SQL Updates to a view before it will update. If you look at your view in the view designer after you create it you will probably see that no fields are marked as key fields, no fields are marked for update, and Send SQL Updates is greyed out or unchecked. This causes TABLEUPDATE() to do nothing.
You can set these properties of the view programmatically using CURSORSETPROP().
Look at the properties "SendUpdates","Tables","UpdatableFieldList","UpdateNameList","UpdateType", and "WhereType".
The macro substitution has nothing to do with your problem. Once the view is created the SQL is static, and VFP doesn't care where the string came from.
Eric Shaneson
Cutting Edge Consulting
>Sorry in the above code it should be
>CREATE SQL VIEW workinst CONNECTION upsize ;
> as &LSQL
>note the & sign!
Eric Shaneson
Cutting Edge Consulting