>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.
You can add a candidate key to the cursor
index id tag id candidate
Gregory