>>>>> "barry" == barry <barry@stripped> writes:
barry> At 09:48 AM 1999-10-07 +0800, you wrote:
>> How did you define the TIMESTAMP column? To get this to work with
>> Access one must define is without a length modifier !
>> For example:
>> CREATE TABLE foo (a int not null primary key, b timestamp);
>> The following will not work:
>> CREATE TABLE foo (a int not null primary key, b timestamp(8));
barry> I have define the timestamp field without the length modifier
barry> but a mysqldump test show that it is automatically create timestamp(14)
barry> modifier. Below is a simple tables I create for testing. I don't define the
barry> length modifer for timestamp field
barry> during mysql database creation.
barry> # MySQL dump 6.0
barry> # Host: localhost Database: barry1
barry> # Server version 3.22.26a
barry> # Table structure for table 'telephone'
barry> CREATE TABLE telephone (
barry> name char(10) DEFAULT '' NOT NULL,
barry> telephone char(10),
barry> changedate timestamp(14),
barry> PRIMARY KEY (name)
barry> # Dumping data for table 'telephone'
barry> INSERT INTO telephone VALUES ('barry','3456-5678',19991007144852);
barry> INSERT INTO telephone VALUES ('gary','1234-1234',19991007144852);
barry> INSERT INTO telephone VALUES ('may','2323-2323',19991007144852);
barry> INSERT INTO telephone VALUES ('wong','2222-2222',19991007144852);
barry> INSERT INTO telephone VALUES ('yan','1111-1111',19991007144852);
barry> MS Access 97 still unable to update/delete record. In fact,
barry> I have done numerous tests and I found that I can't do
barry> update/delete when there is a column with the column type such as DATETIME,
barry> DATE & TIMESTAMP. :-<
timestamp(14) should be ok, as this is the same thing as 'timestamp'
Which MyODBC version are you using?
Could you try to do a myodbc trace of a failed updated and check the
'UPDATE' statement in the trace file. Try executing this in the MySQL
monitor and see if this work!
How to do a trace file is described in the MyODBC README file. If
you find something else that looks wrong, you can post that part to me!
|• RE: MS Access 97 connection to MySQL||Michael Widenius||7 Oct|