G’day,
Just out of my dirty and provocative soul… - have fun :o)
How would be the ORDA-Replacement look like for the following scenario?:
The administrator of a 4D-database is able to set/change the number and the
order of the fields of ALL tables a common user can search in at any time
without re-compiling.
Meaning the Query is constructed with the “;*" parameter.
/QUERY Construction
$count:=1
Repeat // start “collecting" Query parameters
$searchptr:=Get pointer("vtxtSearch"+String($count))
If ((Not(Is nil pointer($searchptr))) & ($searchptr->#""))
SU_SearchTable
(Field([xFieldInfo]TableIDRef;[xFieldInfo]FieldID);$searchptr). // Get info for
the current table
End if
$count:=$count+1
NEXT RECORD([xFieldInfo])
Until (End selection([xFieldInfo]))
\QUERY Construction
QUERY(vptrCurrentTable->) // Execute Query
Cheers
Jörg
**********************************************************************
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************