BorlandTalk.com

Lee Cook · Guest

Hi,

Does anyone know if there is a limit on the number of Paradox DB files i can
use in a Tquery.

I have hundreds paradox db's and they are all excatly the same file
structure, I currently use the "Union" to buld up my SQL statment in a
tquery to access all the different DB files and order them by a field.

Is there a limit? is this the best way of doing this?

Any comments greatfully appreciated.

Lee

Bill Todd · Guest

There is almost certainly a limit on the size of a SQL statement but I
have no idea what it is. I have never seen it published that I can
recall.

The best solution would have been to use a single table in the first
place. The only other solution is to create a temporary table with the
same structure, add the contents of all of the tables to the temp table
and query that.

--
Bill Todd (TeamB)