Updating a Database Table

, ,
1

I have a TestName Table with 2 columns; ServiceName and State which accept integer for their State(0=inactive, 1=active)

I have a document with two strings, ServiceName and State(Pick List of Active and Inactive)

I also have a service which reference this document, invoking an upDate adapter to update my TestName Table

I want to upDate a TestName table’s ServiceName with either an Active or Inactive State from my service, but is will store 1 in database for Active and 0 for Inactive

How do I configure a service to upDate this table, receiving a string(Active or Inactive) from my service but store an integer 1 for Active or 0 for Inactive into my table

Thanks

2

Hi,
If i am not wrong copy condition could be set and value inserted to adapterservice as follows.
if(Str=‘active’){insert 1}
if(Str=‘inactive’){insert 0}

Regards,
Amol.

3

Can you please elaborate further on that, looking at adapter service I don’t understand how I can apply that.

4

I managed to solved it. Thank you