?
Solved

Showing currently processesing sql server cursor row number in VB6

Posted on 2010-09-02
4
Medium Priority
?
504 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
avirups earned 1500 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…
Suggested Courses

800 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