>>>>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.
>
>nope. candidate.

I will be using UNIQUE clause in the CREATE CURSOR command. UNIQUE in there produces a candidate index.