Debugging aid for ASP-db.Net to display various 'Actions'.
Obj.dbDebug = "FilterSetup, FilterAction, EditSetup, EditAction, ActiveSQL, Fields, Request"
|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>