Subject | TIB_Query |
---|---|
Author | yartax1 |
Post date | 2004-11-17T17:17:47Z |
Hi,
With a TIB_Query I have next statement:
"Select a.id, a.name from master_table where a.code = 1"
When I need to perform another select with the same query like
"Select a.id, a.name from master_table where a.code = 4"
Is better to close/open with new SQL entry or doing next commands:
SQL->Clear();
SQL->Add("Select a.id, a.name from master_table where a.code = 4")
SQL->Refresh();
Is better use Params or create the where condition and pass as a
unique SQL command like example?
I want to minime overload.
Thanks
Julian.
With a TIB_Query I have next statement:
"Select a.id, a.name from master_table where a.code = 1"
When I need to perform another select with the same query like
"Select a.id, a.name from master_table where a.code = 4"
Is better to close/open with new SQL entry or doing next commands:
SQL->Clear();
SQL->Add("Select a.id, a.name from master_table where a.code = 4")
SQL->Refresh();
Is better use Params or create the where condition and pass as a
unique SQL command like example?
I want to minime overload.
Thanks
Julian.