>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.