Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter quesiton
Message
 
 
To
20/08/2008 00:57:11
Lutz Scheffler (Online)
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:
01340377
Views:
10
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.
>
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform