Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate () , tableuptade (.T.)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01352026
Message ID:
01352031
Views:
30
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform