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

[Ruslan Zasukhin]

on 2/1/04 1:14 AM, 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.

Hi Frank,

Ok, this is standard?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------