From: Martijn Tonies
Date: January 15 2004 2:09pm
Subject: Re: table without primary key
List-Archive: http://lists.mysql.com/mysql/157696
Message-Id: <027901c3db71$36de6dc0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Hans,

> And the ODBC driver?? He cannot construct an UPDATE either?

I'm not saying this is the problem, but it might give you a
direction where to look.

> Updating the table is done in code only.. its temporary data wich is
> collected in this tables before "serieus" update..\

Instead of trying a TmyTable, why not use a query component and
create an UPDATE statement yourself to update the table. That
would avoid all this.

And have a look at the MyMonitor component to see what SQL
get's executed when you're doing what you're trying to do. That
might help as well.

> hans
>
> At 14:40 15-1-2004, you wrote:
> >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