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
