Hallo,
gibts bei TIBSQL eine Möglichkeit den aufgelösten SQL-String anzuzeigen
(s.u. Kommentar im Beispiel)?
AnsiString sql="select * from daten where datum between :start and :end and ser_nr between :sn_start and :sn_end and art_nr between :art_start and :art_end order by datum,zeit";
TIBSQL *IBSQL;
IBSQL = new TIBSQL(NULL);
IBSQL->Database = DataModule1->IBDatabase1;
IBSQL->Transaction = DataModule1->IBTransaction1;
IBSQL->SQL->Clear();
IBSQL->SQL->Add(sql);
IBSQL->ParamByName("start")->AsString = dvon->Date;
IBSQL->ParamByName("end")->AsString = dbis->Date;
IBSQL->ParamByName("sn_start")->AsString = Svon->Text;
IBSQL->ParamByName("sn_end")->AsString = Sbis->Text;
IBSQL->ParamByName("art_start")->AsString = Avon->Text;
IBSQL->ParamByName("art_end")->AsString = Abis->Text;
// hier würde ich gerne die aufgelöste SQL Abfrage analysieren:
// NICHT: select * from daten where datum between :start and :end and ...
// wie z.B. IBSQL->SQL->GetText() zurückliefert.
// sondern: select * from daten where datum between '2011-11-11' ....
IBSQL->ExecQuery();
gibts bei TIBSQL eine Möglichkeit den aufgelösten SQL-String anzuzeigen
(s.u. Kommentar im Beispiel)?
AnsiString sql="select * from daten where datum between :start and :end and ser_nr between :sn_start and :sn_end and art_nr between :art_start and :art_end order by datum,zeit";
TIBSQL *IBSQL;
IBSQL = new TIBSQL(NULL);
IBSQL->Database = DataModule1->IBDatabase1;
IBSQL->Transaction = DataModule1->IBTransaction1;
IBSQL->SQL->Clear();
IBSQL->SQL->Add(sql);
IBSQL->ParamByName("start")->AsString = dvon->Date;
IBSQL->ParamByName("end")->AsString = dbis->Date;
IBSQL->ParamByName("sn_start")->AsString = Svon->Text;
IBSQL->ParamByName("sn_end")->AsString = Sbis->Text;
IBSQL->ParamByName("art_start")->AsString = Avon->Text;
IBSQL->ParamByName("art_end")->AsString = Abis->Text;
// hier würde ich gerne die aufgelöste SQL Abfrage analysieren:
// NICHT: select * from daten where datum between :start and :end and ...
// wie z.B. IBSQL->SQL->GetText() zurückliefert.
// sondern: select * from daten where datum between '2011-11-11' ....
IBSQL->ExecQuery();
Comment