New transaction object

[helgen]

Hi

I've replaced my apps default transaction object SQLCA with "my_trans". In my applications open-event I set:
transaction my_trans
my_trans = create transaction

It connects OK to the database.

The problem is that dynamic SQL (format 3) doesn't work anymore. I recieve error message "Database command has not been successfully prepared". I have tried to replace SQLSA with a new variable my_sqlsa (of type DynamicStagingArea).

Can anyone help?

regards,
Helge

 

[BetterLateThanNever]

Hi,

When you issue your

PREPARE DynamicStagingAreaVariable FROM SQLStatement

are you using the

 USING transactionobject

clause?

i.e. assuming your transaction object my_trans:

DECLARE my_cursor DYNAMIC CURSOR FOR SQLSA ;

sqlstatement = "some sort of SQL"

PREPARE SQLSA FROM :sqlstatement USING my_trans;
                                 ^^^^^^^^^^^^^^
OPEN DYNAMIC my_cursor;

FETCH my_cursor INTO :A_Variable ;

CLOSE my_cursor ;

SQLSA is a system-provided staging area - there is nothing special about it.

Cheers.

 

[helgen]

How could I miss that...
Thanks.
Helge