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