The problem that I am about to detail works fine in the 3.3.1 version of DOA. I'm trying to upgrade to the lastest version, but am having this some problem:
I've created a very simply debug app. Contains one unit with a TOracleSession, TOraclewwDataSet, TwwDataSource, and a TwwDBGrid.
The DDL for the table is as follows:
CREATE TABLE ACG.USERDATSECPROFILE
(
USERDATSECPROFILEID NUMBER(10) NOT NULL,
USERID NUMBER(10) NULL,
SECURITYPROFILEID NUMBER(10) NULL
);
Contains the following trigger (which shouldn't make any difference):
CREATE OR REPLACE TRIGGER ACG.USERDATSECPROFILE_PK_TRG
BEFORE INSERT
ON ACG.USERDATSECPROFILE
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
IF
new.USERDATSECPROFILEID IS NULL) THEN
SELECT USERDATSECPROFILE_SEQ.NextVal INTO :new.USERDATSECPROFILEID FROM dual;
END IF;
END;
/
The TOraclewwDataSet has the following SQL:
SELECT ROWID, USERDATSECPROFILE.* FROM ACG.USERDATSECPROFILE
WHERE USERID = :USERID
I've defined "USERID" as a Float.
I've set the Sequence Field to the appropriate sequence and column name.
When I insert a new record and then try to post to the database, it goes into never never land.
Again, this works fine under version 3.3.1, but doesn't with the lastest version.
I can post the test app if you would like to see it. Just let me know where to send (as I can't see how to attach to here).
Help!! Thanks.
I've created a very simply debug app. Contains one unit with a TOracleSession, TOraclewwDataSet, TwwDataSource, and a TwwDBGrid.
The DDL for the table is as follows:
CREATE TABLE ACG.USERDATSECPROFILE
(
USERDATSECPROFILEID NUMBER(10) NOT NULL,
USERID NUMBER(10) NULL,
SECURITYPROFILEID NUMBER(10) NULL
);
Contains the following trigger (which shouldn't make any difference):
CREATE OR REPLACE TRIGGER ACG.USERDATSECPROFILE_PK_TRG
BEFORE INSERT
ON ACG.USERDATSECPROFILE
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
IF
new.USERDATSECPROFILEID IS NULL) THENSELECT USERDATSECPROFILE_SEQ.NextVal INTO :new.USERDATSECPROFILEID FROM dual;
END IF;
END;
/
The TOraclewwDataSet has the following SQL:
SELECT ROWID, USERDATSECPROFILE.* FROM ACG.USERDATSECPROFILE
WHERE USERID = :USERID
I've defined "USERID" as a Float.
I've set the Sequence Field to the appropriate sequence and column name.
When I insert a new record and then try to post to the database, it goes into never never land.
Again, this works fine under version 3.3.1, but doesn't with the lastest version.
I can post the test app if you would like to see it. Just let me know where to send (as I can't see how to attach to here).
Help!! Thanks.
