Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CREATE CURSOR command
Message
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
Divers
Thread ID:
01533423
Message ID:
01533425
Vues:
55
>>Hi everybody,
>>
>>Does CREATE CURSOR command allow to specify primary key? It is not listed in the syntax, but there is a mention of it in the text.
>>
>>I'm adding a field ID I AutoInc NextValue 2 and I want this field to be primary key in the table. What will be my syntax for this?
>>
>>I also checked CREATE TABLE command and it allows to specify field as Primary. So, is there a difference between CURSOR and TABLE and it's a limitation of the CURSOR?
>>
>>Thanks in advance.
>
>Nope,
>PKs are allowed ONLY for DBC tables.
>CURSORS are not DBC tables :-)
>You must use candidate keys, instead of PKs

So, I will be using UNIQUE clause, correct? The Help is a bit confusing.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform