SQL Server Examples:
1. SQL Server example of a call from a Stored Procedure:
Add the call to the procedure:
EXEC WsParameterWrite 'LAST_INVOICE_ID', '1234', 'The last invoice id loaded'
2. SQL Server example of a call from the command line using sqlcmd (all one line):
sqlcmd -S"SQL SERVER" -WslWarehouse -E -Q"EXEC WsParameterWrite 'LAST_INVOICE_ID','1234','The last invoice id loaded'"
The following out is typical:
(1 rows affected)
3. SQL Server example of a call from QAD SQL Admin
{Call WsParameterWrite('LAST_INVOICE_ID', '123456', 'The last invoice id loaded')};