hello

i am having a few problems with Linkedserver and Navision Financials.

Most of the tables in navision (Customer, Prospect, Sales Line etc) have
DateTime columns that may contain nothing (null).
if i try to select these records i will get an error but i need access to
these columns so i can find out it the record has been updated recently.

the error is:

[Microsoft][ODBC Sql Server Driver][SQL Server]OLE DB error trace
[Non-interface error: Unexpected NULL value returned for the column:
ProviderName='MSDASQL', TableName'[Rowset_1]',ColumnName='Date_Completed'].

so how can i retrieve records with null columns? can i specify somewhere in
sql statements to ignore null columns or something?? below is a sample sql
query.

also note that the funtion IFNULL dont work for me, i will still get an
error

example sql statement:

DBCC TRACEON (8765)
SELECT * FROM
OPENQUERY(NAVISION,'SELECT
* FROM Sales_Header WHERE Document_Type = ''Order'' ')

if i replace * with specific column names (No_ Name_ etc) it will work fine,
as long as Date_Completed isnt requested (in this case).


i am develping a navision client for users on the road (using XDA II ppc's)
that will connect over GPRS and webservices so this is why i require the
DateTime fields, so the user will know if the records are upto date in the
SqlCe database.


Regards,
Ricardo Meechan

I am having the exact same problem. Have you gotten any further in resolving this issue?

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/