Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC and creating an index
Message
 
 
À
27/08/2001 11:24:05
Todd Wolfe
Certified Marketing Services
Kinderhook, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00549457
Message ID:
00549460
Vues:
22
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.com
ICQ #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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform