Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TABLEUPDATE() Errors
Message
De
19/07/1998 20:57:35
Brian Lee
World Access Network, Inc.
Vancouver, Washington, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
TABLEUPDATE() Errors
Divers
Thread ID:
00119136
Message ID:
00119136
Vues:
50
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?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform