Error on Insert on Table with keyword "pause" as Fieldname
Posted: Wed 10 Nov 2010 14:32
Hello,
we've got a problem with an Delph2007 / ODAC Application:
There is a Table in our Oracle DB like this:
We want to append a record with code like this:
On post we get the following error:
ORA-01400: Einfügen von NULL in ("MYSESSION"."TABLE1"."PAUSE") nicht möglich
The same example without the column PAUSE (i.g. with IPAUSE) runs successfully but we do not have the possibility to rename the column.
We are using the version "Devart ODAC 6.80.0.47 for Delphi 2007 for Win32".
Thank you for your help.
Best regards
we've got a problem with an Delph2007 / ODAC Application:
There is a Table in our Oracle DB like this:
Code: Select all
CREATE TABLE Table1 (
ID NUMBER(10, 0) NOT NULL,
PAUSE NUMBER(10, 0) NOT NULL,
TEXT VARCHAR2(40),
Primary Key(ID,PAUSE)
) Code: Select all
OraQuery.Connection := OraSession1;
OraQuery.SQL.Add('SELECT ID,PAUSE,TEXT FROM Table1');
OraQuery.Open;
OraQuery.Append;
OraQuery.FieldByName('ID').AsInteger := 1;
OraQuery.FieldByName('PAUSE').AsInteger := 0;
OraQuery.FieldByName('TEXT').AsString := 'Test';
OraQuery.Post;ORA-01400: Einfügen von NULL in ("MYSESSION"."TABLE1"."PAUSE") nicht möglich
The same example without the column PAUSE (i.g. with IPAUSE) runs successfully but we do not have the possibility to rename the column.
We are using the version "Devart ODAC 6.80.0.47 for Delphi 2007 for Win32".
Thank you for your help.
Best regards