Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CaBuilder for VFP8 UPDATE problem.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01135185
Message ID:
01135211
Views:
10
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform