external SQL Table with Null Columns - Error

gdarmon@prodware.fr

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

vaprog

If you only need to read the table, create your view accordingly. If you also need to write: not that I know of.

borealis

Navision doesn't handle null values. See also this link for more info.