>I have a work order form that allows users to enter work order info and to populate two child tables (via grids) in order to specify labor and materials. The form uses local views. The child labor and materials views have optimistic table bufffering set (5). The "parent" single record work order local view has optimistic row buffering set (3).
>
>If i add a NEW work order and enter in child labor and material records, i can save the work order and its child information. However, when i try to EDIT an EXISTING record, by changing something in the labor or material grid, the TABLEUPDATE(.t., .t., "v_worklab",laError) fails with the error message of "syntax error". This is nothing else stored in the error array.
>
>Any ideas?
to the view that fails.(if more then one fails, the shortest :) )
Is it possible to show the VIEW definition (if SELECT * a DISP STRU, please) and the definition of the DBGETPROPS ?
DBGETPROP(lcView","VIEW","TABLES")
DBGETPROP(lcView,"VIEW","SENDUPDATES")
DBGETPROP(lcView,"VIEW","WHERETYPE")
DBGETPROP(lcView,"VIEW","UPDATETYPE")
for all fields in view:
DBGETPROP(lcView+".Field_X","FIELD","UPDATENAME")
DBGETPROP(lcView+".Field_X","FIELD","UPDATABLE")
DBGETPROP(lcView+".Field_X","FIELD","KEYFIELD")
It is also a way to run through your table using GETNEXTMODIFIED and tableupdate record by record for debugging. Maybe you se somthing With the view and the target to update open one can see the changes and the records involved.
Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]