UpdateDB

App Portal 2020 R1

You can use the UpdateDB web method to update row(s) of data for given table, column name, and value.

Parameters

The UpdateDB web method includes the following parameters:

UpdateDB Parameters

#

Parameters

Data Type

Description

1.  

tableName

String

Name of table whose row(s) has to be updated.

2.  

primaryColumn

String

Column name whose value has to be compared before update

3.  

primaryColumnValue

String

Column name whose value has to be compared before update

4.  

dataColumnName

String

Column name whose value has to be updated.

5.  

dataColumnValue

String

New value to be updated for specified column

6.  

password

String

Pipe (|) separated combination of Fl@xera!, short date format of the current date, and a GUID.

For example:

Fl@xera!|6/1/2016|6aa7a31513a162004e5050f32244b0ff

Return Value

Count of updated rows.