Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 To: subhankar pandey
  Where is subhankar pandey?
 Kolkata/Delhi
 India
 subhankar pandey
 Tags
Subject: RE: SQL Progress Bar
Thread ID: 209120 Message ID: 209751 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, December 30, 2008 7:45:19 PM         
   


> Hi Friends,
> How would I define progess bar while opening SqlStringConnect(), bcoz sometime some of the users hv no patience to wait they need progess bar.
> Below is the code for more details:-
>
>
> cStr=_ConnectionStr
> lcConn = SQLSTRINGCONNECT(cStr) &&-- I need progress bar here
> 
> If lcConn<0
> Messagebox("Could not connect to the Database at this time.",16,"Error")
> Return
> Endif 

>
> awaiting yr comments.
>
> regards
> subhankar

CLEAR
?"Attempting connection"
loTimer = NEWOBJECT("tmrConnection")
STORE SQLCONNECT('TestGUID') TO m.lnConnHandle
IF m.lnConnHandle <= 0
   MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
   RETURN
ENDIF
?"Connection Established!"
RELEASE m.loTimer

RETURN

DEFINE CLASS tmrConnection as Timer
PROCEDURE Init
This.Interval = 5
ENDPROC

PROCEDURE timer
?"Timer Fired"
ENDPROC

ENDDEFINE





Mike Yearwood
Microsoft MVP Visual FoxPro 2008



We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.

ENTIRE THREAD

SQL Progress Bar Posted by subhankar pandey @ 12/24/2008 12:01:14 PM
RE: SQL Progress Bar Posted by Koen Piller @ 12/24/2008 2:26:39 PM
RE: SQL Progress Bar Posted by mk sharma @ 12/30/2008 4:25:19 PM
RE: SQL Progress Bar Posted by Koen Piller @ 12/30/2008 4:38:20 PM
RE: SQL Progress Bar Posted by mk sharma @ 12/30/2008 4:40:37 PM
RE: SQL Progress Bar Posted by Koen Piller @ 1/2/2009 10:27:09 AM
RE: SQL Progress Bar Posted by Anil Sharma @ 12/25/2008 6:51:02 AM
RE: SQL Progress Bar Posted by Koen Piller @ 12/25/2008 9:34:55 AM
RE: SQL Progress Bar Posted by Anil Sharma @ 12/25/2008 10:37:53 AM
RE: SQL Progress Bar Posted by Koen Piller @ 12/25/2008 12:35:20 PM
RE: SQL Progress Bar Posted by Om Rajan @ 12/25/2008 12:48:16 PM
RE: SQL Progress Bar Posted by Koen Piller @ 12/25/2008 2:11:31 PM
RE: SQL Progress Bar Posted by Om Rajan @ 12/25/2008 7:09:49 PM
RE: SQL Progress Bar Posted by Mike Yearwood @ 12/28/2008 4:32:56 PM
RE: SQL Progress Bar Posted by Samir Ibrahim @ 12/25/2008 8:42:54 PM
RE: SQL Progress Bar Posted by Koen Piller @ 12/26/2008 8:58:46 AM
RE: SQL Progress Bar Posted by Samir Ibrahim @ 12/26/2008 9:46:11 AM
RE: SQL Progress Bar Posted by Mike Yearwood @ 12/28/2008 4:35:06 PM
RE: SQL Progress Bar Posted by Samir Ibrahim @ 12/29/2008 12:42:40 PM
RE: SQL Progress Bar Posted by Mike Yearwood @ 12/29/2008 7:51:01 PM
RE: SQL Progress Bar Posted by Samir Ibrahim @ 12/30/2008 10:39:16 AM
RE: SQL Progress Bar Posted by subhankar pandey @ 12/26/2008 10:55:35 AM
RE: SQL Progress Bar Posted by Anil Sharma @ 12/26/2008 11:09:52 AM
RE: SQL Progress Bar Posted by subhankar pandey @ 12/27/2008 5:55:11 AM
RE: SQL Progress Bar Posted by Anil Sharma @ 12/27/2008 7:05:36 AM
RE: SQL Progress Bar Posted by mk sharma @ 12/30/2008 4:22:36 PM
RE: SQL Progress Bar Posted by Anil Sharma @ 1/2/2009 8:03:43 AM
RE: SQL Progress Bar Posted by Mike Yearwood @ 12/30/2008 7:45:19 PM
RE: SQL Progress Bar Posted by subhankar pandey @ 1/7/2009 1:14:26 PM