Sending info to VB

[MDA]

Hi all,

I have a stored procedure that uses the WHILE command to create a loop. The stored procedure is executed from VB. I would like to display a progress bar in VB to show the progress of the procedure. How do I relay the information back to vb? For example, most procedures will process several hundred thousand transactions, I would like to send an update say every 1000 records to VB. What syntax is used in SQL to do this? Also this will have to be in a loop, so that may throw a curve ball into the puzzle.

Any ideas is greatly appreciated...

Regards,
Mike

 

[kabbalah]

well,
the easiest way is surely pulling out the WHILE process from the Stored Procedure and doing it in the VB program so u will be able to control the number of times left or sth...
but i guess there must be a reason u decided to design it this way.