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. |
See Also
ScriptEnhanced, SheetSendingEvent, VirtualMode, VirtualRows, VScrollSpecial, VScrollSpecialType properties