Re: [Squirrel-sql-users] MySql

[Colin B. <co...@ba...>]

On Tue, Dec 05, 2006 at 06:52:41AM -0600, Savoy, Melinda wrote:
> Robert,
> 
> Thanks for the response.  I tried what you suggested however, this is
> what is happening.  I have a .sql script whereby I drop tables, create
> tables and then insert data into multiple schemas.
> 
> It would appear that after I run the entire script the DROP tables runs
> successfully but I do not see that any of the tables have been created
> and consequently no data has been inserted.  I have to run the CREATE
> and INSERT separately.

The attached script works for me:

0 Row(s) Updated
Query 1 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 2 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 3 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 4 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 5 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 6 of 28 elapsed time (seconds) - Total: 0.003, SQL query: 0.003,
Building output: 0
0 Row(s) Updated
Query 7 of 28 elapsed time (seconds) - Total: 0.034, SQL query: 0.034,
Building output: 0
0 Row(s) Updated
Query 8 of 28 elapsed time (seconds) - Total: 0.002, SQL query: 0.002,
Building output: 0
0 Row(s) Updated
Query 9 of 28 elapsed time (seconds) - Total: 0.049, SQL query: 0.049,
Building output: 0
1 Row(s) Updated
Query 10 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 11 of 28 elapsed time (seconds) - Total: 0.002, SQL query:
0.002, Building output: 0
1 Row(s) Updated
Query 12 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 13 of 28 elapsed time (seconds) - Total: 0.002, SQL query:
0.002, Building output: 0
1 Row(s) Updated
Query 14 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 15 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 16 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 17 of 28 elapsed time (seconds) - Total: 0, SQL query: 0,
Building output: 0
1 Row(s) Inserted
Query 18 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 19 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 20 of 28 elapsed time (seconds) - Total: 0, SQL query: 0,
Building output: 0
1 Row(s) Inserted
Query 21 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 22 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 23 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 24 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 25 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 26 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 27 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
Query 28 of 28 elapsed time (seconds) - Total: 0.103, SQL query:
0.002, Building output: 0.101

PKEY         ENTITYCODE  OPERTRID  RECRDSTATUSCODE  RECRDSTATUSDATE
RECRDTYPE  SUBSYSTMNAME  VALADDCODE  VALADDDESCR
                  VALADDKEY                       
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1            PHA         xxxxxx    A
VAR        INV           CAPLMT      9999999
                                                  
2            PHA         xxxxxx    A
VAR        INV           COMTYP      ALL
                                                  
3            PHA         xxxxxx    A
VAR        INV           DEPT        ALL
                                                  
4            PHA         xxxxxx    A
VAR        INV           NSKLMT      9999999
                                                  
5            PHA         xxxxxx    A
VAR        INV           PURCH       8681
                                                  
6            PHA         xxxxxx    A
VAR        INV           STKLMT      9999999
                                                  
7            PHA         xxxxxx    A
VAR        INV           REPORT      ALL
                                                  
8            PHP         xxxxxx    A
VAR        INV           ACCT        12500020
                                                  
9            PHP         xxxxxx    A
VAR        INV           CAPLMT      9999999
                                                  
10           PHP         xxxxxx    A
VAR        INV           COMTYP      ALL
                                                  
11           PHP         xxxxxx    A
VAR        INV           DEPT        ALL
                                                  
12           PHP         xxxxxx    A
VAR        INV           NSKLMT      9999999
                                                  
13           PHP         xxxxxx    A
VAR        INV           PURCH       8681
                                                  
14           PHP         xxxxxx    A
VAR        INV           STKLMT      9999999
                                                  
15           PHP         xxxxxx    A
VAR        INV           REPORT      ALL
                                                  

-- 
Colin Bell