using oracle reserved word as FieldName

[VanRoie]

We have some existing oracle 8 table having
MODE, LANGUAGE, CONSTRAINT as FIELD NAMES

We open a live query with SELECT * FROM TABLE WHERE ...
when Inserting or updating a record we got
ORA 01747 invalid user.table.column, ...

The oracle monitor display the following statment

insert into ACT
(IDACTION, MODE, ...)
values
IDACTION, :MODE, ...)
returning rowid, MEMO into :doa__rowid, :MEMO

How can we quote the MODE field

Thanks
Domonique Van Roie

 

[Marco Kalter]

These reserved words will indeed cause problems. We'll try to fix this.

------------------
Marco Kalter
Allround Automations