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?

I suggest you watch the SQL trace monitor carefully and also check your
transaction isolation factors.

I think the updates you are looking for happened by either they were not
committed properly or the transaction you are looking for the changes is a
snapshot read.

Jason