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
Title:
CaBuilder for VFP8 UPDATE problem.
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:
01135185
Views:
74
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 MR Fitzgerald
Order Inc.
Next
Reply
Map
View

Click here to load this message in the networking platform