Feature request. Exporting results from query

[Ruslan Zasukhin]

On 7/1/07 11:04 PM, "Keith Hutchison" <keith.kjtl.hutchison at gmail.com>
wrote:

> G'day
> 
> 1. Please implement the ability to send the results of a query to a text file.

>From SQL Editor, right?

> 2. Please implement the ability to send the results of a query to a
> valentina table.

> Currently we have to export the data externally from valentina studio
> as a text file and then import.

STOP. 

Query to Valentina db and send result into another Valentina table ?
This can be done directly in SQL as

    INSERT INTO T1 ... SELECT ...


> 3. Please implement the ability to run an SQL statement across
> multiple datasources.
> 
> eg
> insert into valentina.analyserPlus.polls ( select bmsmysql.polls.* )

>From mySQL db into Valentina db ?

This is not easy request...

ODBC datasource, support only Vstudio.  Engine not.
But SQL parsing do engine ...


-- 
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]