Subject | Re: [IBO] Calling an INSERT procedure |
---|---|
Author | Lucas Franzen |
Post date | 2004-12-13T18:55:45Z |
yaedos2000 schrieb:
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.
>Yes, committing the transaction.
> 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?
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.