Hi All,

Why i can't use NZ function in a access query?

The error:

Exception Occurred in application: ConceitoWindows

Date/Time: 28/07/2007 00:22:00

System.Data.OleDb.OleDbException: Undefined function 'nz' in expression.

   at EntitySpaces.Interfaces.esDataProvider.FillDataTable(esDataRequest request, esProviderSignature sig)

   at EntitySpaces.Core.esEntityCollection.FillDataTable(esQueryType queryType, String query, esParameters parms)

   at EntitySpaces.Core.esEntityCollection.FillDataTable(esQueryType queryType, String query)

   at BusinessObjects.PedidosCollection.QryPedidos() in E:\Projects\Conceito\BusinessObjects\Custom\PedidosCollection.cs:line 31

   at ConceitoWindows.Forms.frmPedidos.GridLoad() in E:\Projects\Conceito\ConceitoWindows\Forms\frmPedidos.cs:line 25

      public DataTable QryPedidos() 
        {
            string strSQL = "SELECT * FROM qryPedidos";

            return base.FillDataTable(esQueryType.Text, strSQL);
        }

That error is coming from System.Data.OleDb, not EntitySpaces. A quick Google on the error turned up this:

http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic11638.aspx

Looks like the Nz function is not even available in Sandbox mode for Jet. Perhaps try IIf(IsNull...) instead.

Thank-you David,

 I tryed IIF(IsNull(value),0,value) and it working fine now!!

 Kind Regards