Tornado API Library - V12.30.08

z.dbDebug Property

Debugging aid for ASP-db.Net to display various 'Actions'.

Product Version

All
[VisualBasic]
PublicPropertydbDebugAsString
[C#]
publicstringdbDebug{set;}

Property 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 for SP input.
RequestDump Querystring and Form variables

QuickProp Keyword Abbreviation

de

Example

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>

See Also

z Class | Tornado Namespace