From: Martijn Tonies
Date: January 15 2004 1:40pm
Subject: Re: table without primary key
List-Archive: http://lists.mysql.com/mysql/157689
Message-Id: <023b01c3db6d$2169b5c0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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