• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

Screen refresh during stored procedures execution

Hi experts,

I have a VB6 app that executes SQL Server 7 stored procedures.  The processing of my stored proc. takes about 15 minutes.  I would like to inform user about wich procedure is executing but when I set the caption property of a label it doesn't work. I think there is a refresh problem !

Thanks in advance.
0
anderlecht
Asked:
anderlecht
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
After setting the label caption, use DOEVENTS


lblProgress.Caption = "Processing procedure # 1"
Doevents

Cheers
0
 
anderlechtAuthor Commented:
Thank you very much it works !!!!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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