Database Reference List

The OpusScript Database functions are:

 

Function Name:

Description:

AutoCommit

Turn AutoCommit on or off for a database

Commit

Commit to database – permanently stored on database

Connect

Connect to SQL server

ExecuteSQL

The SQL database command to execute

FirstRecord

Go to First record in record set

GetCurrentRecordNumber

Get current record number in record set

GetIdentQuoteChar

Identify quote character required for table or field names containing spaces

GetLastError

Get the last database error message

GetNumberOfRecords

Get total number of records in record set

GetRecordAt

Go to a specific record number in a record set

GetRecordAtRelative

Go to a specific record number relative to current number

IsAutoCommitOn

Check if AutoCommit is on in a database

LastRecord

Go to Last record in record set

NextRecord

Go to Next record in record set

PreviousRecord

Go to Previous record in record set

Rollback

Go back to point in database before changes were made or last commit sent

 

Related Topics:

OpusScript Reference List

Date Reference List

Math Reference List