Switch to: V11V10V9V8V7V6V5

VQueryResult Class: Properties

VQueryResult.Type

Declaration:

Type as EVQueryResult (r/o)

Description:

Returns the type of the result of a Valentina SQL command.

Enumerated values are:

  • kEmpty = 0
  • kCursor = 1
  • kBoolean = 2
  • kULong = 3
  • kString = 4

Example:

dim res as VQueryResult
dim curs as VCursor
 
res = db.SqlQuery( SomeSqlCommand )
if res.Type = EVQueryResult.kCursor then
   curs = res.AsCursor
end if 

VQueryResult.Flags

Declaration:

Flags as EVQueryFlags (r/o)

Description:

Can return additional information about the operation.

Enumerated values are:

  • kNone = 0
  • kSchemaWasModified = 1
  • kDatabaseWasChanged = 2
  • kXMLResult = 4

VQueryResult.AsCursor

Declaration:

AsCursor as VCursor (r/o)

Description:

Extracts cursor from the result. Note, that if the result type is not a cursor, then this property will be nil.

VQueryResult.AsULong

Declaration:

AsULong as Integer (r/o)

Description:

Extracts ULONG value from the result. Usually this kind of results is returned by non-SELECT commands, such as INSERT, UPDATE, DELETE. The value returned usually refers to the number of the affected records.