Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter Questions
Message
De
11/05/2005 18:47:49
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01013179
Message ID:
01013189
Vues:
20
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
Fil
Voir

Click here to load this message in the networking platform