[SQL]

[Eric Forget]

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?

Éric

___________________________________________________________________

 Eric Forget                       Cafederic
 ForgetE at cafederic.com             <http://www.cafederic.com/>

 Fingerprint <86D5 38F5 E1FD 5D9C 71C3  BAA3 797E 70A4 6210 C684>