| 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 %> |