Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Are index names/ordinals important with ODBC?

Status
Not open for further replies.

DaveHettmer

Programmer
Jan 8, 2003
1
US
We have Crystal 8.5. When using DAO for the connection to a Jet database, Crystal allows (requires?) you to select an index (Visual Linking Expert->Link Options->Link in Use). The index is stored in the .rpt file using the index's ordinal. The report needs to be reverified if the schema changes such that the order of indexes in the table's list of indexes is different. This has caused us a number of woes - we don't deploy the database and the report bundled together in the same package, so we have to be very careful about how we manage schema updates.

With ODBC, however, the &quot;Link in Use&quot; combo has only one option: &quot;<no specific index>&quot;. Does this mean that under ODBC the .rpt file does rely on index information stored in the file and is therefore immune to changes in the database schema that change index ordinals?

Thanks in advance.

Dave Hettmer
dhettmer@creativesolutions.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top