Re: TADODataset.Filter?


But if I close the dataset will then not also the SQL SELECT command
be executed again

Yes it will, I had it in my example but I should have removed it. One thing you should
do is DisableControls and after updating the Filter then EnableControls
so the DbGrid will then refresh itself.

ADODataSet1.DisableControls;
ADODataSet1.Filtered := false;
ADODataSet1.Filter := 'LastName Like ' + QuotedStr('Fu*'); //Fuller
ADODataSet1.Filtered := true;
ADODataSet1.EnableControls;

.

Relevant Pages

  • Re: Refreshing application during SQL - command
    ... > How to refresh application while this application executes function (SQL ... > I have a Button which call function who executes long SQL command) ...
    (comp.lang.cpp)
  • Refreshing application during SQL - command
    ... How to refresh application while this application executes function (SQL ... I have a Button which call function who executes long SQL command) ...
    (comp.lang.cpp)
  • Re: COBOL stored procedure for DB2
    ... Regarding how you precompile the app, you must specify target mfcob to db2 prep, rather than target ibmcob. ... Have you also confirmed that, prior to executing the CALL statement, the host variables specified within the client app have the appropriate values? ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: COBOL stored procedure for DB2
    ... Have you also confirmed that, prior to executing the CALL statement, the ... The DB2 CREATE PROCEDURE statement. ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: Can I get Consultancy advice on SQL/Fox in the UK (South East)
    ... My problem is the two Sequel Server tables within one database with which I ... Don't ask me why but the SQL designers have NOT ... command that I can initiate with SQLCONNECT, ... > While you're in the View Designer, right-click and view the SQL code. ...
    (microsoft.public.fox.helpwanted)