Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange tableupdate error
Message
De
16/10/2013 17:13:18
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01585696
Message ID:
01585698
Vues:
59
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform