Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TableUpdate Returns False
Message
 
 
À
02/07/2001 14:20:36
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00525975
Message ID:
00525991
Vues:
17
This message has been marked as the solution to the initial question of the thread.
>Yes: 10, Syntax error. No error unless that one field's value changes in the view.

What is the name of the field it is changing? What is the value it is trying to set it to?

An updatable view is simply a wrapper to basic SQL. When you update the values and issue a Tableupdate, the engine goes through and based on the update settings of the view, builds an UPDATE SQL statement to handle the actual update.

If the name of the field is a reserved word, you may have problems. This is normally the case when using remote views. If there are embedded character delimeters, you may get an error.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform