Retrieving view data
In these examples, the name of the view for formulas that reference a
project is V\PROJECT1
. The first column, "VIEWCOL1"
, in the FsValidationField
table, is the Formula Code. The version is fetched
separately.
This syntax retrieves all of the formula codes.
fRaw = ObjProperty("VIEWCOL1.VIEWS.V\PROJECT1","","","*","")
This syntax only retrieves the formula codes for the formulas that have
'0001
' as the version. The last argument can be the name
of the column in the database.
fRaw = ObjProperty("VIEWCOL1.VIEWS.V\PROJECT1", "", "", "0001","VERSION")
Or, it can be the validation field name or number.
fRaw = ObjProperty("VIEWCOL1.VIEWS.V\PROJECT1", "", "", "0001","VIEWCOL2")
fRaw = ObjProperty("VIEWCOL1.VIEWS.V\PROJECT1", "", "", "0001","2")