|
Home > Archive > Programming with dBASE > June 2005 > Database Engine Error when indexing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Database Engine Error when indexing
|
|
| Pieter van Heerden 2005-06-07, 1:23 pm |
| dBase 2.5 & Windows XP
My tables are in a subdirectory of my program directory. I use the following code to index a table, the code having been copied from an example in the dBase help files, and file names and field names and database name substituted with my own.
i=new Index()
i.indexName :="wstationu"
i.fields :="country;wstation"
i.unique = true
d.createIndex("temp2.dbf",i)
However, when I try to run the code, I get an error message: "Database engine Error: Invalid index description"
Where have I gone wrong????
| |
| Eric Logan 2005-06-07, 8:23 pm |
| dBase help says that the index() object is for 'non-local' tables, and for
local DBF files you should use a dbfindex() object. Dbfindex() requires an
index name and an index expression.
E.L.
"Pieter van Heerden" wrote ...
> My tables are in a subdirectory of my program directory. I use the
following code to index a table, the code having been copied from an example
in the dBase help files, and file names and field names and database name
substituted with my own.
> i=new Index()
> i.indexName :="wstationu"
> i.fields :="country;wstation"
> i.unique = true
> d.createIndex("temp2.dbf",i)
> However, when I try to run the code, I get an error message: "Database
engine Error: Invalid index description"
> Where have I gone wrong????
|
|
|
|
|