Salary Increase from a Visual Basic Script
Execute the following VBScript program to increase the salary of all staff in a USoft application by 1%:
Dim ConObj as New ADODB.Connection
ConObj.Execute "UPDATE STAFF SET SALARY = SALARY * 1.01"
If (ConObj.Errors.Count > 0) Then
In this example, "TravelAgency" is the data source name configured against the "USoft 7.0 Remote Rules Service API" ODBC driver.