Was this helpful?
CrossTable 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
CommitToCache()
integer
Keeps data in the cache consistent with data in the database when insert, update, or delete operations are performed on cached data
QueryObject
DBDelete
(
[rownumber = integer]
[,isrepeated = integer]
[,zerorowsiserror = integer]
[,maxrows = integer])
integer
Deletes rows from database tables when the rows contain columns for which the IsDeleteWhere attribute has been set to true
QueryObject
DBInsert
(
[rownumber = integer]
[,isrepeated = integer]
[,zerorowsiserror = integer]
[,maxrows = integer])
integer
Performs inserts on database tables with columns mapped to variables or fields specified for insertion
QueryObject
DBUpdate
(
[rownumber = integer]
[,isrepeated = integer]
[,zerorowsiserror = integer]
[,maxrows = integer])
integer
Performs updates on database tables with columns mapped to variables or fields specified for update
QueryObject
Duplicate()
Crosstable
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
 
Last modified date: 12/20/2023