da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: use tempory table

Forum List » NCOCI8 » General English

Yuriy
User

Fresh Boarder

Posts: 1

Karma: 0

use tempory table

Posted: 2002/07/03 04:02

Hello
I'am use oracle tempory table

<tmp_table:TOCIQUery>
tmp_table.Edit;
tmp_table.AppendRecord([....]);

I have trigger BEFORE INSERT whitch calc some fields

After append record in dbgrid don't visible calc field value

This problem don't present if i'am use standart Delphi TTable. I'am use table.refresh

If i do refresh on TOCIQuery tempory table is clearing
???

Mur
User

Platinum Boarder

Posts: 116

Karma: 0

RE: use tempory table

Posted: 2002/07/07 23:38

From Oracle8i Concepts: "For transaction-specific temporary tables, data exists for the duration of the transaction"
If you use implicit transaction control, NCOCI starts transaction, inserts record and then commits. At this moment record disappears.
You should use explicit transactin control (DataBase.StartTransaction, Commit, Rollback)
Or use session-specific temporary tables.

Forum List » NCOCI8 » General English