user function in ODBC database

  • Thread starter Thread starter Bruno Castel
  • Start date Start date
B

Bruno Castel

Hi,
I have a Postgres database connected with ODBC to Access2003.
To avoid annoying issues with bool and integer, I have created a user
function in my Postgres database: booltoint.

I have created a MS Access request as follows:
SELECT DISTINCTROW INDIVIDU.CIV
FROM INDIVIDU
WHERE (booltoint(INDIVIDU.CIRC)=1);

But MSAccess complains that booltoint is unknows.
How to specify to MS Access to ignore this function and send as it to
Postgres database ?
Thanks,
 
Back
Top