> 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.
> At 14:40 15-1-2004, you wrote:
> >Hi Hans,
> > > I had created a table without a primary key (for some reasons). This
> > > some strange errors.
> > >
> > > When I edit a field trough ODBC he said: no transactions supported. If
> > > 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 :-)
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL