Date fields with default = now() in MS Access fail on MYSQL

General usage of Access to MySQL

Moderator: jr

Date fields with default = now() in MS Access fail on MYSQL

Postby basementjack » Sun May 30, 2010 1:21 am

I came across a situation when trying to convert my Access database.

The create tables generated had statements like
Create table xxxx (
entrydate DATETIME NOT NULL DEFAULT 'now()',
xxx
xxx
)

The create table statement fails, because the default value is invalid.
Is it possible to have an option to convert these to
entrydate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP


?

I'd assume something similar probably would benefit the Access to MSSQL product as I think it needs GetDate() instead of Now()

If the source of this is available, I'd be happy to rough in the code and submit it back up.

- Jack
basementjack
 
Posts: 8
Joined: Tue Mar 30, 2010 8:48 pm

Re: Date fields with default = now() in MS Access fail on MYSQL

Postby jr » Sat Jun 12, 2010 8:27 pm

Hi,

This will be fixed in the next version.

Regards,
Jacob
jr
Site Admin
 
Posts: 491
Joined: Sun Mar 26, 2006 12:28 pm

Re: Date fields with default = now() in MS Access fail on MYSQL

Postby jr » Sun Jun 13, 2010 6:49 am

This has now been released :-)

/Jacob
jr
Site Admin
 
Posts: 491
Joined: Sun Mar 26, 2006 12:28 pm


Return to General

Who is online

Users browsing this forum: No registered users and 1 guest

cron