List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:January 15 2004 2:09pm
Subject:Re: table without primary key
View as plain text  
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

Thread
table without primary keyHans van Dalen15 Jan
  • Re: table without primary keyMartijn Tonies15 Jan
    • Re: table without primary keyHans van Dalen15 Jan
  • Re: table without primary keyNitin Mehta15 Jan
    • Re: table without primary keyHans van Dalen15 Jan
  • Re: table without primary keyMartijn Tonies15 Jan
    • Re: table without primary keyHans van Dalen15 Jan
  • Re: table without primary keyMartijn Tonies15 Jan