external SQL Table with Null Columns - Error

gdarmon@prodware.fr
gdarmon@prodware.fr Member Posts: 7
in NAV Three Tier
Hi,

We are trying to work with an external SQL Table with existing recods.

We are getting an error on Table.findset for columns (DATE) that have “Null” value.

Error is “The date is not valid”

is there any solution for this ?

Thanks,

Gill

Answers

  • vaprog
    vaprog Member Posts: 1,163
    If you only need to read the table, create your view accordingly. If you also need to write: not that I know of.
  • borealis
    borealis Member Posts: 35
    Navision doesn't handle null values. See also this link for more info.

Categories