RE: MS Access 97 connection to MySQL

[Michael Widenius]

>>>>> "barry" == barry  <barry@stripped> writes:

barry> At 09:48 AM 1999-10-07 +0800, you wrote:
>> 
>> Hi!
>> 
>> 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));
>> 
>> Regards,
>> Monty


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> #
barry> # Host: localhost    Database: barry1
barry> #--------------------------------------------------------
barry> # Server version	3.22.26a

barry> #
barry> # Table structure for table 'telephone'
barry> #
barry> CREATE TABLE telephone (
barry> name char(10) DEFAULT '' NOT NULL,
barry> telephone char(10),
barry> changedate timestamp(14),
barry> PRIMARY KEY (name)
barry> );

barry> #
barry> # Dumping data for table 'telephone'
barry> #

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. :-<

Hi!

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!

Regards,
Monty