Spread 8.0 Documentation
QueryData, ScriptQueryData Events
Support Options
ActiveX Reference > ActiveX Events > QueryData, ScriptQueryData Events

Glossary Item Box

QueryData, ScriptQueryData Events


See Also

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

Customizing Virtual Mode

ScriptEnhanced, SheetSendingEvent, VirtualMode, VirtualRows, VScrollSpecial, VScrollSpecialType properties

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.