Steps
|
SA Function(s)
|
Comment
|
---|---|---|
1. Create a cursor
|
SaCursorCreate
|
|
2. Binding variables to cursor
|
SaCursorColData, SaCursorColDate, SaCursorColDateFormat, SaCursorColDFloat, SaCursorColDouble, SaCursorColDynData, SaCursorColDynstr, SaCursorColFloat, SaCursorColInt, SaCursorColLong, SaCursorColStr, SaCursorColTime, SaCursorColTimestamp
|
|
3. Open the cursor
|
SaCursorOpen
|
|
4. Write a row(s) to the cursor
|
SaArrayInsert for more than one row or SaCursorInsert for a single row
|
Perform this in a loop if necessary
|
5. Free the cursor
|
SaCursorFree
|
|
6. Flush the network message to the server
|
SaArrayFlush
|
Necessary only if using SaArrayInsert.
|
Steps
|
SA Function(s)
|
Comment
|
---|---|---|
1. Create a cursor
|
SaCursorCreate
|
|
2. Binding variables to cursor
|
SaCursorColData, SaCursorColDate, SaCursorColDateFormat, SaCursorColDFloat, SaCursorColDouble, SaCursorColDynData, SaCursorColDynstr, SaCursorColFloat, SaCursorColInt, SaCursorColLong, SaCursorColStr, SaCursorColTime, SaCursorColTimestamp
|
|
3. Open the cursor
|
SaCursorOpen
|
|
4. Set the search constraint for the row to be updated or deleted
|
SaCursorEqual, SaCursorAtleast, SaCursorAtmost
|
|
5. Start a search for the row to be updated or deleted
|
SaCursorSearch
|
|
6. Fetch the row to be updated or deleted
|
SaCursorNext
|
|
7. Perform actual update or delete
|
SaCursorUpdate or SaCursorDelete
|
For updates, the new values need to be in variables bound in step 2.
|
8. Free the cursor
|
SaCursorFree
|
|