From: "Shahab Asgharzadeh" <[EMAIL PROTECTED]> > Access will write the sql as: > delete from "tablename" where "col1" = 1234 AND "col2" = 'text' AND "col3" = > 100.200 > > ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8' > You will have to retype this query using an explicit cast > It is treating "100.200" as float and can't find an '=' operator that matches numeric with float. You can handle it with where col3=100.200::numeric - Richard Huxton
- [GENERAL] numeric type and odbc from access 2000 Shahab Asgharzadeh
- [GENERAL] Re: numeric type and odbc from access 2... Richard Huxton
- [GENERAL] Re: numeric type and odbc from acce... Stefan Waidele jun.