Re: Using Variables Within Views

In article <805546611snz@excelsis.demon.co.uk> davec@excelsis.demon.co.uk "Dave Cook" writes: > Please can you help? > > Informix RDS 4.11 SE 5.0 > > I am currently trying to develop a 'view' to form part of a security > system for an application, to allow a user to only access certain rows within a > table. My initial idea was to create the view as follows (simplified): > > CREATE VIEW view_name AS> SELECT table1.* FROM table1, table2 > WHERE table1.col1 = table2.col1 AND > table2.col2 = USER > > This gives the following error: > -217: column(user) not found in any table in the query> > Does anyone have a solution as to how I can use variables i.e. USER, within > a 'view'? > > Many thanks for your help, I have since spoken to Informix Technical Support here in the UK and they say that this is a known bug fixed in version 5.01. Thanks. > -- Dave Cook