Error message Row cannot be located for updating

Hi Everyone I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I save them, and in a large order (25 or more) there will be at least one which causes an error Row cannot be located for updating. Some values may have been changed since it was last read. The values looked

Error message Row cannot be located for updating

I should add, of course all the other items (re-)save perfectly, there is nothing about that actual record which is different. MySQL 5.0.27 WinXP Set mconn = New ADODB.Connection mconn.ConnectionString = DRIVER={MySQL ODBC 3.51 Driver}; SERVER= mstrServerName ; DATABASE= mstrThisDatabase

Are there any tools to get diff (alter commands) between tow tables ?

Hello, I wonder if there are any tools to do a diff between two tables struture to result alter command to convert table A structure to table B structure ? Thanks for your information. Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Are there any tools to get diff (alter commands) between tow tables ?

Hi, I wonder if there are any tools to do a diff between two tables struture to result alter command to convert table A structure to table B structure ? Yes, our tool Database Workbench includes a so-called Schema Compare tool which allows you to compare structures and create a change script.

Re: MySQL Benchmarking

Alex, Thanks a bunch for the insight and for proving the links to the following benchmarking tools. Unfortunately, business is requiring that each database live in it's own instance, so it sounds like moving in the direction of having multiple servers and spreading the data around would be

Re: Are there any tools to get diff (alter commands) between tow tables ?

2007/3/19, Martijn Tonies [EMAIL PROTECTED]: Hi, I wonder if there are any tools to do a diff between two tables struture to result alter command to convert table A structure to table B structure ? Yes, our tool Database Workbench includes a so-called Schema Compare tool which allows you to

Re: corrupted tables

How about your disk space? I had a similar problem on a large table and it ended up being caused by filling up the disk. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Octavian Rasnita wrote: From: Steve Edberg [EMAIL PROTECTED] Sometimes I see that some tables from my

Re: Do sourced queries automatically commit?

João Cândido de Souza Neto [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Could you try to put the start transaction into your .sql file. Ok, I tried that -- same result. I even tried including the rollback in the .sql file as well, but the changes are still committed afterwards. The

Character sets

Hi All, What character sets would you recommend for a server in the US and all data stays within the English language. Currently everything is set to latin1 with latin1_swedich_ci collation which seems to be the closets one to what I need from what I have read, I was just wondering if there is a

Re: Character sets

Hello. In general, You can never be sure that (some time in future) you won't need to store different national characters. For example some non-english surname or whatever. So, If you can easily decide it now, use UTF. It's painless choice now and it can come handy in future. Ales Zoulek

Increasing the Query Cache Size has performance ?

Hello Everybody, I increased the query_cache_size on one of our main servers from 100 MB to 250 MB, since I was seeing a very high rate lot of Qcache Low Mem prunes. The server was fine for 15 minutes and the Low mem prunes went down to almost zero, but then started

Posting A Question

Hi... How do I go about posting a question about MySQL? Thank you, John Sutton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Posting A Question

Just like you did this right now :) Ales. On 3/19/07, John Sutton [EMAIL PROTECTED] wrote: Hi... How do I go about posting a question about MySQL? Thank you, John Sutton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Posting A Question

John Sutton wrote: Hi... How do I go about posting a question about MySQL? I think you're getting the hang of it. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL

Not Sorting Correctly

I have an app that I've converted to MySQL from MS SQL. I used to use the following to force a Alpha field to sort as if it were numeric (I know, perhaps it is better if I made the field numeric to begin with, but it's not, and I don't remember why, but that's not the question here): ORDER

Re: Do sourced queries automatically commit?

You can try to do a set autocommit=0; Kevin Chen [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] João Cândido de Souza Neto [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Could you try to put the start transaction into your .sql file. Ok, I tried that -- same

Re: Not Sorting Correctly

pls, post result of: SELECT RIGHT(CONCAT('000,RoomNo),3),LastName,FirstName FROM Ales On 3/19/07, Jesse [EMAIL PROTECTED] wrote: I have an app that I've converted to MySQL from MS SQL. I used to use the following to force a Alpha field to sort as if it were numeric (I know, perhaps it

RE: Character sets

As habit I only use UTF in anything I do... and it has paid off many times over. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

regarding lock

Hi, how to confirm whether or not a table has already lock? thanks. @@@^_^@@@ - 抢注雅虎免费邮箱-3.5G容量，20M附件！