Warning from SQL Server stops NAV running a view based table

drecksgekritzel
drecksgekritzel Member Posts: 37
edited 2010-09-25 in NAV/Navision Classic Client
Hello everyone,
we are currently updating our customer from NAV 4.0 SP2 to NAV 2009 SP1.
The old DB runs on SQL 2000 and the new one on SQL 2008.

In our DB we have a table, which uses a view to show data from another database in NAV.
In the old DB everything works fine, but now we get a warning from the sql server when we run the table.

Unfortunately i only got the warning in german but i try to translate it:
8153,"01003",[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: A NULL-Value will be deleted by an aggregate- or SET-action.

Can please someone tell me how i can set this warning off or how i can avoid it?

The sql statement in the table view is a very easy one like
select * from table xy.

Thanks in advance for your answers!


Regards Alex

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Don't use SELECT *. Specify each column to be returned and check for null values. Supply a blank (non null) value for any columns that return nulls.
    There are no bugs - only undocumented features.
  • drecksgekritzel
    drecksgekritzel Member Posts: 37
    Hello,
    i have already tried to add the ISNULL command before each column like ISNULL(Column1,0).
    But i replaced every NULL with 0.
    Could this be a problem too?
    Is it not possible to turn this warnings completely off?
    I already tried SET ANSI_WARNINGS OFF but the warning still exists.

    Regards Alex

Categories