FormatBinaryResultString method: Query class
Syntax
FormatBinaryResultString(&Rowset, Output_Format, Start_Row, End_Row)Description
Use the FormatBinaryResultString method to generate a string containing the content of the input (the rowset) in XLS format. You can specify the range of rows to be in the rowset to be used as input. The rowset object is created using the RunToRowset method.
Parameters
| Parameter | Description |
|---|---|
|
&Rowset |
Specify an already instantiated and populated rowset object containing the query result. This rowset is created using the RunToRowset method. |
|
Output_Format |
Specify the format of the output. You can specify either a numeric or constant value. See below. |
|
Start_Row |
Specify the first row in the rowset that you want to use for output. This parameter takes a numeric value. |
|
End_Row |
Specify the last row in the rowset that you want to use for output. This parameter takes a numeric value. |
The values for Output_Format can be as follows:
| Numeric Value | Constant Value | Description |
|---|---|---|
|
8 |
%Query_XLS |
The output for Excel in HTML format. |
Returns
A binary object containing the formatted output.
Example
/* Use RowCount, not ActiveRowCount, to get the total number of rows. */
&End = &MyRowset.RowCount;
&FormString = &MyQuery.FormatBinaryResultString (&MyRowset, %Query_XLS, 1, &End);
Related Topics