Link to home
Start Free TrialLog in
Avatar of RETAILREALM
RETAILREALMFlag for United States of America

asked on

Showing currently processesing sql server cursor row number in VB6

Hello Experts,

I am trying to process some group of records in a sql server cursor - SP .
What I want to achieve is , to show the record number which is getting processed. i.e. if I am processesing record number 1020 then in vb6 UI I will show " Processesing Record Number... 1020 "

How I can achieve this?
ASKER CERTIFIED SOLUTION
Avatar of avirups
avirups
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RETAILREALM

ASKER

want to show number of the recored which is processing . Like Total : 1020 Processed : 100
You can declare two variables one for @row and @total_row.

SET @total_row with the initial count of your cursor definition and the start @row with 1.

Increment @row=@row+1 as and when you go to the next row in the cursor.


any point of time: @row will give you the Processed and @total_row will give you the Total:

Good