C++Builder SQL- , BDE Paradox dBase, InterBase [1].
SQL TQuery TString. TQuery , SQL:
Query1->Close();
Query1->SQL->Clear(0;
, :
Query1->SQL->Add(Select * from Customer);
Query1->SQL->Add(where... =1111 );
Add SQL- , . C++Builder , , :
Query1 ->Open();
Open , . - , ExecSQL, Open. SQL , SQL , . LoadFromFile .
C++Builder . where insert SQL-.
, :
Select * from Country where Name like C%;
like , , NameStr:
Select * from Country where Name like: NameStr;
SQL . Params TQuery. DataSource. , :
__property TParams *Params;
TParam *__fastcall ParamByName(const System::AnsiString Value);
void __fastcall Prepare(void);
TParam TParams DBTABLES.HPP. Params :
, ;
Query, Prepare.
Params.
.
SQL- , Format. VCL- Format sprintf. .