Mike: Created page with "== Declaration == SetFilter(Filter as String) as Boolean == Description == Returns true or false whether a filter is succesfully set on the table == Notes == This method fi..."

2012-05-22T09:51:47Z

Created page with "== Declaration == SetFilter(Filter as String) as Boolean == Description == Returns true or false whether a filter is succesfully set on the table == Notes == This method fi..."

New page

== Declaration ==
SetFilter(Filter as String) as Boolean

== Description ==
Returns true or false whether a filter is succesfully set on the table

== Notes ==
This method filters a set of records in a opened table.
All standard pdc filter functions and expressions are available.

== Code example ==
This code filters all calculations with status seven, deliverymonth december and delivery year 2008.
Par calculation the calculationnumber is shown.

<source lang="vb">
Dim tblDO_ORDER
dim strFilter

Set tblDO_ORDER = pdc.DataBase.OpenTable(pdcConData, "DO_ORDER", "DO_ORDNR")
strFilter = "(UPPER(DO_STAT)='7') AND (Month(DO_LEVER)=12) AND (YEAR(DO_LEVER)=2008)"
'msgbox strFilter
tblDO_ORDER.SetFilter strFilter

if tblDO_ORDER.RecordCount > 0 then
msgbox tblDO_ORDER.RecordCount

tblDO_ORDER.FirstRecord
do while not tblDO_ORDER.Eof
msgbox "Calculation no: " & tblDO_ORDER.GetField("DO_ORDNR")

tblDO_ORDER.NextRecord
loop
end if
</source>

== Availability ==
Available since June 2008 (from version 3.8)

PdcDBTable.SetFilter - Revision history

Mike: Created page with "== Declaration == SetFilter(Filter as String) as Boolean == Description == Returns true or false whether a filter is succesfully set on the table == Notes == This method fi..."