Subject | Re: [IBO] Calling an INSERT procedure |
---|---|
Author | yaedos2000 |
Post date | 2004-12-13T18:47:41Z |
One more thing, the delphi application is running without errors, but
it's not storing the results in the database.
I'm using:
dsql.SQL := 'EXECUTE PROCEDURE PRO_INSERT_ACCOUNT
(:IN_VAR1, :IN_VAR2)'
dsql.Prepare;
dsql.ParamByName('VAR1').AsString := 'Test 1';
dsql.ParamByName('VAR2').AsString := 'Test 2';
dsql.Execute;
Is there anything else I should be doing?
Thanks
it's not storing the results in the database.
I'm using:
dsql.SQL := 'EXECUTE PROCEDURE PRO_INSERT_ACCOUNT
(:IN_VAR1, :IN_VAR2)'
dsql.Prepare;
dsql.ParamByName('VAR1').AsString := 'Test 1';
dsql.ParamByName('VAR2').AsString := 'Test 2';
dsql.Execute;
Is there anything else I should be doing?
Thanks
> oups,
>
> by coyping your sp I made the same mistake as you...
>
> Please enter:
>
> EXECUTE PROCEDURE PRO_INSERT_ACCOUNT (:IN_VAR1, :IN_VAR2)
>
> in the SQL property of the TIB_DSQL component.
>
> ;-)
>
> Luc.