dbTables

This property is to be used when dbSQL = "*" is used. It reads the table schema and present to the user for selection. The dbSQL="*" will select all fields. At this time it doesn not read the Views and Stored Procedures as the schema is different for different databases. The first parameter is the vertical length of the listbox containing the table namess. If there are more tables in the database than will fit in this height, you will get vertical scrolling. The second parameter is the table owner. Different owner can have tables of the same name. This parameter filters the tables that belong to the owner.

AllowedOwner="dbo,abc..." will show TABLE-SCHEMA. owner.table if not blank (ACCESS=Null OK)
HideNamePrefix="sys,domain..." these are the prefix of names to discard.
This mod is essentially for MS-SQL which is a good provider. ACCESS and ORACLE is lousy.

Property Syntax

Obj.dbTables = "ListBox Height, AllowedOwner, HideNamePrefix, TableType"

Parameters

Parameters

Default Value

Description

ListBox Height 20 Height of listbox
Table Owner   Owner of table
HideNamePrefix   Prefix that matches this will not be displayed
TableType TABLE TABLE | VIEW | SP

Example

<!-- #include File=ASPdb.Inc -->
<%
Response.buffer = True
Set X= Server.CreateObject("ASP.DB")
X.dbUnit = 999
X.dbCacheSize = 1
X.dbDBType = "SQL"
X.dbDSN = "Provider=SQLOLEDB; Initial Catalog=northwind; User id=sa"
X.dbTables="7,,Order,View"    'Hide all VIEWS containing 'Order'
X.dbSQL = "*"
X.ASPdb
%>