views

[Ivan Smahin]

Hello Danny,

Monday, August 6, 2007, 1:23:50 PM, you wrote:

> Hey Ivan, List,

> could you try this :

> Create a table tbl_test, with field fld_A, fld_B,...
> Then create a view vw_test  "SELECT fld_A, fld_B FROM tbl_test.
> Then, try to run this query:
> 'SELECT * FROM vw_test ORDER BY fld_A'
> When I try this, I get an VException :

> 12:17:15: Error: Identifier "fld_A" is not found.
> 12:17:15: Error: Kernel error: 0x51500
> 12:17:15: Error: Identifier "fld_A" is not found.

> But when I try this :

> 'SELECT fld_A, fld_B FROM vw_test ORDER BY fld_A',
> then it works fine...
> So, why does the first query work on a regular table, but not on a view?
> Should I put this into mantis?

Yes, please - seems to be a bug.

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com