List:General Discussion« Previous MessageNext Message »
From:Hans van Dalen Date:January 15 2004 2:17pm
Subject:Re: table without primary key
View as plain text  
Hi Martijn,

Yes your right, thanks a lot for ANY help! Monitoring component is a good 
Idea....


Hans

At 15:09 15-1-2004, you wrote:
>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
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

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