Re: [aus-dotnet] OleDBException on Access DB Query

[Mitch Wheat]

Hi Nic

If the query is defined in the Access DB, you could try rewriting using 
IIF() (bit of a long shot).  Does the access DB reference anything? Common 
functions failing is often due to missing refs.
Regards,
MItch

----- Original Message ----- 
From: "Nick Zdunic" <nick@xxxxxxxxx>
To: <dotnet@xxxxxxxxxxx>
Sent: Monday, February 28, 2005 10:58 PM
Subject: [aus-dotnet] OleDBException on Access DB Query


> Hi,
>
> I get this error where calling a query in an Access DB with the Nz 
> function
> contained within it:
>
> System.Data.OleDb.OleDbException : Undefined function 'Nz' in expression.
>
> I don't believe this should happen.  How can I fix it?
>
> I'd rather use the query as is rather than write so code to manipulate the
> data after the read has been performed.
>
> Regards,
>
> Nick
_________________
You are a part of the Australian "dotnet" mailing list.
To unsubscribe send "unsubscribe dotnet" or to re-subscribe send "subscribe dotnet Your Name" in the body of the email to: imailsrv@xxxxxxxxxxx
List managed by: http://www.stanski.com