mibuso.com

Hi.

How can I set a date field to "empty" using VB.NET and Nav web services?

My code:



Tried with Nothing/null, system.dbnull, date.minvalue, "1753-01-01"... but nothing seems to work.

Thanks.


--------------------------------------


Solution.



Hotfix, as seen in blog's comments.



I tested it and works. Now SqlDateTime.MinValue is the "null" date for Nav.

the 0D value in NAV is '1753-01-01 00:00:00:000'. In .NET the functions expect DateTime variable.

Sorry, I don't understand very well what do you mean.

In .NET, it expects a "Date" variable.

With cdate("01/01/1753") it throws: "The * table contains a field with a date value that cannot be used with SQL Server".

Did you even read mihail's post. He gave you the exact answer.

I read it again, but can't understand.

Also, as I said, .NET function expects a "Date", not a "Datetime".

Can you explain it, please?

No, you might wrote a method which expects Date variable. If you publish a function from NAV the Date parameter is represented as DateTime in .NET

Thanks for helping, mihail.



I published a function in a codeunit with a "date" parameter and a "datetime" parameter. Both are the same from .NET (both are "date" .NET type), and can't use sqldatetime.minvalue (wich seems to be the "null" value for Nav) with none ot them.

The problem seems to be that '1753-01-01 00:00:00:000' is not converted to '0D'. Maybe a regionalization problem? We got other problems related with dates and decimals due to diferences in representation.



I don't understand how to modify a date through a Nav web services without publishing a function. (ie, a page with its "modify" function or a function in a codeunit)


Please, check the workaround I added to the first post. Maybe it helps.

Thanks again.

Vjeko has written a blog posting about the 0D bug: http://navigateintosuccess.com/blog/bug ... services-2

Thank you very much, Luc Van Dyck. That was the problem. I copied the answer to the first post.

Thank you too, mihail_kolev, for trying to help.

And for David Singleton an (optional) advice: Don't give such answers, even if you are right.

See you.

Hi,
1.
Has this hotfix been retracted?? if i click on download I cannot select the hotfix.

2.
Is this the latest hotfix or can I use a newer one to fix all problems?

1.- You must login with one of the four methods listed in the page. Then click "View and request hotfix downloads", and provide an email address to receive the hotfix link.

2.- Sorry, I don't know.

Yes, that is correct, but on the page after "View and request hotfix downloads" I can type in my emailaddress but there is no hotfix to select. Could anyone check this?