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

No, UNIQUE is NOT like candidate. It just creates an index with UNIQUE values in it. It just didn't add duplicate values in the index, but doesn't prevent you to add duplicate values in the cursor/table.

CREATE CURSOR crsTest (Fld1 I PRIMARY KEY)
CREATE CURSOR test (Fld1 I)
INDEX on Fld1 TAG Test UNIQUE
INSERT INTO Test VALUES(1)
INSERT INTO Test VALUES(1)
INSERT INTO Test VALUES(1)
INSERT INTO Test VALUES(1)
INSERT INTO Test VALUES(1)
INSERT INTO Test VALUES(1)
BROWSE
SET ORDER TO
BROWSE