Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

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?
0
RETAILREALM
Asked:
RETAILREALM
  • 2
  • 2
1 Solution
 
avirupsCommented:
You have to use a counter and increment it along with the cursor to get the row number.
0
 
RETAILREALMAuthor Commented:
want to show number of the recored which is processing . Like Total : 1020 Processed : 100
0
 
avirupsCommented:
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:

0
 
RETAILREALMAuthor Commented:
Good
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now