I have seen the problem with the INSERT syntax. The new version doesn't like the use of "'s to surround text and prefers single quotes.
I still don't see where the dbname.1 error is from Kerry -----Original Message----- From: Kerry Frater [mailto:[EMAIL PROTECTED] Sent: 02 February 2006 10:05 To: mysql@lists.mysql.com Subject: error 1146 X.1 does not exist Can someone point me in the right direction. I had 4.1 running and all was well with my little program. I decided to test the code with the newer 5.0.18. I updated my DB and then tried to access it using the MYSQl Control Centre - 0.9.4-Beta and query browser 1.0.4 alpha. The Administrator allows me to view table structure but not to add any numerical columns. Using the Control centre, If I double click on the table I wish to view data I get two lines in the message area Empty set (0.00) sec [local] ERROR 1146: Table 'llcopy.1' doesn't exist llcopy being my test database name. These messages are got no matter what the table content is. I do note that the error message on this app is different numerically to the previous Also my insert program now fails to insert data. So I extracted one of the SQL insert commands that worked with 4.1 and manually run it using the mysql.exe command interface. This is the manual command. INSERT INTO BanksC (Bank,BankName,AccountNo,Balance,PMClosingBalance,EOMTempBalance,STTS) VALUES ("C1","Client Bank","NONE",000000000.00,000000000.00,000000000.00,"C"); The error was ERROR 1054 (42S22): Unknown column 'C1' in 'field list' The settings of the table are char(2), char(20), char(12), decimal(12,2),decimal(12,2),decimal(12,2),char(1) respectively. This is driving me crazy. I am obviously doing something stupid but I have got so close to the problem I can't see the wood for the trees. Kerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]