🚀 go-pugleaf

Dear all,

Are parameters only workable in "where" part of a ADOQuery's SQL statement?
I have the following code that does not work:

ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select * from :TBL_NAME where id=':REC_ID'");
ADOQuery1->Parameters->ParamByName("TBL_NAME")->Value = EditTblName->Text;
ADOQuery1->Parameters->ParamByName("REC_ID")->Value = EditRecID->Text;
AnsiString chkStr1 = ADOQuery1->Parameters->ParamByName("TBL_NAME")->Value;
AnsiString chkStr2 = ADOQuery1->Parameters->ParamByName("REC_ID")->Value;
AnsiString chkStr3 = ADOQuery1->Parameters->ParseSQL(ADOQuery1->SQL->Text,
true);
ADOQuery1->Open();

chkStr1 and chkStr2 show both parameters are set properly, but chkStr3
always shows "select * from ? where id=':REC_ID'".  Exception of something
like "Parameters objects are not properly set..." is thrown when I attempt
to open the query.

The implementation as below works fine:

ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select * from ");
ADOQuery1->SQL->Add(EditTblName->Text.c_str());
strcpy(_tmpStr, EditRecID->Text.c_str());
sprintf(&sqlstr[0], "where id=\'%s\'", _tmpStr);
ADOQuery1->SQL->Add(sqlstr);
AnsiString chkStr = ADOQuery1->SQL->Text;

chkStr shows correct concatenation for the SQL statement.

FYI, I am using BCB5 and MSSQL Server 2000.

Thanks for any advice,
Patrick