Re: Converting MyISAM to InnoDB type.

2004-01-03 Thread Matt W
: Saturday, January 03, 2004 5:38 PM Subject: Re: Converting MyISAM to InnoDB type. If you change the Type=MyISAM to Type=InnoDB and execute the create query, what message do you get? Hi you all .. again This is the error message I get if I try to create this table in InnoDB

Re: Converting MyISAM to InnoDB type.

2004-01-03 Thread Fred
Hi Matt and thank you very much Now I get the point I'll have to decide if I maintain these two tables in MyISAM or if I drop the AUTO_INCREMENT and change the source-code in Delphi. It's clear now that the problem is the lack of support of InnoDB. Thanks for your help and regards,

Re: Converting MyISAM to InnoDB type.

2004-01-03 Thread Matt W
Subject: Re: Converting MyISAM to InnoDB type. Hi Matt and thank you very much Now I get the point I'll have to decide if I maintain these two tables in MyISAM or if I drop the AUTO_INCREMENT and change the source-code in Delphi. It's clear now that the problem is the lack of support

Re: Converting MyISAM to InnoDB type.

2004-01-03 Thread Fred
Hi Matt. Thanks a lot again ! It worked pretty good. There is no problem about the app, because the use of the indexes is in charge of the DBMS (MySQL). The app doesn't know about the tables and indexes details. Best Regards, Fred. Hi Fred, Also, you may be able to swap the order