EOracleError:ORA-01008: not all variables bound

[sandy_k]

Help, pls!!!

In OnApplyRecord event:

if(Action=='I') {
AnsiString strInsert="begin \
insert into header (id_header, name) \
values id_header, :name) \
returning rowid into :v_rowid; \
commit; \
end;" ;
Query->Close();
Query->SQL->Clear();
Sender->DeleteVariables();
Sender->DeclareVariable("id_header", otInteger);
Sender->DeclareVariable("name", otString);
Sender->DeclareVariable("v_rowid", otInteger);
Sender->SetVariable("id_header",Sender->FieldByName("id_header")->AsInteger);
Sender->SetVariable("name",Sender->FieldByName("name")->AsString);
Query->SQL->Add(strInsert);
Query->Execute();
Applied=true;
}
...
I've got an error "ORA-01008: not all variables bound" on Query->Execute().
Why? How?

 

[Marco Kalter]

Shouldn't all references to "Sender" be replaced by "Query"?

------------------
Marco Kalter
Allround Automations