Subject Re: [IBO] Update SQL & Parameters
Author sdbeames
I've just tried...

void __fastcall TEqptForm::ModelQryAfterScroll(TIB_Dataset
*IB_Dataset)
{
IdentQry->Params->BeginUpdate();
try {
IdentQry->ParamByName("MODEL_ID")->AsInteger =
ModelQry->FieldByName("MODEL_ID")->AsInteger;
IdentQry->ParamByName("DOC_FILE_ID")->AsInteger =
DocFileQry->FieldByName("DOC_FILE_ID")->AsInteger;
}
__finally {
IdentQry->Params->EndUpdate(true);
};

with no effect. The params must be getting to the select proc,
because my grid is showing the right selection of rows.

> If you have an insert proc why arent you using it? I believe that
you
> must have intended to have in the InsertSQL was something like...
>
> EXECUTE PROCEDURE EQPT_IDENT_INSERT_PROC(
> :IDENT_ID,
> :MODELID,
> :IDENT )

Yes, sorry, I originally had that, but changed it while playing.

Just tried it again, but still no go.
Even tried using :OLD_MODELID, but no difference.

Has anyone actually been able to get this to work before?

Cheers,
Steve