QueryData, ScriptQueryData Events

Applies To

fpSpread control

Description

Occurs when virtual mode is on and the fpSpread control requests additional data.

Syntax

C++

afx_msg void OnQueryDatafpSpread(UINT, int, CWnd*, LPVOID);

Visual Basic

Sub fpSpread_QueryData(ByVal Row As Long, ByVal RowsNeeded As Long, RowsLoaded As Long, ByVal Direction As Integer, AtTop As Boolean, AtBottom As Boolean)

Note: The ScriptQueryData event uses the same syntax except event parameters that are not passed "ByVal" are declared as variants. For more information on Script events, see Scripting Environment Usage.

Parameters

The following parameters are available:

Parameter	Description
Row	Row number of first row requesting data
RowsNeeded	Number of rows to fill with data
RowsLoaded	Number of rows loaded
Direction	One of the following values represents the direction the user was moving in the fpSpread control that caused this event to occur:
	Value	Description
	1	Down
	2	Up
	3	Top
	4	Bottom
	5	Refresh (Returned when the control rereads the current displayed data)
AtTop	Set to True if the top of the data is reached
AtBottom	Set to True if the bottom of the data is reached

Remarks

Direction parameter values 3 (Top) and 4 (Bottom) are returned only if the VScrollSpecial property is set to True.

Use the SheetSendingEvent property if you want to return the sheet for which this event occured.

Note: This event will occur if you use the fpSpread control in a scripting environment (for example, Microsoft's Visual InterDev or Internet Explorer) or a non-scripting environment. However, if you want to use the fpSpread control in a scripting environment and you want to change any parameter that is not passed "ByVal", you must set the ScriptEnhanced property to True and use the ScriptQueryData event. ScriptQueryData event parameters that are not passed "ByVal" are declared as variants.