VCOM: Problem with SHOW tables

[Kirill Pekarov]

Hi, Martin.

You wrote 18.10.2007, 15:23:46:

>>> When I execute the following command in VStudio:
>>> SELECT * FROM (SHOW TABLES) WHERE kind_str = 'user' ;
>>> it works.

This query: "SELECT * FROM (SHOW TABLES) WHERE kind_str = 'user'"
do not work in the VStudio and in the VCOM.

But this is works:
SELECT * FROM (SHOW TABLES) WHERE kind_str = 'USER'
>                                            ^^^^^^



-- 
Best regards,

Kirill Pekarov
Software Engineer Associate
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com