I am trying to show the progress in a SQL command but no luck
yet.

In the COPY TO command I use this:
COPY TO MyBackup FOR oTherm.UpdateBar(RECNO()/RECCOUNT()*100)

Any suggestions about the SQL command?

Thank you in advance