|
|
|
Note, the FairCom DB Standalone SQL Service does not support transactions nor transaction roll back capability and is therefore intended as a SQL query interface over existing data. By default, FairCom DB Standalone SQL Service does not allow updates or inserts. It is possible to enable inserts by adding the following keyword pair in ctsrvr.cfg:
SQL_OPTION FPUTFGET_RW
This configuration enables inserts and updates and is solely intended for single row database updates. If you choose to update multiple rows at a time (not recommended), you should ensure you have a recent complete database backup as any errors encountered during multi-row updates will result in loss of relational data integrity.
