Create index with visual foxpro 6.0

[ishaywei]

I'm trying to create index with visual foxpro 6.0 my sql command is:

"CREATE INDEX id_index ON MY_TABLE (AGE1)";

I get an error : [syntax error].

does any know how to create index with visual foxpro 6.0?

thank ishay

[Phil Weber]

I Googled for "visual foxpro create index" and found this: http://msdn2.microsoft.com/en-US/library/14axb23a.aspx

[ishaywei]

thanks but it's for visual foxpro 9.0

[Phil Weber]

Did you try it? Does the same technique not work with 6.0?

[ishaywei]

all i get is syntax error