Mike,
No, there is nothing wrong with the progress bar, all I wanted to find out with this thread was if I could show a progress bar, and have the user continue to use the form while the query is being executed.
(I forgot to mention in my OP that I'm already using a progress bar informing the...
Thanks for the responses,
I'm not actually fetching large amounts of data, but I'm calculating something. This involves summing and joining. Maybe the query can be tweaked abit, but it will still take some time for giving the UI a chance to freeze up.
In anyway, thanks for the tips, I will...
Mike,
Thanks again for the quick response.
I was hoping VFP offered something like asynchronous programming used in .NET (or even use different threads),
but since that is not the case I will follow your advice.
Dirk
...code following the example from Mike Lewis (link: http://www.tek-tips.com/viewthread.cfm?qid=801062).
Here's the code:LOCAL lnConn,lcQuery,lnRes
*** Setting up the connection.
lnConn = SQLCONNECT("dsn_name","login","pass")
SQLSETPROP(lnConn,"Asynchronous",.t.)
*** The query which will take...
Mike,
Thanks for the quick response!
While looking for these files (you didn't mention a specific location) I saw these files were stored in C:\Documents and Settings\<USER>\Application Data\Microsoft\Visual FoxPro.
Seeing the path, it reminded me that you can adjust some file locations. It...
Hi all,
I've been using VFP7 for some time now and I've never had any problems with the IDE. But since last friday all my settings are gone. Each and every time I start VFP the IDE is in its default state. Redecorating my IDE to my likings is something I want to do once, and not each time I...
Bart,
Your suggestion to make the object reference a property of my main form is more OOP, I will implement that.
this.searchform = createobject('myclass')
This won't work, since my class isn't a form an sich. The search form is but a part of it.
...came up with another solution. I've created a Close method which I call explicitly in my main form's Destroy event:myObject.Close
RELEASE myObject
*** Release other resources
The myObject.Close method is, in fact, my old Destroy method.
This way I'm keeping al my cleaning up code in one...
...form I do the following in its Destroy event:RELEASE myObject
I put a Destroy procedure in myClass which should handle this: PROCEDURE Destroy
*** If search form is still open, close it.
IF VARTYPE(This.m_oSearchForm) = "O" THEN
This.m_oSearchForm.Release
ENDIF
ENDPROC
And...
Hello people,
According to a comment here one should not use GetAdaptersInfo in Windows 2003/XP.
Some of our software uses this function and sometimes it returns with an error. This behaviour is (so far it seems) completely random.
So now I'm wondering: is the comment in the link I provided...
I haven't tested it so far, another project has my attention so far, but I will post my findings here whenever I have some.
Tamar, this form indeed contains a grid, I will look at the grid events if anything happens. Strange thing is this form is used for over 6 months now and this bevahiour...
Yes, it only occurs when the user much choose a printer. But it does not occur always, roughly each 3rd or 4th time.
Yep, that is, after the user selected their printer.
Tested it on different printers, behaviour showed on all printers.
Stella,
I'm 100% sure there is nothing wrong with the cursor I use, since my previews are always correct.
When my strange behaviour occurs, it will print the first line of either the first page or the second page (haven't tested it with report which had more pages). And it always occurs when...
I've been testing on different systems and the behaviour is not 100% reproduceable.
What I've found out is that whenever I print a report via the following code, the behaviour occurs roughly each 3rd or 4th time:REPORT FORM ".\report" TO PRINTER PROMPT NOCONSOLE
Using a different setup where...
Hello all,
Since last week some of my reports are showing strange behaviour. I usually have one cursor being 'consumed' in my reports and where it normally prints all lines, all of a sudden only the first line is printed.
On the preview the report looks good (i have all the lines on my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.