Filter : ORA-00904 invalid column name
Posted: Thu 04 Sep 2008 13:21
Hi,
Configuration : Delphi 7 – Client Oracle 7.3 – Server Oracle 7.3.4 – ODAC 6.50.0.37
How does filter work ? I ‘ve got ora-00904 everytime I try to filter a Toraquery.
Query1 is Toraquery and is linked to an opened connection.
Field1 type is VARCHAR2(32);
=> generates ORA-00904 : invalid column name
What am I doing wrong ?
Configuration : Delphi 7 – Client Oracle 7.3 – Server Oracle 7.3.4 – ODAC 6.50.0.37
How does filter work ? I ‘ve got ora-00904 everytime I try to filter a Toraquery.
Query1 is Toraquery and is linked to an opened connection.
Field1 type is VARCHAR2(32);
Code: Select all
Query1.sql :
Select field1, field2
From table1
Query1.open ;
Query1.filter := ‘field1=’’AB’’’ ;
Query1.filtered := true; What am I doing wrong ?