Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update a rwemote view without primary key
Message
 
To
06/08/1999 17:01:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00250913
Message ID:
00250952
Views:
21
>Hi all
>I have some tables with isl extension(written in Cobol).
>When I connect through ODBC I can retrive it and evrything works fine
>until I try to update it, then I have a problem, because my source table doesn't have a primary key.(I can find some combination of fields to be unique but remote view allows primary key only for one field not expression).
>?
>Thanks in advance

Miroslav,

You can use a comple primary key, just click all teh fiedls involved. SQL (views) is for relational databases. Relational database tables all have primary keys, if a table does not have a PK it is not relational and SQL probably won't work on it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform