Class Rico.Buffer.AjaxSQL

Extends Rico.Buffer.AjaxXML.
Implements buffer for LiveGrid. Loads data from server in chunks as user scrolls through the grid.
Defined in: <ricoLiveGridAjax.js>.

Class Summary
Constructor Attributes	Constructor Name and Description
	Rico.Buffer.AjaxSQL(url, options, ajaxOptions)

Method Summary
Method Attributes	Method Name and Description
	ajaxExportAppend(startPos, request)
	displaySessionTimer(msg)
	exportAllRows(populate, finish)
	exportTimedOut()
	fetch(offset) Fetch data from database.
	formQueryHashSQL(startPos, fetchSize)
	getFetchOffset(offset)
	getFetchSize(adjustedOffset)
	jsExportAppend(startPos, newRows, newAttr, totalRows, errMsg)
	refresh(resetRowCount) Update the grid with fresh data from the database, maintaining scroll position.
	registerGrid(liveGrid)
	restartSessionTimer()
	sendExportRequest(offset) Send request for print window data
	setBufferSize(pageSize)
	sortBuffer(colnum)
	updateBuffer(start, newRows, newAttr)
	updateSessionTimer()

Methods borrowed from class Rico.Buffer.AjaxXML:: ajaxUpdate, clearTimer, formQueryHashXML, handleTimedOut, jsUpdate, processResponse, updateGrid
Methods borrowed from class Rico.Buffer.Base:: appendRows, applyFilters, bufferRow, clear, deleteRows, dom2jstable, dom2jstableAttr, endPos, getCell, getRows, getValue, getWindowAttr, getWindowCell, getWindowValue, insertRow, isInRange, isVisible, loadRows, loadRowsFromArray, loadRowsFromTable, nan2zero, setTotalRows, setValue, setWindow, setWindowValue, sortFunc, visibleRows

Class Detail

Rico.Buffer.AjaxSQL(url, options, ajaxOptions)

Parameters:
url
options
ajaxOptions

Method Detail

ajaxExportAppend(startPos, request)

Parameters:
startPos
request

displaySessionTimer(msg)

Parameters:
msg

exportAllRows(populate, finish)

Parameters:
populate
finish

exportTimedOut()

fetch(offset)

Fetch data from database.

Parameters:
offset: position (row) within the dataset (-1=clear existing buffer before issuing request)

formQueryHashSQL(startPos, fetchSize)

Parameters:
startPos
fetchSize

getFetchOffset(offset)

Parameters:
offset

getFetchSize(adjustedOffset)

Parameters:
adjustedOffset

jsExportAppend(startPos, newRows, newAttr, totalRows, errMsg)

Parameters:
startPos
newRows
newAttr
totalRows
errMsg

refresh(resetRowCount)

Update the grid with fresh data from the database, maintaining scroll position.

Parameters:
resetRowCount: indicates whether the total row count should be refreshed as well

registerGrid(liveGrid)

Parameters:
liveGrid

restartSessionTimer()

sendExportRequest(offset)

Send request for print window data

Parameters:
offset

setBufferSize(pageSize)

Parameters:
pageSize

sortBuffer(colnum)

Parameters:
colnum

updateBuffer(start, newRows, newAttr)

Parameters:
start
newRows
newAttr

updateSessionTimer()

Rico 2.1

Classes

Class Rico.Buffer.AjaxSQL