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 See also : SLS_BQUERY(), SLS_QUERY()
Pingback: SP Metafunction | Viva Clipper !
Pingback: SP Functions | Viva Clipper !