Re: MySql: msg#00013 db.squirrel-sql.users

Colin,

Thanks for the reply and your time.

I will keep trying on my end and see if I can find what/where my problem
is.

Regards.

-----Original Message-----
From: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx
[mailto:squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of
Colin Bell
Sent: Tuesday, December 05, 2006 3:18 PM
To: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Squirrel-sql-users] MySql

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

The information contained in this message and any attachments is intended only
for the use of the individual or entity to which it is addressed, and may
contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from
disclosure under applicable law. If you are not the intended recipient, you
are prohibited from copying, distributing, or using the information. Please
contact the sender immediately by return e-mail and delete the original message
from your system.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Previous by Date:	Re: MySql, Colin Bell
Next by Date:	Re: MySql, Robert Manning
Previous by Thread:	Re: MySql, Colin Bell
Next by Thread:	Re: Setting up DB2 configuration giving problems, Robert Manning
Indexes:	[Date] [Thread] [Top] [All Lists]

<Prev in Thread]	Current Thread	[Next in Thread>

Re: MySql: msg#00013

db.squirrel-sql.users

Free Magazines