Home : SQL Results
Q11200 - INFO: SQL Results

Used to locate the results of a SQL Query into a Spread Report.

BUTTONS:

Inserts into the SQL QUERY the text '@P1@'.  This string is a text Parameter to the query where 1 specifies the first parameter listed in the SPREAD PARAMETER LIST field.  For example, @P1@ where the SPREAD PARAMETER LIST equals C2 means the text in cell C2 will replace the @P1@ when the query is executed.

 

Inserts into the SQL QUERY the text #P1#.  This string is a Date Parameter to the query where 1 specifies the first parameter listed in the SPREAD PARAMETER LIST field.  For example, #P2# where the SPREAD PARAMETER LIST equals C2,C1 means the date in cell C1 will replace the #P2# when the query is executed.  When doing comparsions on date type fields you MUST use the #Px# parameter type.

 

Inserts into the SQL QUERY the text $P1$.  This string is a numeric Parameter to the query where 1 specifies the first parameter listed in the SPREAD PARAMETER LIST field.  For example, $P3$ where the SPREAD PARAMETER LIST equals C2,C1,A3 means the number in cell A3 will replace the $P3$ when the query is executed.  When doing comparsions on numeric type fields you MUST use the $Px$ parameter type.

 

Inserts the currently selected table into the SQL Query.

Inserts the currently selected field into the SQL Query.

Saves the currently built Formula to the Pre-Built Formulas (the SPRPTSQL table).  If you have built a complex query and may need to use it in other reports you can save the formula here and use it in other reports. 

 

FIELDS:

Columns: Number of Columns to locate.  Set to the number of fields you want to retrieve from the query.

Rows: Number of Rows (records) to locate.

SQL QUERY: SQL select statement to execute.

FACILITY: Used to locate query results for a differenct Facility (database).  Leave blank to locate data from the current facility.

SPREAD PARAMETER LIST: Parameters list to pass information at runtime into the query.  Parameters can be cell references or spread formulas. 

NOTES:

Locates the SQLFIRST and SQLRESULT functions

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/9/2008 2:17 PM.
Last Modified on 7/31/2008 5:03 PM.
Last Modified by Scott Dorner.
Article has been viewed 5672 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article