why does put revOpenDatabases() not work?

[Ruslan Zasukhin]

On 6/7/08 4:07 PM, "william humphrey" <shoreagent at gmail.com> wrote:

>>    a) SQL Editor
>>    b) Query Builder
>> 
>> Yes - I have been doing all my design and import of data of my database in
>> vStudio. Query builder is not able to do much though.
>> 
> 
> I tried to build a SQL like below in it and couldn't but I used the editor
> and tests from it very successfully.
> 
> SELECT ifnull ( info_clients.i_clients_IsCompany,
> info_clients.i_clients_companyname , info_clients.i_clients_firstname || ' '
> || info_clients.i_clients_middlename  || ' ' ||
> info_clients.i_clients_lastname) as 'client name'
> FROM info_clients

:-)

Well, yes,

Query Builder cannot e.g.

    * build queries with OUTER JOING
    * with UNION, INTERSECT
    * with sub-queries

Actually MS SQL also cannot do these tasks in Query Builder.
But we have some ideas how improve that.

Functions ... It needs to think about this.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]