Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CaBuilder for VFP8 UPDATE problem.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01135185
Message ID:
01135211
Vues:
11
>Would someone please give me a general rundown on what I must be doing incorrectly here?
>
>I have Mark's caBuilder for VFP8, and a test SQL table which has two fields, F1 and PK. F1 is just a varchar(10) and PK is a numeric(9) PK is the primary-key and an identity-field which auto-increments at the SQL Server.
>
>After creating the class for this table, I can generate a cursor, but it is not updating. Is this a SQL-side issue? The PK-field is not updatable of course, since it auto-increments. The builder has an excluded-field list which is meant to ignore the PK field, but to no avail. What am I missing? Does anyone have a simple example of a working CA application that they could share?
>
>Thanks,

John,
I work mostly with CAs and I didn't have problems with them.
When you try to Update your CAs, just check if the update is successful and if it is not check the error message returned.
IF NOT TableUpdate(1, .t., [MyCAAlias])
   AERROR(laError)
   MessageBox([Update is NOT successful ]+laError[1,2])
ENDIF
That will gives you infromation what is wrong with your CA.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform