Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update a rwemote view without primary key
Message
 
À
06/08/1999 17:01:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00250913
Message ID:
00250952
Vues:
22
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform