Hi Moises,

you need a command like this:

ALTER TABLE 'MyTable' ADD PRIMARY KEY <fieldname> TAG <tagname> COLLATE 'MACHINE'

so here's an actual line of code:

ALTER TABLE 'GENERATEPK' ADD PRIMARY KEY GPK_PK TAG GPK_PK COLLATE 'MACHINE'

For candidate keys:

INDEX ON UPPER(USR_LANID) TAG USR_LANID FOR .NOT.DELETED() CANDIDATE COLLATE 'MACHINE'

>How to create a primary or candidate KEY ?
>
>VFP help is not clear about this issue
>
>Moises