C# project with NODBC: SQL query issue

Business Central/NAV Developers Forum
1

Hi

I’ve developed a C# Project using NODBC to query data from tables using LEFT JOIN to join them.

  • General Ledger Setup,
  • Contact Business Relation,
  • Contact,
  • Contact Industry Group)

Cases:

  • When I execute the query asking only for the column “cust”.“Last Date Modified” the result is OK.
  • When I execute the query asking for several columns except “cust”.“Last Date Modified” the result is OK.
    -When I execute the query trying to get the same several columns and the “cust”.“Last Date Modified” column I get the error: “Year, Month, and Day parameters describe an un-representable DateTime”. What I don’t understand is that the error don’t appear in the first case.

Notes:

  • The query return 10k rows moreless.
  • All the rows has the a valid “cust”.“Last Date Modified”.

Have ever come across with that error?

Thanks in advance.
fjgc