Subject | Re: [IBO] Update SQL & Parameters |
---|---|
Author | sdbeames |
Post date | 2002-02-02T05:56:02Z |
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.
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
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 thatyou
> must have intended to have in the InsertSQL was something like...Yes, sorry, I originally had that, but changed it while playing.
>
> EXECUTE PROCEDURE EQPT_IDENT_INSERT_PROC(
> :IDENT_ID,
> :MODELID,
> :IDENT )
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