Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Boudewijn Lutgerink
 To: Eleanor Settles
  Where is Eleanor Settles?
 Virginia - United States
 Eleanor Settles
Subject: RE: Query form which runs correctly one time an...
Thread ID: 22033 Message ID: 22069 # Views: 0 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, April 08, 2003 11:32:43 AM         

> I have a form which performs SQL queries on a table. When the form opens
> it displays a general query with no parameters. However the user is given
> the opportunity to select certain records from the table and the ability to
> order them the way he wants. The form is for record selection. This form
> is activated by clicking on a button on a screen.
> I have just noticed that the first time the query is called it performs
> properly however after exiting the query form I try to execute it again the
> form opens and displays the initial query but the form is locked. You
> cannot select anything nor can you exit.
> I have been playing with it. If I issue a 'Set Step On' and then a 'Resume'
> the lockup doesn't occur. I can access the form as many time as I want
> without lockup. I don't know what is causing the locking and really I don't
> care as the form works perfectly. I just want to get around this locking
> issue. If a "Set Step On" allows it to function properly the 2nd time thru
> then there must be some command I can issue which would give the same result
> without causing the user a problem.
> Any suggestions would be appreciated.
> Eleanor
What I read from your msg is that you have a SQL select to some cursor, right?
maybe closing the cursor first and the performing the sql select would work.

Select * from bagger into cursor cMyFilteredBagger
* display data, make new selections et cetera

* close the cursor but leave the table open
use in select("cMyFilteredBagger")

* query again...
Select * from bagger into cursor cMyFilteredBagger

* display data again

Boudewijn LutgeĀ®ink
Experience is the knowledge you get immediately AFTER you actually needed it...


Query form which runs correctly one time and locks Posted by Eleanor Settles @ 4/7/2003 8:53:42 PM
RE: Query form which runs correctly one time an... Posted by Boudewijn Lutgerink @ 4/8/2003 11:32:43 AM