insert
Description
insert constructs a SQL INSERT statement using whatever is contained in params.
Note: In order to ensure compatibility with other Salesware applications, do not use this call. Compatibility is ensured only if you use the pre-defined calls that write data to the SiriusSQL database.
Input fields
XML tag | Description |
params | INSERT SQL statement, minus the INSERT. Can also use two functions: **SUB(operator) **SUB(salespoint) in order to populate the operator and salespoint fields. |
Return fields
Status only.
Examples
Example invocation:
<func>insert</func><params>into addlink (addlink_id, guest_no, address_id) VALUES (19000010, 1000000, 1000000)</params>
Example return string:
OK :
See also