>how can i get the actual processed records in a sql-select statement to populate a progress bar. The sql use 3 tables.


If use us a UDF in the select statement is the only way.
Inside the UDF try this :

xTotal = RECCOUNT(SELECT()) && Total records to be processed in main table
xRecNo = RECNO(SELECT()) && Current record number


This may not be exact but should allow you to update a progress bar ?