>>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