Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange tableupdate error
Message
 
 
To
16/10/2013 17:16:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01585696
Message ID:
01585712
Views:
44
>I've seen this when the key column was not specified in SQL Server as the Primary key.
>
I found a solution. The dedup program is a session based class and it replicated some of our generic procedures as methods of the class (not sure why this was done).

Anyway, in the dedup program version we excluded identity field from the list of updatable fields. In the main program version we didn't exclude it, but had this property
cursorsetprop('AutoIncError',.F.) && ignore error message when updating identity field set for identity field.

I suspect I already dealt with this problem in the past and added that code, but totally forgot about it. Anyway, changing the class method to be the same as our main program method resolved this problem.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform