Create Cursor with Index Question 1

[audiopro]

Could someone help with the syntax for creating a cursor.
According to MSDN I need to add the word unique to the end but I have tried all sorts of things but with no success.

CREATE CURSOR SOLDIT (CODE C(10), QTY1 N(4), QTY2 N(4),SALE_NUM N(10), PRODUCT C(60), PRINCIPLE C(4)) 

* UNIQUE PRINCIPLE

Keith

http://www.studiosoft.co.uk

 

[bborissov]

CREATE CURSOR SOLDIT (CODE C(10), QTY1 N(4), QTY2 N(4),SALE_NUM N(10), PRODUCT C(60), PRINCIPLE C(4))
INDEX ON PRINCIPLE TAG SOLDIT UNIQUE

Borislav Borissov

 

[audiopro]

Thanks Borislav - I can move it on now.

Keith

http://www.studiosoft.co.uk

 

[bborissov]

Glad you solve your problem

Borislav Borissov

 

[TamarGranor]

The solution Borislav gave you does not set up a candidate key for your cursor. It creates the old-style unique index, which is a mostly useless thing.

To create a candidate key, put the UNIQUE keyword after the relevant field inside the parens:

CREATE CURSOR SOLDIT (CODE C(10), QTY1 N(4), QTY2 N(4),SALE_NUM N(10), PRODUCT C(60), PRINCIPLE C(4) UNIQUE)

Tamar