Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter Questions
Message
From
11/05/2005 18:47:49
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01013179
Message ID:
01013189
Views:
19
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
Map
View

Click here to load this message in the networking platform