Start

Connect

Help

1 Click DB Online Help

1. Connect
2. Browse
3. Search
4. Add/Edit/Delete
5. Code Wizard

1. Connect

   Use the Connect screen to constructs the specially formatted information needed to link your web server to a database. Click on a supported database type for a connection wizards or input the ADO information directly into the Connect String textbox. The Connect String textbox can also be used to specify an ODBC Data Source Name ("DSN") or named shortcut to your database. These are typically created on your web server by an administrator using the Windows Control Panel interface.

   Having problems connecting? Review the 1 Click DB Knowledge Base on Resolving Common ADO Errors.

   By default, connection information, including the user name and password are indirectly saved in special text files called session cookies. These cookies do not store the actual information you are using in your browser or client computer, but a long cryptic name that refers to a set of variables maintained on the web server. These files are only active while you are logged on to the web site and expire if no activity is recorded for a timeout determined by your web server. Administrators can also hard coding connection string information in the ocdConfig.asp configuration file.

   If your web browser and web server support it, switch between Secure Socket Layer ("SSL") encryption and plain text communications using the "Enable SSL" and "Disable SSL" links. These links work toggling the URL of the current page from http:// to https:// If either your web server or your web browser does not support SSL encryption, attempts to display pages starting with https:// will fail.

   Any database using an internal IP address (usually of the form 10.x.x.x or 192.x.x.x) or a Windows share name must be on the same local area network as the web server to connect.

   Notes on Connecting to Microsoft Access:

   Access database files must be either on the hard drive of your web server, or on a shared network drive accessible to your web server. Since Access is a file based database system, you can only connect to .mdb files that your web server can access directly as a file. Although DSN-less connect strings require the physical path to an Access database to work correctly, this Connect Wizard will automatically translate a virtual path from the root of your web server if you use that as the path on this screen. Choosing an ODBC connection for MS Access is considerably slower and less reliable than an OLEDB connection and should be avoided if possible.

   1 Click DB uses the excellent free tree menu framework from http://treemenu.com. This menu system supports most popular browsers, but will not be active when any of the 1 Click DB compatibility options are selected (e.g. "No Frames" or "No JavaScript".) If the menu works for a user on some databases but not others, odds are there are special characters in the name of at least one of the database's table or view objects that have not been anticipated by 1 Click DB. Please contact 1 Click DB support with a list of your database table and query view names for a quick remediation. Since the menu relies on a frame system, bookmarks will generally return the user to the initial DB Properties screen. The exception to this is when you use Save button present on a 1 Click DB Browse grid. A "Restore Frameset" link is present at the bottom of all content pages. This is useful when returning to a bookmarked Browse grid or any other time when the content frame has been "unframed" in the user's browser.

   Back To Contents

2. Browse
   • Bookmark Your Browsing
     Since all the filter, sort, position and other user definable parameters are set in a browse page's querystring, you can effectively "save" your view by bookmarking it. When using a frameset be sure to bookmark the frame containing the browse page.

   • Drill Down
     This button toggles drill down on and off for a grid. When drill down is on the values for most fields turn into hyperlinks. Clicking on these hyperlinks sets a filter on the grid for all other fields that match the current value. If there is only one record in the view this button has no effect.

   • First Prev Next Last
     These controls let the user navigate through multiple pages on a grid. From left to right the buttons will move to the first page, move to the previous page, move to the next page and move to the last page of a results set. If you are on the first page of a results set, the move first and move previous buttons will display, but will not have active links. If you are on the last page of a results set, or if there is only one page the move next and move last buttons will display but will not have active links.

   • New
     This button will take the user to the edit page defined for the recordset at the new record position.

   • Print
     The print function allows one click access to your browser's print functionality. A new window will open with ALL the data from the query displayed (no paging) and plain formatting (this may be a large file). For Internet Explorer users the print dialog will also appear after the page has been fully loaded.

   • Export
     These buttons will stream the entire recordset as it is show on the screen as different export formats. Defined filter and sort criteria are retained, however paging is ignored. The entire recordset is always set for export. For this reason, these buttons should be used with caution when dealing with large recordsets. If the user attempts to export too much data at once, the transfer may fail. Note that Excel exports are really HTML streams with the MIME type set for the Microsoft spreadsheet.

   • Sort Links
     These two buttons appear beneath the every field name that is sortable. Binary and memo fields are not sortable and so these will not appear.

   • Filter Links
     These buttons appear below the names of every field except binary ones. Clicking on them will bring up a filter screen.

   • Edit Links
     Clicking this button will take the user to the edit page for the current record.

   Back To Contents

3. Search

   Each table and view can be searched using the Query By Form functionality of the Search Pages. Keyword searches support boolean expressions like "and" "or" and "not". To search for all records containing either the word John or the word Smith anywhere in any field use the expression John Smith. To search for all records containing both the word John and the word Smith anywhere in any field, use the expression John AND Smith. To search for all records containing the exact phrase John Smith in any field, use the expression "John Smith".

   For Access and SQL Server, keyword searches for numeric expressions will examine all non-binary fields in the database. For other databases and for all alphabetic criteria, only text fields are keyword searched.Page size and sort order can also be specified on this screen. The check boxes next to each field name determine whether or not a field will be displayed when browsing results.

   Search criteria are passed using query strings. If your query string is too long, your browser may not display the results page. This is most often a problem when doing keyword searches using numeric expressions on tables with a large number of fields.

   Back To Contents

4. Add/Edit/Delete

   Add/Edit/Delete pages enable the maintenance of database information via any HTML web browser. When supported by the database provider, required fields are marked with a red asterisk, default values will be shown, and single field foreign keys displayed as drop down lists. Microsoft Access and SQL Server databases using an OLEDB provider also display a master/detail view of all related records. Most databases and ADO providers do not fully support updating Views.

   Back To Contents

    

5. Code Wizard

   Administrators must set the variable ocdShowWizard = True in the ocdConfig.confuration file to activate Code Wizard controls on Browse pages for MS Access and SQL Server.

   Click the Magic Wand icon preceeding the SQL text and jump directly to the ASP Code Wizard control for any Browse data page.

   Browse/Search/Export and Add/Edit/Delete pages for Views and Tables must be generated separately. Use Code Wizard controls to choose an Edit page Template instead of the default browse template. Name for this is, by default TableName_Edit.asp but you can change this to whatever you like by setting the .FormEdit variable on a browse grid page.

   Core Browse/Search/Export functions are contained in the file ocdGrid.asp. This file lists all built in public properties to customize DataGrid settings along with a short note describing its functions. By default, properties to set all English language text for the 1 Click DB DataGrid are stored in the corresponding ocdGrid_Lang.asp include files.

   Core Add/Edit/Delete functions are contained in the file ocdForm.asp. This file lists all built in public properties to customize Grid settings along with a short note describing its functions. By default, properties to set all English language text in corresponding for the 1 Click DB DataForm are stored in the corresponding ocdForm_Lang.asp files.

   Back To Contents

   For more information on 1 Click DB including lots of tips for customizing Code Wizard applications, check out our online knowledge base at http://AccessHelp.net/kb or contact AccessHelp.net for support.

8/20/2008 11:31:30 AM @ coveryourasp.com - powered by open source 1 Click DB  4.201011 software ©1997-2002 AccessHelp.net Custom Solutions