General information
Category:
Coding, syntax & commands
Hello,
it will but the results you'll get aren't what you are expecting ..
since FoxPro can't handle out of it's own what records to update on a cursor that was created from a SQL with a JOIN in it .. (it probably will generate some UPDATE statements .. but these are normally semantically wrong)
TABLEUPDATE will trigger the update progress of the CursorAdapter ...
just test it out, write a CA with a JOIN in it's SelectCmd.. overwrite it's BeforeUpdate statement with
BeforeUpdate(..)
&& log SQL update statement to table with STRTOFILE or
&& just "?" print it to the screen
&& to examine what statements are created ..
get some records with CursorFill ..
change some fields in more than one row (BufferMode has to be 5 for this ..)
?TABLEUPDATE(.F.,.F.,yourCA.Alias)
Regards
Christian
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only