Subject Re: SQL statement not working on the form From AGOSTINHO <AGOSTINHOTEIXEIRA@YAHOO.COM> Date Mon, 31 Aug 2020 23:19:36 -0400 Newsgroups dbase.getting-started Many thanks to Marvin Bick, Gaetano and Akshat Kapoor for your great help Will practice and will let you know Agostinho Mervyn Bick Wrote: > On 2020-08-31 09:00, Gaetano wrote: > > > > Hi Agostinho, > > > > I am attaching an example that works for me using a pushbutton to change > > the SQL statement. > > > > It is important to have a % in the original query else I was getting > > memory access violations when trying to use % in the requery(). > > > > The form is under c:\dbasetutorial and the table and memo file under > > c:\dbasetutorial\tables but you can edit the paths in the Form to meet > > your needs (open the form in the  source editor to update paths else you > > may get warning about files not existing) > > > > I will let the experts confirm that this is a valid way. > > Stop the bus!  :-) > > There are a couple of issues here. > > On occasion, for instance where you want to change the display in a grid > from one table to another, it is necessary to change the sql property of > a query.  This should, however, not normally be done.  If you do need to > do it, you need to set the query's active property false, change the sql > string and then set the query's active property true to fetch the new > data for display. > > If you need to change the data displayed from the same table either use > a filter or a parameter driven query.   A filter works but it has > limitations.  With a parameter driven query, to fetch new records simply > change the parameter(s) and requery(). > > Mervyn. > > > >