Roel Westhoff [W4]
6-Jun-2010, 01:27 AM
Hello Daw (Vincent),
We are using VRW RCIII with vdf15.1
We have a problem with the filterfunction. Something strange is happening and i can't find anything wrong. We are in process of implementing VRW in our new app.
The report is on a single flat-file with the fields (ACCNT.ADMPO, ACCNT.ADMPRJ,ACCNT.ADMNR,ACCNT.ACCNTNR,ACCNT.DESCR IPTION). The database is Pervasive9.5.
The indexing is
Index.1 ACCNT.OVERLAPADM (ADMPO+ADMPRJ+ADMNR)
ACCNT.ACCNTNR
Index.2 ACCNT.OVERLAPADM (ADMPO+ADMPRJ+ADMNR)
ACCNT.ACCNTNR
Index.3 ACCNT.ADMPO
ACCNT.ADMPRJ
ACCNT.ADMNR
ACCNT.ACCNTNR
The below filterfunction does work but if delete the comments no filtering is executed
// Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ADMPO} = " + //String (trim(sAdmpo)) + "") to sFilterFunction
Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ADMPRJ} = " + String (trim(sAdmprj)) + "") to sFilterFunction
Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ADMNR} = " + String (trim(iAdmnr)) + "") to sFilterFunction
If (sFromAccntnr <> "") Begin
Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ACCNTNR} >= " + String ((trim(sFromAccntnr))) + "") to sFilterFunction
End
If (sToAccntnr <> "") Begin
Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ACCNTNR} <= " + String ((trim(sToAccntnr))) + "") to sFilterFunction
End
Can you explain why i encounter this problem. Is this a bug?
Roel
We are using VRW RCIII with vdf15.1
We have a problem with the filterfunction. Something strange is happening and i can't find anything wrong. We are in process of implementing VRW in our new app.
The report is on a single flat-file with the fields (ACCNT.ADMPO, ACCNT.ADMPRJ,ACCNT.ADMNR,ACCNT.ACCNTNR,ACCNT.DESCR IPTION). The database is Pervasive9.5.
The indexing is
Index.1 ACCNT.OVERLAPADM (ADMPO+ADMPRJ+ADMNR)
ACCNT.ACCNTNR
Index.2 ACCNT.OVERLAPADM (ADMPO+ADMPRJ+ADMNR)
ACCNT.ACCNTNR
Index.3 ACCNT.ADMPO
ACCNT.ADMPRJ
ACCNT.ADMNR
ACCNT.ACCNTNR
The below filterfunction does work but if delete the comments no filtering is executed
// Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ADMPO} = " + //String (trim(sAdmpo)) + "") to sFilterFunction
Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ADMPRJ} = " + String (trim(sAdmprj)) + "") to sFilterFunction
Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ADMNR} = " + String (trim(iAdmnr)) + "") to sFilterFunction
If (sFromAccntnr <> "") Begin
Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ACCNTNR} >= " + String ((trim(sFromAccntnr))) + "") to sFilterFunction
End
If (sToAccntnr <> "") Begin
Move (sFilterFunction + (If (sFilterFunction <> "", " and ", "")) + "{ACCNT.ACCNTNR} <= " + String ((trim(sToAccntnr))) + "") to sFilterFunction
End
Can you explain why i encounter this problem. Is this a bug?
Roel