Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL progress bar
Message
 
To
20/05/1998 08:02:40
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00100111
Message ID:
00100647
Views:
49
>>>Hello Don,
>>>
>>>>Please remember that not all of us are "select members" of Universal
>>>I'm not have this option either ;).
>>>>Thread - only paying guests have access to the search feature. It is more
>>>>helpful to just say which library an article is in.
>>>Actually, I don't know (it was a long time ago) .
>>>As you wish, here is an idea:
>>>
>>>thisform.progressbar.MaxValue = reccount()
>>>thisform.progressbar.Value = 0
>>>
>>>select , updateprogress();
>>> from table1;
>>> blah blah blah
>>> into cursor tmp
>>>thisform.progressbar.Value = thisform.progressbar.Maxvalue
>>>
>>>function updateprogress
>>> thisform.progressbar.value = _tally
>>>return .t.
>>>
>>>That's all! Hope it helps.
>>>
>>>
>>>
>>>P.S. Sorry for late reply, but my ISP gave me a hard time today with their BUSY.
>>
>>Vladimir,
>>
>>Have you ever done timing tests with this setup? How much slower is a SQL query with the updateprogress() embedded as opposed to one without it? Just curious as I'd like to do something like that but am afraid that I'd lose too much time.
>>
>>Steve
>Steve,
>Not to flatter you or someone else but isn't VFP default progress bar sufficient for SQL. With an SQL that would take time of course it might be little importance to include another time consuming process. What currently I do for such SQL(s) to set talk on before and immediately set talk off.
>Cetin

Cetin,

The default (SET TALK ON) status bar is fine for me. But remember, I'm not the one using the system, I just write it. For those who are signing the checks, the VFP default is typically unsightly and most all would prefer to see what is considered a Windows standard......that lovely little Active-X progress bar.

I've also found that SET TALK ON doesn't typically work well in a top-level form. I'm sure it outputs to _SCREEN just fine, but I've not gotten it work well in a top-level form. I'm sure I need to use a DEFINE WINDOW to get it to work there but I've not had the time to experiment with that yet.

Steve
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform