Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TABLEUPDATE() Errors
Message
From
19/07/1998 20:57:35
Brian Lee
World Access Network, Inc.
Vancouver, Washington, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
TABLEUPDATE() Errors
Miscellaneous
Thread ID:
00119136
Message ID:
00119136
Views:
51
Although I am successfully using Remote Views on separate tables, I find TABLEUPDATE() a bit cranky and, at times leaves me scratching my head - try these two instances:

(1): TABLEUPDATE(.T.) fails, and AERROR[1,2] returns the cryptic message "Incorrect syntax near the keyword 'UPDATE'" - while AERROR[2,2] tells me "Incorrect syntax near 'LIKE'" - these from an OBDC connectivity error 1526. Only 1 non-primary field was modified. All the usual DBSETPROP() settings are set correctly as far as I can tell. Since TABLEUPDATE() operates behind the scenes, is it telling me to give up Remote Views and use SPT functions instead?

(2): Same View, different day: Memo fields are modified, and TABLEUPDATE(.T.) returns .T. for a small result set with table buffering on. Great, the UPDATE was successful - right? Wrong, the View is refreshed and none of the Memo field changes were sent. I've checked (and unchecked) the Fetch Memo. Veried and re-checked all settings, Updatable fields, etc. Why does TABLEUPDATE() tell me the Update is successful, when obviously that's not true?
Next
Reply
Map
View

Click here to load this message in the networking platform