Hi!
>Can anyone help with the following. I am connecting to my table using odbc through VBSCRIPT.
>
>1. When you create an index on a table using odbc, do you use an alter table
>statement? Does this create an idx / cdx file?
Not sure about answer. I'm sure that when you use anything in "Alter table" that can cause also index creating (for example, PK creating that way), CDX file will be created.
>2. When you use odbc to update the table, does odbc maintain the index?
>
Yes, indexes in CDX files are maintained automatically even when data updated through ODBC.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.