Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eleanor Settles
  Where is Eleanor Settles?
 Virginia - United States
 Eleanor Settles
Subject: Query form which runs correctly one time and locks
Thread ID: 22033 Message ID: 22033 # Views: 0 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Monday, April 07, 2003 8:53:42 PM         

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.


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