Subject | IBO Stored Procedures |
---|---|
Author | Andrew |
Post date | 2006-11-06T12:01:54Z |
Hi,
I have an application that creates a Dynamic Stored procedure and
assigns this to a StoredProcedure within the database.
Process of events is as follows.
Create Stored Procedure.
Assign IB_Connection Property
Assign Stored Procedure Name.
Prepare Stored Procedure.
Assign Parameters to Stored Procedure
Execute Stored Procedure
I do not receive any error messages, however the data I expect to be
created/updated Remains unaltered..
Do I need to add an additional step, I have to many Stored procedures
to add a component to a datamodule for each therefore I create the
Dynamic one and amend the Procedure name and prepare it.
Am I right to beleive that the PREPARE statement will set the SQL of
the Stored Procedure?
Thanks
Andrew
I have an application that creates a Dynamic Stored procedure and
assigns this to a StoredProcedure within the database.
Process of events is as follows.
Create Stored Procedure.
Assign IB_Connection Property
Assign Stored Procedure Name.
Prepare Stored Procedure.
Assign Parameters to Stored Procedure
Execute Stored Procedure
I do not receive any error messages, however the data I expect to be
created/updated Remains unaltered..
Do I need to add an additional step, I have to many Stored procedures
to add a component to a datamodule for each therefore I create the
Dynamic one and amend the Procedure name and prepare it.
Am I right to beleive that the PREPARE statement will set the SQL of
the Stored Procedure?
Thanks
Andrew