Hi Hans, > I had created a table without a primary key (for some reasons). This give > some strange errors. > > When I edit a field trough ODBC he said: no transactions supported. If I > edit trough direct access components (DAC for MySQL = native access) > nothing is editted at all. > > With the mysql shell updating trough a Query is no problem. In DAC for > MySQL I use a TTable.
My bet is that the component cannot construct an UPDATE statement. > Does somebody know about problems with tables without primary index? Well, how would you be updating a row without an unique identifier :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]