using create table command and indexes

[Keepontrying]

I am using the create table command to create a free table. Do I have to used a database to use a primary key?

I try this
create table employee.dbf free;
(empid c(10) Primary Key,;
address c(50))

a error message tell me this function is not support in a non-dbc mode.

Thanks

 

[torturedmind]

try the simplest:

create table employee (empid c(10), address c(50))
index on empid to employee

kilroy phils.

 

[ramani]

Hi

There is some syntax error in the above your code.. It is little funny that it is not visible, probably a space issue or whatever.

Because, when I cut and paste in command windows, it gives the error first time and when I just use a space bar, it becomes correct.

Try the following code,

create table employee free (empid c(10) Primary Key,;
address c(50))




____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

When you ask VFP questions, please add VFP version.

 

[ramani]

Hi sorry, I had some other issue in my testing...

You cannot have primary key in free table.



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

When you ask VFP questions, please add VFP version.

 

[BPeisch]

You can't use a primary index in a free table, but you can use a Candidate key, which is almost the same thing.



-BP

http://www.peisch.com