Hi there!

I'm deploying a patch to modify an existing application so my users will be able to choose themselves to "primary" key for a record instead of having the app select the first one sequentially available. (dont ask why...)

My original DB had a primary index on that key, so I drop it, then create a new one transparently like so:

LOCAL leDropPK as Exception
ALTER table tblGroupes drop PRIMARY key
USE tblGroupes EXCLUSIVE
SELECT tblgroupes
INDEX on id_grp TAG id_grp ascending
REINDEX
USE

Problem is, when I try that bit in the code window in VFP development environnement, it works fine, but when I use the same code in my app, it creates a "candidate" key instead of a "regular" one...

Any idea why that is?