Skip to main content

FairCom DB modify data

Abstract

FairCom JSON NAV includes several methods for modifying data.

This section covers the actions used to modify data including inserting, updating, truncating, and deleting records as well as updating fields.

Action

Description

"deleteRecords"

"deleteRecords" deletes one or more records from a database table using one or more IDs.

"insertRecords"

"insertRecords" inserts one or more records into a database table - one record for each item in the "data" array.

"runSqlStatements"

"runSqlStatements" runs one or more SQL statements, such as drop, create, alter, call, insert, update, and delete statements.

"truncateRecords"

"truncateRecords" deletes all records from a database table very quickly by deleting and recreating the data file.

"updateRecords"

"updateRecords" updates one or more records in database table.