Error on Insert on Table with keyword "pause" as Fieldname

[ralle1]

Hello,

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)
)   

We want to append a record with code like this:

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;

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

[AlexP]

Hello,

We've fixed this problem, please download the latest version of ODAC.

[ralle1]

Hello,

Thank you. We will try the latest version.