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/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]