Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem tableupdating remote view
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00653475
Message ID:
00653844
Views:
22
Alejandro,

I would bet that there's something wrong on the SQL side of things. Are you sure that the id_plsis column has the identity property set? Can you do an Insert Into from within Query Analyzer without specifying a value for the id_plsis field in your statement?

Other than this, since I can't see your desktop, I agree with John Ryan - perhaps recreate the view from scratch and see what happens.

>Tableupdate returns .F. Error() returns 0, but after AERROR(laerror), laError shows error 1492: "No key columns are specified for the update table PLSIS. Use the KeyFieldList property of the cursor". The third element of laError says PLSIS.
>
>Now, PLSIS is a SQL server table that has a PK: ID_PLSIS. It is being referenced by remote view v_plsis, which is the one beoing TABLEUPDATEd. The v_plsis view has send sql updates = .T., has all fields except the PK as updatable, indicates that id_plsis is the PK, has where as PK only. BTW, Cursorgetprop('keyfieldlist','v_plsis') returns 'id_plsis'.
-Chuck Urwiler, MCSD, MCDBA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform