cAliasCharacterRequired
SX2/SX3 alias.
FUNCTIONUnder review
BuildExpr
BuildExpr( <cAlias>, [oWnd], <cFilter>, [lTopFilter], [bOk], [oDlg], [aUsado], [cDesc], [nRow], [nCol], [aCampo], [lVisibleTopFilter], [lExpBtn], [cTopFilter] ) --> cRetOpens a dictionary-driven visual filter-expression builder.
Overview
BuildExpr uses SX2/SX3 to offer fields and construct a filter expression. The historical page lists 14 positions; cAlias and cFilter are required by the described contract, so the example explicitly supplies an empty string as the third argument while keeping Nil for the window object. Returned text is not an executed query. aUsado/aCampo can restrict fields; do not freely convert received text into code or assume the builder authorizes data access. Requires an interactive session and a registered, open alias. (TOTVS, n.d., ref. 1)
Syntax
BuildExpr( <cAlias>, [oWnd], <cFilter>, [lTopFilter], [bOk], [oDlg], [aUsado], [cDesc], [nRow], [nCol], [aCampo], [lVisibleTopFilter], [lExpBtn], [cTopFilter] ) --> cRetParameters
oWndObjectOptional
Reference window.
cFilterCharacterRequired
Initial expression, possibly empty.
lTopFilterLogicalOptional
Allows TOP expression; default false.
bOkCode blockOptional
Validation, dependent on oDlg.
oDlgObjectOptional
Related processing dialog.
aUsadoArrayOptional
Used/restricted fields under the page contract.
cDescCharacterOptional
Expression description.
nRowNumericOptional
Position row.
nColNumericOptional
Position column.
aCampoArrayOptional
Field configuration.
lVisibleTopFilterLogicalOptional
TOP filter visibility.
lExpBtnLogicalOptional
Expression-button control.
cTopFilterCharacterOptional
Initial TOP expression.
Return value
Character filter expression; the example only checks its length when type is C.
Commented example
#Include "Protheus.ch"
User Function EdBuildex()
Local cFilter := ""
// SA1 must be open in an interactive test session.
If Select("SA1") > 0
cFilter := BuildExpr("SA1", Nil, cFilter, .F.)
If ValType(cFilter) == "C"
ConOut(cValToChar(Len(cFilter)))
EndIf
EndIf
Return NilExpected result
Length depends on interaction; no filter application, query execution or record write. Under review: editorial example neither compiled nor run in Protheus. Check includes, release, RDD and context before testing.
- Check all 14 arguments against the installed release reference. Preserve caller context and validate fields and expression before later application.
- Under review: editorial example neither compiled nor run in Protheus. Check includes, release, RDD and context before testing.
Comments
There are no approved comments yet.
Sign in with Google or Microsoft to comment.