Spread 8.0 Documentation
GetDataFillData Method
Support Options
ActiveX Reference > ActiveX Methods > GetDataFillData Method

Glossary Item Box

GetDataFillData Method


See Also    Example

Applies To

fpSpread control

Description

Returns data from the database inside the DataFill event.

Syntax

C++

BOOL CSpreadSheet::GetDataFillData(VARIANT* Var,short VarType)

Visual Basic

fpSpread.GetDataFillData(Var As Variant, ByVal VarType As Integer) As Boolean

Parameters

The following parameters are available:

Parameter Description
Var Data retrieved from the database
VarType Data type expected
(Refer to the Visual Basic documentation for Variant data types.)

Remarks

This method lets an application interact with the data before the data enters the sheet.

Note: The VarType parameter represents a variant data type. The DataType parameter for the DataFill event represents the data access type. These parameter values are not equivalent. For example, the DataFill event would return a value of 4 in the DataType parameter for a long integer. For the GetDataFillData method, the variant data type for a long integer is represented by a value of 3.

This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.

Return Type

True if successful; otherwise, False.

See Also

DataFillEvent property

DataFill event

SetDataFillData method

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