Wrong date Updation in webservices

Ashish_Gupta · 2009-10-01

I am using webservices to create a record in NAV Customized table having a primary key and couple of text fields and couple of dates. The primary key and the text fields are getting created correctly but the date field is getting intialized to 01/01/01. When I am modifying the record the date is correctly updated. I have written the same code in both the functions but ](*,)

My code is as follow

Create Code:

protected void Btn_InsertStream_Click(object sender, EventArgs e)
    {
        StreamList_Service stream = new StreamList_Service();
        stream.UseDefaultCredentials = true;

        StreamList newstream = new StreamList();
        newstream.Code = txt_code.Text;
        newstream.Description = Txt_Description.Text;
        newstream.Description_2 = Txt_Description2.Text;
        newstream.Start_Date = Convert.ToDateTime(Txt_startdate.Text);
        newstream.End_Date = Convert.ToDateTime(Txt_Enddate.Text);
        stream.Create(ref newstream);
        Response.Redirect("Streams.aspx");
    }

update code

protected void btn_Update_Click(object sender, EventArgs e)
    {
        StreamList_Service stream = new StreamList_Service();
        stream.UseDefaultCredentials = true;

        StreamList newstream = new StreamList();
        newstream.Code = txt_code.Text;
        newstream = stream.Read(newstream.Code);
        newstream.Description = Txt_Description.Text;
        newstream.Description_2 = Txt_Description2.Text;
        newstream.End_Date = Convert.ToDateTime(Txt_Enddate.Text);
        newstream.Start_Date = Convert.ToDateTime(Txt_startdate.Text);
        stream.Update(ref newstream);
        Response.Redirect("Streams.aspx");
    }

Any help will be greatly appreciated.

freddy.dk · 2009-10-02

You need to set

newstream.Start_DateSpecified = true;
newstream.End_DateSpecified = true;

when creating the record.

These variables tells Visual studio which values it should include when sending data over the wire to NAV.
Reason why your update works is, that when you get the record back you get all fields (and all xxxSpecified = true).
xxxSpecified does not exist for string fields - these fields can be set to NULL in order to specify that you don't want it send over the wire.

kine · 2009-10-02

freddy.dk wrote:

You need to set

newstream.Start_DateSpecified = true;
newstream.End_DateSpecified = true;

when creating the record.

These variables tells Visual studio which values it should include when sending data over the wire to NAV.
Reason why your update works is, that when you get the record back you get all fields (and all xxxSpecified = true).
xxxSpecified does not exist for string fields - these fields can be set to NULL in order to specify that you don't want it send over the wire.

Very insteresting... is this described somewhere in the documentation? ;-)

freddy.dk · 2009-10-05

Probably in the Visual Studio documentation as these variables determines what will be send over the wire to Web Services from your C# app.

Wrong date Updation in webservices

Answers

Categories