Subject Re: [IBO] Calling an INSERT procedure
Author Lucas Franzen
yaedos2000 schrieb:

>
> 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?

Yes, committing the transaction.

Luc.

P.S.:
Instead of the procedure you could use the insert statement in the
TIB_DSQL as well. You don't have to write stored procedures for doing
inserts.