Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter quesiton
Message
From
21/08/2008 00:18:14
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01339047
Message ID:
01340681
Views:
7
Just let me know what the problem was.

>Agnes,
>
>Thanks for your help. I hope my colleague will now be able to figure this out.
>
>>Naomi,
>>
>>to me this looks like the ID field is not written from CA to the database, and the database uses a default value.
>>
>>Check values of
>>UpdatableFieldList and UpdateNameList
>>
>>for the ID field. Check that UpdateNameList holds the right DBC!Table.Field expression for the target.
>>
>>I do not understand if you create the record with the CA or just update an existing one.
>>
>>But this is not a big problem
>>
>>Use the Method BeforeUpdate (add some code like)
>>LPARAMETERS tcFldState, tlForce, tnUpdateType, tcUpdateInsertCmd, tcDeleteCmd
>>?tcUpdateInsertCmd
>>debug
>>suspend
>>
>>
>>Check the output, this should be the command that is used for UPDATE or INSERT for the field you are missing.
>>
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform