I am trying to create VFP Free Tables and Index files using the VFP OLE DB Provider.
I am able to create tables. However I'm having trouble creating indexes.
I'm trying to send two commands via the command object, separated by a semi-colon (this is the way SQL Server does it...).
For example:
objCmd.CommandText = "USE table;INDEX ON expression TAG tagname"
But this is not working. I'm not getting any errors or any feedback, but the index is not getting created. Anybody know how to create indexes this way?