Specify the filter condition upon entry.

Product Version

Property Value

Obj.dbFilterOnEntry = "Filter criteria"

QuickProp Keyword Abbreviation

Remarks

This is a tool to control the records different user can see. This filter is made as part of the dbSQL and cannot be rest. Use this as a macro [[FilterOnEntry]] in conjunction with dbSQL. The difference between the user building the dbSQL using an external input like the URL and this property is security. For example, if user has to activate the program using Program.aspx?name=Frank and then build the dbSQL using 'Frank'. There is no security at all compare to starting the program and building the SQL based on the property which is not accessable to the user.

Example

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim x As New Tornado.z
  x.dbQP = "u=1|D=Nwind|Ni=b5,Filter,ResetFilter|gdf=0,1,2"
  x.dbFilterOnEntry = "OrderId > 10260"
  x.dbSQL = "Select * from Orders"
  x.dbDebug = "ActiveSQL"
  x.ASPdbNET()
End Sub
</script>

See Also

z Class | Tornado Namespace | dbSQL | Special Topic - Filter

---