SQL::CallResult Object

This SQL::CallResult object provides a more complete description of a function call on an object in the SQL name space. Most SQL objects have a member property of type SQL::CallResult. The .Text property contains either "Success" or the last error.

DIM c as SQL::Connection

DIM cs as C

cs = "{A5API=Access, FileName=C:\DoesNotExist.Mdb}"

? c.Open(cs)

= .F.

? c.CallResult.Text

= Database API specific error

API Specific Result is: -1 - '[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

SQL State is: HY000

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

SQL State is: IM006'

Properties

Property	Type	Mode	Description
API	C	R	Default = "". The API (driver) in use when the call was made.
Canceled	L	R	Default = FALSE (.F.). TRUE (.T.) if the call was cancelled; otherwise FALSE (.F.).
Code	N	R	Default = 0. The number identifying the result.
Error	L	R	Default = FALSE (.F.). TRUE (.T.) if the call failed; otherwise FALSE (.F.).
LastInsertedIdentity		R	This property is valid only after an INSERT successfully completes.
NativeCode	N	R	Default = 0. The numeric value (if any) returned by the underlying database driver.
NativeText	C	R	Default = "". The description (if any) returned by the underlying database driver.
RowsAffected	N	R	Default = 0. The number of rows affected by an insert/update/delete SQL statement.
Success	L	R	Default = TRUE (.T.). TRUE (.T.) if the call succeeded; otherwise FALSE (.F.).
Syntax	C	R	Default = "". The syntax type in use when the call was made.
Text	C	R	Default = "Success". A description of the result.
Warnings	L	R	Default = FALSE (.F.).