🚀 go-pugleaf

This is an example:

ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("INSERT INTO Cars (MD_Num, MD_Name, _Style, _Year)
VALUES (:MDNum, :MDName, :Style1, :_Year)");
ADOQuery1->Parameters->ParamByName("MDNum")->Value = IntToStr(i);
ADOQuery1->Parameters->ParamByName("MDName")->Value = "Car " + IntToStr(i);
ADOQuery1->Parameters->ParamByName("Style1")->Value = "Style " +
IntToStr(i);
ADOQuery1->Parameters->ParamByName("_Year")->Value = IntToStr(i);
ADOQuery1->ExecSQL();
ADOQuery1->Open();

Notice that MDNum is Integer, MDName is AnsiString, _Style is AnsiString and
_Year is Integer;

Regards,
Mehrdad


"Junlin Xie" <jlxie@yahoo.com> wrote in message news:3d04779b_2@dnews...
> Hi,
>     I want to query data from using ADODataSet, the SQL as following:
>
>     Select * from Suppliers where SuppID in (:SuppList),
>
>     Supplist = "'111', '222', '333'";
>     I set ADODataSet->Parameters->ParamByName("SuppList")->Value =
Supplist;
>
>     But It does not work, How to set parameters for the kind of SQL
> statement?
>
>     Thank you very much!
>
> Junlin Xie
>
>
>