Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate () , tableuptade (.T.)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01352026
Message ID:
01352031
Vues:
29
This message has been marked as the solution to the initial question of the thread.
>I noticed that sometimes Tableupdate () does not save the record
>
>So I have to use tableuptade (.T.)
>
>But the problem is that tableuptade (.T.) will save all records
>
>So, I would like to find out why sometimes Tableupdate () does not work,
>because I need to use it
>
>
>Moises

TABLEUPDATE() is one the the functions where I prefer to use FULL syntax, and ALWAYS check the result from it, so in your case:
IF NOT TABLEUPDATE(0, 1, [AliasHere])
    AERROR(laError)
   MessageBox(laError[1,2])
ENDIF
BTW TABLEUPDATE(1) will update only these records which you are changed, no matter if they have the same values as the old record.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform