Solved

Showing currently processesing sql server cursor row number in VB6

Posted on 2010-09-02
4
445 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
Comment Utility
You have to use a counter and increment it along with the cursor to get the row number.
0
 

Author Comment

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

Expert Comment

by:avirups
Comment Utility
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
Comment Utility
Good
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now