views

[Danny Lewkin]

Done! ;-)

http://valentina-db.com/bt/view.php?id=2552

Greetz,

Danny



Op 6-aug-07, om 12:40 heeft Ivan Smahin het volgende geschreven:

> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina