CREATE INDEX Statement

[bjd4jc]

I am trying to create an index on the value of a paticular field using the CREATE INDEX Statement. The reason I need to do this is because there is a previously written program that uses this index (the index file was originally generated by Foxpro) and it expects the value of the field. Here is what I tried:

db.Execute "CREATE INDEX SNINV ON SN (Val(F_INVNO))"

AND

db.Execute "CREATE INDEX SNINV ON Val(SN(F_INVNO))"

Neither of them work. They both give the error: "Syntax error in CREATE INDEX statement."

Does anyone know how to make an index like this in VB? Oh, I am using the DAO 2.5/3.51 compatability library and connecting to a "FoxPro 2.5" database.

thanks

brian

 

[EMH]

The syntax is
CREATE INDEX SNINV ON table(attribute)"

It looks like your throwing in an extra variable
Val(SN(F_INVNO))