Hello all,
As I am testing our old mysql based erp app., on postgresql with most of things are as they are in MySQL db with PG 8.3, Unicode ODBC driver and Access 2003, I got this error:
ODBC -call failed. Operator does not exist: date < numeric;error while executing the query. This error does not comes when we use mysql. and we are not using any type server based views, stored procs ec. for this. This error comes when I use a dlookup function to check whether date field is less than a form value. It seems that this will be an ODBC driver problem to not cast the value properly. Please give the solution and the details.
Thanks,
CPK
As I am testing our old mysql based erp app., on postgresql with most of things are as they are in MySQL db with PG 8.3, Unicode ODBC driver and Access 2003, I got this error:
ODBC -call failed. Operator does not exist: date < numeric;error while executing the query. This error does not comes when we use mysql. and we are not using any type server based views, stored procs ec. for this. This error comes when I use a dlookup function to check whether date field is less than a form value. It seems that this will be an ODBC driver problem to not cast the value properly. Please give the solution and the details.
Thanks,
CPK
