Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement