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 D.O.T 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
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2004 Frank Schima |
