Debugging aid to display various 'Actions'.

dbQP Abbr: se
Version: All

Namespace:  Tornado
Assembly:  Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)

Syntax

C#
public string dbDebug { get; set; }
Visual Basic (Declaration)
Public Property dbDebug As String

Field Value

Obj.dbDebug = "FilterSetup, FilterAction, EditSetup, EditAction, ActiveSQL, Fields, Request"
KeywordDescription
FilterSetup List the filter criteria string at setup
FilterAction List the filter SQL string after submit
EditSetup List the Edit setup SQL string
EditActionList the Edit SQL after submit
ActiveSQLFinal SQL after applying all filters
FieldsDBType Member Name of field attributes. Use this info to provide accurate SP parameters input.
RequestDump Querystring and Form variables

Examples

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 you 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.
CopyVB.NET
<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>

See Also