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


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


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