>how can i get the actual processed records in a sql-select statement to populate a progress bar. The sql use 3 tables.
The only to update a progress bar during a query (I don't recommend it for performance reasons) is to call a function inside the SQL statement:
SELECT Field1, Field2, MyFunction() as Dummy
and then MyFunction would do the updating. But getting a record count is impossible, because that is not the way SQL works.
Erik Moore
Clientelligence