Debugging aid for ASP-db.Net to display various 'Actions'.
Obj.dbDebug = "FilterSetup, FilterAction, EditSetup, EditAction, ActiveSQL, Fields, Request"
| Keyword | Description |
|---|---|
| FilterSetup | List the filter criteria string at setup |
| FilterAction | List the filter SQL string after submit |
| EditSetup | List the Edit setup SQL string |
| EditAction | List the Edit SQL after submit |
| ActiveSQL | Final SQL after applying all filters |
| Fields | DBType Member Name of field attributes. Use this for SP input. |
| Request | Dump Querystring and Form variables |
The following screen dump illustrate an interesting debug item (Fields). This item display the attributes of the fields in action. The data type is one piece of information that is a big help when yo u are working with full parametrs StoredProcedures. Note that working with OLEDB, ODBC and SQLClient will yield different results. This one feature will save you a lot of time.
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim E2 As New Tornado.z
With E2
.dbUnit = 2
.dbGridDisplayFlds = "0,1,2"
.dbDSN = "fujitsu;pubs;sa;sa"
.dbSQL = "Select * From titles"
.dbTextHolder = "Title=Debug Fields Demo"
.dbDebug = "Fields"
.ASPdbNET()
End With
</script>