ZSQLProcessor cannot read from SET_CONTEXT

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

wienani
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 16.04.2013, 20:54

ZSQLProcessor cannot read from SET_CONTEXT

Postby wienani » 16.04.2013, 21:21

Using TZSQLProcessor/Zeos 7.0.3, why I cannot read context DOC_ID, using GET_CONTEXT always returning NULL.

Using flamerobin, success.

sorry my bad english.

Code: Select all

SELECT RDB$SET_CONTEXT('USER_TRANSACTION', 'DOC_ID', 8) FROM RDB$DATABASE;
UPDATE "mstItem" SET "ItemDeptID"= COALESCE(CAST(RDB$GET_CONTEXT('USER_TRANSACTION', 'DOC_ID') AS INTEGER),0) + ID WHERE ID=1;
UPDATE "mstItem" SET "ItemDeptID"= COALESCE(CAST(RDB$GET_CONTEXT('USER_TRANSACTION', 'DOC_ID') AS INTEGER),0) + ID WHERE ID=2;

Return to “Firebird”

Who is online

Users browsing this forum: No registered users and 1 guest