Обсуждение: odbc error, operator does not exist
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
On Sat, Aug 23, 2008 at 12:05 PM, c k <shreeseva.learning@gmail.com> wrote: > 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. How are we supposed to compare a date to a numeric? What does '2008-08-23 12:45:34' < 1000000 mean?