Valentina 2.0. -- What is your 3 DREAM features?

[Frank Schima]

On Jan 31, 2004, at 4:46 PM, Ruslan Zasukhin wrote:

> on 1/31/04 11:28 PM, Frank Schima at frank-list2 at mindstarprods.com 
> wrote:
>
>> I was just thinking of on the fly temp table creation for complex SQL
>> selects so you can easily sub-select from it. Like this:
>>
>> SELECT a, b, c
>> FROM table1, table2, table3
>> WHERE condition1 AND condition2...
>> INTO new_table
>
> Frank, this can be done right now in 1.x using
>     INSERT  ... (SELECT)
>
> Something exist for such task.
>
>
> Does in above query, DBMS should self create new TMP table according 
> cursor
> fields? Or that new_table must be prepared manually before query?

The DBMS should automatically create a new TMP table based on the 
fields SELECTed in the Query. That's what I meant by "on the fly" table 
creation.


Best regards,
Frank