 dbAddTemplate | Replace internal system 'Add' mode template. |
| dbAggregate | Perform Column and Row Aggregate on a grid. |
| dbAggregateExportTemplate | The complementary property of dbAggregate defining the export format of Cols and Rows. |
| dbAllCase | converts all the data values to Uppercase, Lowercase or Cap 1st character. LookUp values are not converted. |
| dbArc |
Set up archive files in virtual directories for display. Instead of a library call, this is a stand alone mini-application by itself. The procedure is to setup virtual directories in the Intranet. Upload all the archive files and place a simple execution file in the lead directory, the one which the execution file (.aspx) will be executed from. Optionally, the config file can be in a separate text file such that the execution .aspx file does not have to be changed. No databse is required and the entire project can be ported to another server w/o adjustments (use curdir) by just copying. |
| dbAreaChart | Define Area chart for GridChart or standalone mode. |
| dbBarChart | Define Bar chart for GridChart or standalone mode. |
| dbbImageDir | dbSkin navigation Non-Css buttons image virtual directory. |
| dbBlankText | Customized text to displayed when cell value is blank. |
| dbBLOB | Display BLOB fields in an inline or HREF linked manner. |
| dbBookMark | Specify a Bookmark to identify a unique record for display and edit. |
| dbBoolText | Customize the True/False display and dropdown text. |
| dbBubbleChart | Define Area chart for GridChart or standalone mode. |
| dbButtonsOnOff | Show/Hide various action buttons in Filter and Edit screens. |
| dbCalendar | Advanced popup calendar to assist date inputs. |
| dbChartParams | Specify additional chart properties and override the default ones. |
| dbColGraph | Display a column of numeric values as a horizontal bar chart in both grid and form mode with automatic data notmalizing option. |
| dbColSortSQL | User specified SQL for grid column sort. |
| dbColumnChart | Define Column chart for GridChart or standalone mode. |
| dbCommonFile | A text file that can be accessed by any property that requires an external source. |
| dbCommonTables | Define application wide lookup tables from a variaty of data sources. |
| dbCountSQL | User supplier SQL query to obtain the record count as the only return. |
| dbCSVDelimiter | User defined delimiter for the csv file. |
| dbCSVName | User defined Csv download filename. |
| dbCulture | Specify the Culture info such that the culture related info will be displayed correctly. |
| dbDateLineChart | Define DateLine chart for GridChart or standalone mode. |
| dbDBType | This is an old syntax and is for backward compatibility. Use dbType. |
| dbDebug | Debugging aid for ASP-db.Net to display various 'Actions'. |
| dbDownloadFlds | Define the fields to be included in the download. |
| dbDownloadHideFlds | Define the fields to hide during download. |
| dbDownloadMagicCell | Apply MagicCell to Download. |
| dbDownloadParams | Define various options for the download - Magic, Lookup, Excel. |
| dbDSN | Setup Datasource connection. |
| dbDualTemplate | Replace internal system 'Dual' mode template. |
| dbDynalist | Dynamic List is an implementation of advanced drill down queries. |
| dbEditAddFlds | Define Edit Add fields and the options of each field. |
| dbEditAddHideFlds | Define Edit Update hide fields. |
| dbEditAddSQL | Define user specified Add SQL. |
| dbEditAllowZeroLength | Set blank values to '' or null in Edit SQL. |
| dbEditcols | Set number of display columns in edit mode. |
| dbEditDateFormat | Format displayed in the edit box as a guide for user preferred date entry format. This format must be of the local culture of the server or th eculture defined by dbCulture. |
| dbEditGridAdd | Full screen Edit Add On/Off switch. |
| dbEditGridAddFlds | Define Grid Edit Add fields and the options of each field. |
| dbEditGridAddSQL | User specified SQL for 'Grid' Add. |
| dbEditGridUpdate | Full screen edit Update On/Off switch. |
| dbEditGridUpdateFlds | Define Grid Edit Update fields and the options of each field. |
| dbEditGridUpdateSQL | Define user specified Grid Update SQL. |
| dbEditMagicCell | Apply MagicCell to display only Edit fields. |
| dbEditRecordScope | Controls where editing is done on single or multiple records. |
| dbEditSelectATAT | Execute SELECT @@Action after MS-SQL edit action. |
| dbEditUpdateFlds | Define Edit Update fields and the options of each field. |
| dbEditUpdateHideFlds | Define Edit Update hide fields. |
| dbEditUpdateSQL | Define user specified Update SQL. |
| dbEditValidateName | User Supplied Javascript function Name for Edit input validation. |
| dbEmbeddedDSN | Set DSN for embedded SQL. Default is dbDSN. |
| dbEmbeddedGridMagicCell | MagicCell applied to Embedded Grid. |
| dbEmbeddedGridNameMap | Apply NameMap to embedded grid. |
| dbErrorRedirect | Redirect to an IRL according to the System Error/Warning/Message return code. |
| dbEventCalendar | Stand alone calendar with event text and scheduling capabilities. |
| dbExportCols | Export Column(s) of a grid in Raw or MagicCell format. |
| dbExportFlds | Export field(s) of a grid row in Raw or MagicCell format. |
| dbFilterAssistant | Toggles FlterAsssitant On/Off state. |
| dbFilterAssistantFont | Set the FilterAssistant Font. |
| dbFilterAssistantTag | Set the dbFilterAssistant Tag. |
| dbFilterConnector | Set the filter default connector. |
| dbFilterFlds | Define Filter/Search fields and the options of each field. |
| dbFilterHideFlds | Define filter hide fields. |
| dbFilterOnEntry | Specify the filter condition upon entry. |
| dbFilterOperator | Set the filter default string operator. |
| dbFilterSQL | User defined filter query. |
| dbFilterTemplate | Replace internal system 'Filter' display template. |
| dbFilterUCaseFunction | Covert filter inputs to uppercase so that mix case input will match an all caps DB setup. |
| dbFilterValidateName | User Supplied Javascript function Name for filter input validation. |
| dbFirstTimeOnly | Execute module only once. |
| dbFormCols | The number of 'Snake' columns in a Form display. |
| dbFormDisplayFlds | Define fields to display in Form from the SQL selected fields. |
| dbFormHideFlds | Define fields to hide in Form from the SQL selected fields. |
| dbFormMagicCell | Transform Form cell value to a variaty of formats. Same as GridMagicCell. |
| dbFormNameMap | NameMap for the Form. Same function as the Grid NameMap. |
| dbFormTemplate | Replace internal system 'Form' mode template. |
| dbGridAddTemplate | HTML code replacing the internal standard grid update template. |
| dbGridCols | The number of 'Snake' columns in a Grid display. |
| dbGridDisplayFlds | Define fields to display in Grid from the SQL selected fields. |
| dbGridHideDupRecFlds | Fields to apply hide duplicates Column cells. |
| dbGridHideFlds | Define fields to hide in Grid from the SQL selected fields. |
| dbGridMagicCell | This is an old syntax and is for backward compatibility. Use dbMagicCell. |
| dbGridStrips | Specify the display row/column alternating effect. |
| dbGridTemplate | Replace internal system 'Grid' mode template. |
| dbGridUpdateSumbitModifiedRowOnly | Submit only the modified row(s) in grid update. When row update is not submitted, all hidden fields will not be submitted also, |
| dbGridUpdateTemplate | HTML code replacing the internal standard grid update template. |
| dbHideDupBlankText | Replace repeated column cells with a user 'dido' text. |
| dbIdFileDir | Directory of id file. Allow user to define the location of the tornado.idx file. |
| dbImageDir | Directory of Non-Css type images. |
| dbInitSortCols | Columns (1 based) to be sorted initially upon entry. |
| dbInitSortFlds | Fields (0 based) to be sorted initially upon entry. |
| dbInstallDir | Root of Tornado installation. |
| dbInvisible | Toggle display status. |
| dbLargeDownload | Toggle large download switch for Download. |
| dbLineChart | Define Line chart for GridChart or standalone mode. |
| dbLocalCurrency | User specified local thousand separator to override the culture value. |
| dbLocalDecimal | User specified local decimal format to override the culture value. |
| dbLocalText | Localize the system message text. |
| dbLocalThousand | User specified local thousand separator to override the culture value. |
| dbLogin | Setup and activate Multi-User Login. |
| dbLoginTemplate | Replace internal system 'Login' template. |
| dbLongDate | Toggle the state of the Long Date (inc. h:m:s) for edit and filter. |
| dbLookUpFlds | Define Fields/Columns in the SQL as a key and display the lookup instead of the raw key value. |
| dbMagicCell | Transform grid cell value to a variaty of formats. A highlight of the ASP-db tool. |
| dbMail | Set Email properties for ASPdbSendMail, Upload and Edit. (DoNet 1.x) |
| dbMemoFlds | Emulates Classic ASP-db and allows only (1) memo field to be dislayed below the grid. |
| dbMemoTextSize | Specify maximum length of MEMO fields. |
| dbMode | Set Display mode and options. |
| dbMultiModules | Define the unit is in a multiple modules state. |
| dbMyInputFlds | Type type of each Input Fields for ASPdbMyInputForm. |
| dbNameMap | NameMap for the Grid. Rename the field names in the header display and optionally supply the calculated expression required for sort, edit and filter criteria. |
| dbNavigationItem | Setup navigation buttons. |
| dbNoHead | Suppress the <HEAD> block code to be emitted. |
| dbNullText | Define text to display for 'Null' and also set edit criteria text to 'Is Null'. |
| dbOptions | Miscellaneous options. |
| dbPageSize | Set paging row count and also row+, row-. |
| dbPieChart | Define Pie chart for GridChart or standalone mode. |
| dbPopText | Display text or memo field text in a popup window via MagicCell. |
| dbProvider | Specify the Data Provider. Data provider comes in a general flavor like ODBC and OLEDB and a native flavor like SQLClient, DB2Client, MYSQLClient and OracleClient. There is no logical reason not to use a 'Native Client' which is developed for the DB in a specify platform. |
| dbQP | Quick Properties (dbQP) allows you to batch build all the write only properties for convenience and performance. |
| dbRecordCount | Preset recordset record count. |
| dbRefresh | Set refresh in <meta> tag http-equiv="refresh" |
| dbRemoteURL | Specify remote URLs for Remote operations. |
| dbResultSet | Specify which result set to retrieve from StoredProcedure |
| dbSearchFilesParams | Define parameters for ASPdbSearchFiles. |
| dbSelectedBoxFormTemplate | Replace internal system 'SelectedBoxForm' template. |
| dbSelectedItem | Special application to return select item and qty of grid. |
| dbSelectedItemMacro | Define SelecetdItem setup parameters. |
| dbSelectExactSQL | Define SQL(s) to selct the exact amount of records for display. MS-SQL uses TOP, ORACLE uses ROWCOUNT, MYSQL Uses LIMIT and DB2 has it's own variabtions. |
| dbSendHead | Include user text in the <HEAD>..</HEAD> block. |
| dbShowDeleteStatus | Show SelectItems deleted items. |
| dbSilentCmdText | Define SQL(s) to be executed before first entry. |
| dbSkin | Setup (Skin) Css Text style for display. |
| dbSortColLeftJustify | Toggle displaying sorted fields to the left of grid. |
| dbSortFlds | Fields in Grid to be sorted (0 based). When specified, the Up/Dn sort arrows will be added to the Column header. |
| dbSQL | Primary SQL for records retrIval. |
| dbSQLDateFormat | Date format required to build the correct date fields for edit SQL statements. |
| dbStartUp | StartUp parameters. |
| dbStartUpGoto | Performs a linear search to locate the first matching record from recordset on entry. |
| dbStatusBar | Set Status bar display. |
| dbStatusBarFont | Set Status bar font type. |
| dbStickyAdd | Set Status bar font type. |
| dbStockTicker | Set properties to retrieve Stock tickers. |
| dbStockTickerTemplate | Set the template for the stocker tickers. |
| dbStoredProc | Define stand alone SP properties for ASPdbSP, ASPdbDS or ASPdbSP2DS. |
| dbStoredProcCmdParams | Define SP full in/out parameters properties for ASPdbSP, ASPdbDS or ASPdbSP2DS. |
| dbSuperBar | SuperBar is an implementation of fancy navigation, goto, and search functions. Type=1 has only the navigation and Type=2 includes the SuperGoto functions (See Startupgoto for more details). Super bar will adjust the color automatically according to dbSkin. Superbar is equivalent to the navigation and it can be positioned anywhere. It's object reference is also [[GridNav]]. A special implementation for Alphabetic A-Z type search via the dbSuperGotoFld property. This is especially useful for a sorted column that user can goto the record of a preferred prefix. |
| dbSuppressMsg | Suppress system messages. |
| dbTemplateDir | Override default system templates directory. |
| dbTestBlankTable | Test for 'blank table' and 'no return records' before read/write actions. |
| dbTextHolder | Insert custom text in output HTML code. |
| dbTransparent | Disable Css for user cusomization. |
| dbTransparentTbStyle | User specified table style for dbTransparent. |
| dbTrueVar | Set value of True in application. |
| dbType | Specify the Datasource type for DSN and SQL related setup. Mandatory for MS-SQL data source. |
| dbUnit | Define the a number to provide unique identification to the module. |
| dbUpdateTemplate | Replace internal system 'Update' template. |
| dbUpload | Execute standalone multiple files upload with auto email option. Entire applicatoin in (2) lines. |
| dbUserAddTemplate | User designed template for Edit Add operation. |
| dbUserFilterTemplate | User designed template for Filter/Search operation. |
| dbUserUpdateTemplate | User designed template for Edit Update operation. |
| dbValidatorParams | Activate Validation and setup validation parameters. |
ASPdbArc
Finalize (inherited from Object)