ODBiC Discussion Board

QBE date selection problem (English dates)

by Jon Grosse, June 8, 2007 01:20

I find that QBE will not select on a date when connected to a MySQL database via the MySQL 3.51 driver. I have tried using SETOPTION SQL_DB="MySQL" but it has no effect.

I find that QBE does work if I connect to an MSaccess database that has links to data in the MySQL database (although the date has to be entered in mm/dd/yyyy format instead of the displayed dd/mm/yyyy format).


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.