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
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 At 14:46 15-1-2004, you wro

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
it cannot b related with primary key. i do not hav any idea how u update it, but it's supported to update any dat in any table with or without PK - Original Message - From: "Hans van Dalen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 15, 2004 6:20 PM Subject: tabl

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