GetSQLErrText

Description

Gets the SQLErrText of the first error encountered when executing the retrieve or update statement with the DataWindow/DataStore/DataWindowChild object in BatchDataObjects.

Applies to

BatchDataObjects object

Syntax

objectname.GetSQLErrText ( ) 

Argument

Description

objectname

A reference to the BatchDataObjects object.


Return value

String.

Returns the value of SQLErrText or returns an empty string if no error occurs.

Examples

The following example gets the SQLErrText of the DataWindow where error occurs.

li_return = lnv_RestClient.RetrieveOrUpdateWithModels( lbdo_test, ls_url)
if li_return = 1 then
    MessageBox("Success", "Return = " + String(li_return))
else
li_index = lbdo_test.GetErrorIndex()
    if li_index > 0 then
    string ls_SQLErrText
ls_SQLErrText _objects.GetSQLErrText())
    else
    //handle other error
    end if
end if

See also

GetCount

GetErrorIndex

GetSQLDBCode