System Reference Summary : 3. System Classes : SQLSelect Class : SQLSelect Methods
 
Share this page                  
SQLSelect Methods
Method
Return
Value
Description
Inherited
From
AddBreak
(columnindex =
integer,
level =
integer
[,formatstring = varchar(256)])
none
Adds a new break condition to the data stream
DataStream
ClearBreaks()
none
Removes all break conditions from the data stream
DataStream
Close()
none
Closes the query
DataStream
Duplicate()
SQLSelect
Makes a duplicate of the object, placing a reference to the new object in a reference variable
Object
FetchRow
(rowindex =
integer)
integer
Seeks an arbitrary row in the cache
DataStream
GetAttribute
(
attributename = byref(variable)
{,attributename = byref(variable)})
integer
Gets the values of any number of attributes for the object
Object
IsA
(class =
classname)
integer
Returns TRUE if the object is of the same class as, or one of the subclasses of, the class specified by classname
Object
Load()
integer
Moves data into target variables, objects, or fields on the frame
DataStream
NextRow()
integer
Retrieves the next row of data from the database into internal buffers
DataStream
Open
(querymode =
integer,
[scope = CompositeScope]
[,checkcols = integer,
isrepeated = integer],
[maxrows = integer])
integer
Opens the query with the semantics implied by the specified mode
DataStream
PrevRow()
integer
Backs up to the previous row in the cached sequence and positions that row to be loaded into fields or variables
DataStream
SetAttribute
(
attributename = value
{,attributename = value})
integer
Sets any number of attributes for the object
Object
SetCols
(
[scope = CompositeScope])
integer
Checks the query for syntactic errors and initializes the array
DataStream