Here's the problem I'm having, I've created a class called "progressbar" to use for select statements that take a minute or two to complete in order to display a nicer graphical bar than the default one when SET TALK is ON. When selecting data from just one table it works fine. This is how it works:

pbar = newobject("progressbar")
pbar.max = reccount('TABLE1')
pbar.show()
SELECT * FROM TABLE1 WHERE PBAR.UPDATE(RECNO()) ...
release pbar

The problem is when I use this statement:

SELECT TABLE1.field, TABLE2.field from TABLE1,TABLE2 ;
WHERE pbar.update(recno()) AND conditions...

I've tried replacing RECNO() with RECNO('TABLE1') and RECNO('TABLE2')
Still all that happens is the progress bar pops up, sits there, and then disappears without incrementing with all the records.

How can I get around this? Is there an easier way to replace the default progress bar that Fox Pro uses when SET TALK is ON?