Subject | strange behavior of ParamByName |
---|---|
Author | Riste Pejov |
Post date | 2003-01-21T13:35:38Z |
in_q is of type TIB_Query
everything works fine ... but ...
in_q->SQL->Add("select p.ftp_path ftp_path,p.trans_type
ftp_type,p.filesize ftp_size,p.file_id as kid from");
in_q->SQL->Add("pending_files p left outer join transfered_files t");
in_q->SQL->Add("on p.file_id=t.file_id where (t.file_id is
null)AND(p.bank_id='"+bank_id+"')");;
in_q->Active=true;
in_q->First();
ShowMessage(in_q->ParamByName("kid")->AsString); //<<-- error
why ?
everything works fine ... but ...
in_q->SQL->Add("select p.ftp_path ftp_path,p.trans_type
ftp_type,p.filesize ftp_size,p.file_id as kid from");
in_q->SQL->Add("pending_files p left outer join transfered_files t");
in_q->SQL->Add("on p.file_id=t.file_id where (t.file_id is
null)AND(p.bank_id='"+bank_id+"')");;
in_q->Active=true;
in_q->First();
ShowMessage(in_q->ParamByName("kid")->AsString); //<<-- error
why ?