table without primary key

Hi group, 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

Re: table without primary key

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

Re: table without primary key

without primary key Hi group, 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

Re: table without primary key

Hello Martijn, 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

Re: table without primary key

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

Re: table without primary key

without primary key Hi group, 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

Re: table without primary key

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.

Re: table without primary key

Hans, I use it as a temporary file. Putting data in it sequential and after that reading it out sequential. I don't want a auto increment field or whatsoever because I want the date in sequential order of the data... the data itself cannot (always) be used as a primary key If you don't have