Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Create IDX from DBF with SQL
Create IDX from DBF with SQL
Well, I read :
Look at the ALTER TABLE command steps in the following MS KB article:
PRB: Creating Regular Indexes Through VFP ODBC Driver
http://support.microsoft.c
For further reference:
PRB: Help of VFP ODBC Driver Unclear on INDEX ON Command
http://support.microsoft.c
And I tried with SQL:
ALTER TABLE DBF_FILE ADD PRIMARY KEY FIELD1 TAG FIELD1
And SQL shows me an error :
[Microsoft][ODBC Visual FoxPro Driver]Feature is not supported for non-.DBC tables.
Please, help
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- dbf
- Participating Experts
- 1
- Solution Grade
- A
Posted on 2004-09-10 at 14:55:09ID: 26224428
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.