Filter : ORA-00904 invalid column name

[sandrine]

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

Code: Select all

Query1.sql :
Select field1, field2 
From table1

Query1.open ;

Query1.filter := ‘field1=’’AB’’’ ; 
Query1.filtered := true; 

=> generates ORA-00904 : invalid column name

What am I doing wrong ?

[Plash]

We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.