Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange tableupdate error
Message
From
16/10/2013 17:13:18
 
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:
01585698
Views:
60
What does the actual update statement look like?

>Hi everybody,
>
>I am running a de-duping program. I am getting the following error
>
>---------------------------
>Cannot update changes on the server
>---------------------------
>Error# 1492 - No key columns are specified for the update table "dbo.rsSeats". Use the KeyFieldList property of the cursor. dbo.rsSeats
>
>
>
>This occurred in table alias: RSSEATS
>---------------------------
>OK
>---------------------------
>
>The rsSeats table has SeatID column as KeyFieldList and this column is an identity column and it is excluded from the UpdatableFieldList and UpdateNameList. The cursor is obtained with sqlexec command and then made updatable using our special program which is similar to Vlad G FAQ.
>
>So, this error is reported on TABLEUPDATE() but it doesn't make sense.
>
>I am going to test the exact command send to SQL Server using profiler here.
>
>Do you know what may be a problem?
>
>Thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform