Re: table without primary key

2004-01-15 Thread Martijn Tonies
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 ha

Re: table without primary key

2004-01-15 Thread Hans van Dalen
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. > Upda

Re: table without primary key

2004-01-15 Thread Hans van Dalen
January 15, 2004 6:20 PM Subject: 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 co

Re: table without primary key

2004-01-15 Thread Martijn Tonies
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 try

Re: table without primary key

2004-01-15 Thread Hans van Dalen
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 s

Re: table without primary key

2004-01-15 Thread Nitin Mehta
ry 15, 2004 6:20 PM Subject: 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 compone

Re: table without primary key

2004-01-15 Thread Martijn Tonies
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

table without primary key

2004-01-15 Thread Hans van Dalen
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 shel