[SQL]

[Ruslan Zasukhin]

on 12/24/03 9:45 AM, Eric Forget at forgete at cafederic.com wrote:

> Hi,
> 
> I'm trying to concatenate a few SQL statement in 1 query:
> 
> DELETE FROM Table2;
> INSERT INTO Table2 ( fldString ) SELECT DISTINCT Field1 FROM Table1;
> INSERT INTO Table2 ( fldString ) SELECT DISTINCT Field2 FROM Table1;
> SELECT * FROM Table2
> 
>> From ViSQL only the first 3 are executed (even if I put a ';' after the last
> one). From VSDK, only the first 2 and the last one are executed!
> 
> Any idea?

This not works in Valentina 1.x!
Do not do this, Eric.

 viSQL self split queries by ;


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