List:MySQL ODBC« Previous MessageNext Message »
From:Pat Sherrill Date:May 3 1999 9:08pm
Subject:Re: Can't update a table using MyODBC
View as plain text  
Change your timestamp(6) to timestamp(14).
I hope this helps...
Pat...

----- Original Message ----- 
From: Frank Salinas <fs@stripped>
To: <myodbc@stripped>
Sent: Monday, May 03, 1999 1:28 PM
Subject: Can't update a table using MyODBC


> Hello:
> 
> I am having a very strange problem with myODBC. I have a MySQL server
> (version 3.22.17) running on a RedHat Linux 5.2 machine. I have
> created
> links from Access 97 on a windows 98 machine to a database on the
> MySQL
> server. Everything works fine except that there is one table that
> when I try
> to update, I get the following error:
> 
> "The data has changed. Another user edited this record before you
> attempted
> to save your changes. Re-edit the record"
> 
> This happens even though I know I am the only one working with the
> database.
> As I said this happens with only one of the tables in the database. I
> am
> able to edit the table from the command line on the Linux machine.
> All the
> field types in this table are used in the other tables so it is not
> that
> there is some problem with an incompatible type between Access 97 and
> MySQL.
> 
> Here is the description of the table.
> +--------+---------------------+------+-----+---------+-------+
> | Field  | Type                | Null | Key | Default | Extra |
> +--------+---------------------+------+-----+---------+-------+
> | field1 | int(11)             |      | PRI | 0       | auto  |
> | field2 | varchar(12)         |      |     |         |       |
> | field3 | varchar(255)        |      |     |         |       |
> | field4 | varchar(16)         | YES  |     | NULL    |       |
> | field5 | smallint(5) unsigned|      |     | 0       |       |
> | field6 | smallint(5) unsigned|      |     | 0       |       |
> | field7 | text                | YES  |     | NULL    |       |
> | field8 | text                | YES  |     | NULL    |       |
> | field9 | varchar(255)        | YES  |     | NULL    |       |
> | field10| enum()              | YES  |     | NULL    |       |
> | field11| timestamp(6)        | YES  |     | NULL    |       |
> +--------+---------------------+------+-----+---------+-------+
> 
> Any help will be greatly appreciated.
> 
> Thanks.
> 
> Frank Salinas
> 
> Duke University.
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread196@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.
> 
> 

Thread
Can't update a table using MyODBCFrank Salinas3 May
  • RE: Can't update a table using MyODBCPhillip Grant3 May
  • Re: Can't update a table using MyODBCPat Sherrill4 May
Re: Can't update a table using MyODBCFrank Salinas4 May