Primary key in 2.6

[jaapvanbeusekom]

I search a way to create a primary key in a Foxpro 2.6 DOS database.

Of course I Googled but all results are for VFP not FPD 2.6.
Like ALTER TABLE customer ADD PRIMARY KEY cust_id TAG cust_id
does not work.

I need the primary key for synchronize with a other program/database

Please help!

 

[DSummZZZ]

Older versions of Foxpro didn't really differentiate primary or candidate keys. There is UNIQUE clause which will only display one value of duplicated keys.

One way or the other though, you have to create indexes manually or progamatically using the following syntax, not by using ALTER TABLE commands:

USE SomeDBF EXCLUSIVE 
INDEX ON somefield TAG sometag [UNIQUE]

-or-

INDEX ON field1 + field2 ... TAG sometag

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm