> 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
Boudewijn.Lutgerink@foxite.com
Experience is the knowledge you get immediately AFTER you actually needed it...