Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: SQL progress
Thread ID: 137241 Message ID: 137350 # Views: 46 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Thursday, July 05, 2007 11:26:06 AM         
   


>
> Russel,
> Here what I use when I run a query against Native VFP data.
>
> SqlProgress(.t.)
> SELECT ........
> SqlProgress(.f.)
> 
> 
> FUNCTION SqlProgress(lbShowProgress)
>    IF m.lbShowProgress
>       DEFINE WINDOW WndGlass FROM -100,-100 TO -10,-10
>       SET TALK ON WINDOW WndGlass
>       SET TALK ON
>       SET NOTIFY ON
>    ELSE
>       RELEASE WINDOWS WndGlass
>       SET TALK ON WINDOW
>       SET TALK OFF
>       SET NOTIFY OFF
>    ENDIF
> RETURN ""
> 

>
>
>
>
> -----------------
> Borislav Borissov
>
>

Borislav,

That is a beautiful solution.

It forces "Running query ..." to show itself right in the middle of the screen.

This is excellent for my long queries.

My rating to you.

Russell.



COMPLETE THREAD
SQL progress Posted by Russell Hill @ 7/4/2007 3:12:19 PM
RE: SQL progress Posted by Vladimir Zhuravlev @ 7/4/2007 3:39:02 PM
RE: SQL progress Posted by Russell Hill @ 7/4/2007 11:35:15 PM
RE: SQL progress Posted by Vladimir Zhuravlev @ 7/5/2007 6:46:58 AM
RE: SQL progress Posted by Russell Hill @ 7/5/2007 7:15:59 AM
RE: SQL progress Posted by Brad Schulz @ 7/4/2007 6:12:39 PM
RE: SQL progress Posted by Andy Kramek @ 7/4/2007 7:23:06 PM
RE: SQL progress Posted by Russell Hill @ 7/4/2007 11:40:05 PM
RE: SQL progress Posted by Cesar Chalom @ 7/5/2007 3:27:54 AM
RE: SQL progress Posted by Vladimir Zhuravlev @ 7/5/2007 6:37:12 AM
RE: SQL progress Posted by Russell Hill @ 7/5/2007 11:33:44 AM
RE: SQL progress Posted by Hans de Groot @ 7/5/2007 8:14:41 AM
RE: SQL progress Posted by Russell Hill @ 7/5/2007 8:26:10 AM
RE: SQL progress Posted by Borislav Borissov @ 7/5/2007 10:00:44 AM
RE: SQL progress Posted by Russell Hill @ 7/5/2007 11:26:06 AM
RE: SQL progress Posted by Cesar Chalom @ 7/5/2007 4:25:32 PM