BorlandTalk.com

Henrique · Guest

Hi,

I have an application originally in BDE with Sybase ASA 8 that I´m
translating to DBX using ASA DBX Driver. I use D7.1, ASA 8/9.

I use some stored procedures to create resultsets from temporary tables for
some reports. Inside this procedure I create a temporary table, insert some
data and at the end of procedure I return a select from this temptable. To
get this result set I use Query with SQL calling procedure or using
TStoredProc as a DataSet.

In BDE everythings works fine but in DBX this procedure increments TranCount
and I have transaction control problems manly when I call another procedure
after this report with transaction control. In BDE I seams that after
calling this query it commit´s work (see from SQLMonitor) but in DBX there
is no commit or rollback. So, when I call another procedure it rollsback
until my first procedure.

It happens because in ASA inserts in temp tables starts a transaction
automatically. BDE handles it with commit or rollback. There is a way to do
it in DBX? How can I force DBX to behave "like BDE" in this case? Is there
another way to solve it.

tia,

Henrique