UpdateDB
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:
| # | 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.