And the ODBC driver?? He cannot construct an UPDATE either?
Updating the table is done in code only.. its temporary data wich is collected in this tables before "serieus" update..\
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]
