Subject | How to clear IB_Query parameters? |
---|---|
Author | rhystucker@yahoo.com |
Post date | 2001-02-20T18:01:35Z |
I have a IB_Query connected to a IB_Grid which I want to refresh so
that it reflects changes in the table. The SQL query is simply 'SELECT
* FROM tablename;'. How can I refresh these paramaters?
thanks,
rhys
void __fastcall TMain::Button2Click(TObject *Sender)
{
DMod1->IB_Qry2->Prepare();
DMod1->IB_Qry2->Open();
/*
// Problem - IBO preserves parameter values
DMod1->IB_Qry2->InvalidateSQL();
DMod1->IB_Qry2->Unprepare();
DMod1->IB_Qry2->ClearSearch();
DMod1->IB_Qry2->Close();
DMod1->IB_Qry2->DataChange();
DMod1->IB_Qry2->FetchAll();
DMod1->IB_Qry2->RefreshAll();
*/
}
that it reflects changes in the table. The SQL query is simply 'SELECT
* FROM tablename;'. How can I refresh these paramaters?
thanks,
rhys
void __fastcall TMain::Button2Click(TObject *Sender)
{
DMod1->IB_Qry2->Prepare();
DMod1->IB_Qry2->Open();
/*
// Problem - IBO preserves parameter values
DMod1->IB_Qry2->InvalidateSQL();
DMod1->IB_Qry2->Unprepare();
DMod1->IB_Qry2->ClearSearch();
DMod1->IB_Qry2->Close();
DMod1->IB_Qry2->DataChange();
DMod1->IB_Qry2->FetchAll();
DMod1->IB_Qry2->RefreshAll();
*/
}