ODBC for text files

[phirst]

Hi,
To simplify, and thus speed up, some of the queries I need for a report I create text files. I then link these files with the other DB tables.
Problem: In one table I have an index with two fields.
Is it possible to define a composed index in a text file?
Thanx,
phirst.

 

[MalcolmW]

I have never created indexes for text files, as I have assumed that this was not possible. Is a primary index possible, let alone a composite index? Any ODBC text gurus out there? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?

 

[KathrynC]

Are you using an ODBC connection to the text files? How do you create indexes on the text files at all? I know you can use the fields from the text file(s) as links within Crystal, but I'm pretty sure that's a one-to-one situation. I've been able to connect to text files using the DAO data source, this might give you more flexibility, but I'd be careful of performance degradation.