Ax 2009 Update method using business connector

Finance and Operations/AX Technical Forum
1

Hi Everyone,

I created one webservice in visual studio 2008 and i write code for update method for only one record updated

but how to write code for multiple records update at a time using business connector in ax 2009

Thanks for advance

2

Hello Naveen,

For one record update or multiple records update we will give only one service. Based on that we will update records at AX table from Visuval Studio.

For Example: I have a table with 3 fields

AccountNum Name State

1001 Ajay AndhraPradesh

1002 Vijay AndhraPradesh

Now you need to update State field you have to specify one parameter at where clause. for example

While select custTable where custTable.AccountNum == "1001"

in this scenario it will update only one record because you are specified AccountNum == “1001”

If you want to update multiple records at a time you have to remove where clause. for example

While select custTable

{

custTable.State = “AP”;

custTable.update();

}

it will update multiple records in the table.

like wise you have to modify your web service code.

Regards,

Raman Kutala.

3

hi Raman,

thanks for reply but u passed values in code,but i am not to go for every time code and edit values,we have any alternative solution

4

Naveen, can you please explain clearly what you are expecting, so that i will try to give a better solution to solve your issue.

Regards,

Raman Kutala.

5

Hi Raman ,

In ur Example u wrote code and mentioned values like"Custable.state = “AP”;right suppose i need to for update custable.state = “KA”,in this updation also we go for code edit “AP” to “KA”,right,

But i don’t want go for code edit ,i need any text box in this code, i need to pass values in this text box,when i click update button ,it can update ,is it possible in websevice project method