[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
FUNCTION QUERY()
Short:
------
QUERY() Popup Interactive query by example condition
builder
Returns:
--------
<cQuery> => macro expandable logical condition
expression
Syntax:
-------
QUERY([aFields,aDesc,aTypes],[cQuitTo],[lUseBuildex])
Description:
------------
A point and shoot condition builder. Complex
conditions are allowed with multiple .and./.or. Called without
parameters, all fields in the current dbf are presented for condition
building.
[aFields,aDesc,aTypes] give field array, field
description and field types.These, if passed will be used in
place of the default of all dbf fields. (pass all or none)
[cQuitTo] is a 'quit to' phrase. Default exit option
is 'Quit'. 'Quit to' phrase will be tacked to the end of this .
i.e. "Quit"+quit_to [ Quit to Report Writer ]
[lUseBuildex] determines whether BUILDEX() expression
builder will be available from QUERY(). Default is not.
Examples:
---------
USE CUSTOMER
aFields := {"fname", "lname", "mi" }
aFdesc := {"First", "Last", "Middle" }
aTypes := {"C","C","C"}
cFilt := QUERY(aFields,aFdesc,aTypes,nil,.t.)
count for &cFilt to nCount
// or (preferably)
count for eval( sls_bquery() ) to nCount
Notes:
-------
Query always stores the current query with the
function SLS_QUERY(). Calling SLS_QUERY() will return the
currently stored query string. SLS_BQUERY() returns the query as
a codeblock. Remember to clear sls_query()/sls_bquery() when
changing DBFs.
Source:
-------
S_QUERY.PRG
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson