Hi,
Sorry, it didnīt help. create table tPruefBesch (fTimestamp timestamp(14), fPruefbeschNr int auto_increment not null, fPlanNr int, primary key (fPruefbeschNr)); mysql> explain tPruefBesch; +----------------------+----------------------+-------+-------+------------+----------------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+----------------------+-------+-------+------------+----------------------+ | fTimestamp | timestamp(14) | YES | | NULL | | | fPruefbeschNr | int(11) | | PRI | NULL | auto_increment | | fPlanNr | int(11) | YES | | NULL | | +----------------------+---------------------+--------+-------+-----------+-----------------------+ mysql> explain tKunde; +-------------------+------------------+--------+------+-----------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+--------+------+-----------+-------+ | fKdNr | varchar(20) | | PRI | | | | fFirmenname | varchar(30) | YES | | NULL | | | fAdresse | varchar(40) | YES | | NULL | | | fLand | varchar(5) | YES | | NULL | | +--------------------+-----------------+--------+------+---------+----------+ Why is the default at fPruefbeschNr Null? Regards, Christine Penkert Hi, Can you please try with 3.51.02, if it doesn't help I can debug it. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > -----Original Message----- > From: Penkert, Christine [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 4:52 AM > To: [EMAIL PROTECTED]; muyuan; [EMAIL PROTECTED] > Subject: Re: Re: Problem with MySQL, ODBC, MS Access > > > > > Sorry Iīve tried it but I didnīt succeed. When writing: update > tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have > the same value. I donīt know why, but there is the same fault. > > Iīve created a small database to show my problem. > Thatīs my table in MySQL 3.23.41. > create table tTest (fTimestamp timestamp(14), fCounter int auto_increment > not null, fData1 int, fData2 int, primary key (fCounter)); > Itīs connected via ODBC 3.51 with Access 2000. Iīve installed Service Pack > 2 and MDAC 2.70. > > Here is the description of my database. > When you enter Frm_Test you will see three buttons. > Button Test 1 will insert value 1 in column data 1. (When you insert a > different value auto_increment will count correctly but it is > necessary for > my database to have the possibility to insert the same value.) > Button Test 2 will insert value 1 in column data 1 und value 5 in column > data 2. > Button Delete first record will delete the first record. > > So -. When you first click several times on Test 1 you will consider that > auto_increment counts correctly. But when you now click eg 10 times on > Delete first record and then click eg 12 times on Test 1 you will see that > Counter will show 10 times the same number and then go on counting > correctly. > The next problem is that when you click on Test 1 until auto_increment > counts correctly and then click on Test 2 you will see that value 5 is > inserted correctly in data 2, but when you delete 10 records it will 10 > times insert the value in another recordset. Note that you will not see > that the counter has the same value, because of the requery. You will see > the counter is counting correctly but the value is inserted at another > place. The problem is that the record pointer will not point to > the current > record after refresh but to another random record. > > I hope this will help you understanding my problem. > > Regards, > > Christine Penkert > > > (See attached file: db3.zip) > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php