Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View does not send updates.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00387120
Message ID:
00387225
Views:
17
Even though you are forcing updates, there are still several situation where TABLEUPDATE will fail: unique key violation, trigger failure, locked table header or record, etc. You should always check the results of TABLEUPDATE() to be sure and catch this...


>Thanks much for your answer Erik,
>I am not doing that because I and forcing a tableupdate with
>=TABLEUPDATE(1,.T.), but I will check that. The only reason I think that could
>make =TABLEUPDATE(1,.T.) to fail is somebody having a LOCK in the record, which is weird because this table is only updated through views.
>
>Thanks again, Erik.
>
>

>>Are you checking the return value of your TABLEUPDATE()?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform