> Can't you do the lookup in the DB server by a SQL join for example? >
Or, if you need do some processing in between, use 2 queries and build the "where" clause for the 2nd from the results of the 1st. If you don't need the full table, don't use select *. Ludo _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal