Solved

Showing currently processesing sql server cursor row number in VB6

Posted on 2010-09-02
4
469 Views
Last Modified: 2012-05-10
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
Comment
Question by:RETAILREALM
  • 2
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
avirups earned 500 total points
ID: 33594159
You have to use a counter and increment it along with the cursor to get the row number.
0
 

Author Comment

by:RETAILREALM
ID: 33594599
want to show number of the recored which is processing . Like Total : 1020 Processed : 100
0
 
LVL 8

Expert Comment

by:avirups
ID: 33594785
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
 

Author Closing Comment

by:RETAILREALM
ID: 33795875
Good
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question