Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index



Operations with database


Open a Database
(DatabasePath)

Used to open the database specified in the DatabasePath parameter. If the DatabasePath is not specified, the user will be suggested to specify the path to the database.


Create Backup Copy
(Path,FileMask, Rewrite )

Used to create a backup copy of the current database at the Path under the FileMask name. The FileMask paremeter can contain the current date or (and) time. If Rewrite equals to Always, the specified file will be rewritten without any notification.


Custom Export
(Template, Records)

Used to export data according to the template specified in the Template parameter. If the Template parameter is not specified, a dialog with the list of all templates in the database will be displayed. The Records parameter indicates the source of exported database software records. 


Print Records
(ShowPrintPreview, Records, ReportStyle)

Used to print out the selected database software records. If the ShowPrintPreview parameter is specified, the preview window will be displayed before printing. Otherwise the printing process will start without any notification. The ReportStyle parameter determines what report style will be used. The Records paremeter determines the group of database software records to be used for the report.


Show Report
(Records, ReportStyle, WhatPart)

Used to show a window with a report. The ReportStyle parameter determines what report style will be used. The Records parameter determines the group of database software records to be used for the report. The WhatPart parameter determines what part of report style will be used to show the report.


Parse web-page
(URL, ImportType, Connection)

Used to import text from a web page specified at URL and send it to the parsing system. The ImportType parameter specifies the way the data should be imported - including html tags or not. The Connection parameter defines the connection type to be used when importing data:

  • Direct - dedicated fast-speed connection; unfortunately, some websites can prohibit this connection type.
  • Web-Browser - the program simulates a web browser and returns the page content as if it was viewed through a regular browser.

Example:

Parse web-page("http://www.google.ru/search?q=database","Text only","Web-Browser") - returns google search results for the term "database".


Get web-page content
(URL, ImportType, Connection)

The action of the given command is totally identical to the Parse web-page command; the only difference is that the content of the page is not passed to the parser, but saved to a specified variable.

RETURN VALUE: Content of a web page located by the URL address.


Import From a Database
(DatabasePath, ImportPreset, ShowPreview)

Used to import data from the database with a different format (such as mdb or xls). DatabasePath is the path to the database from which database software records are to be imported. ImportPreset is the import template, ShowPreview defines whether the import dialog should be displayed. If the ShowPreview is not set, the importing process will start without any notification. If the ShowPreview is set, the dialog for setting up importing parameters will be displayed. The dialog for setting up importing parameters will also be displayed if the DatabasePath or ImportPreset parameters are not specified.

RETURN VALUE: Returns the number of database software records were imported.


Import from MS Outlook
(ForlderFrom, FolderTo, ParsingStyle, MailsToParse)

Used to import e-mails from the FolderFrom folder of an MS Outlook account. The imported messages are passed to a suitable parser for processing. The optional parameter FolderTo defines the folder of an MS Outlook account into which the imported database software records will be moved. The ParsingStyle parameter defines the way the messages should be handed to the parser: either all messages will be sent as a large text or each message will be transmitted separately. In the MailsToParse parameter you can specify the mask for subjects of messages you want to import. If you don't specify the mask, you'll have to select messages to be imported in a dialog box.

RETURN VALUE: Returns the number of imported e-mails.


Export To a Database
(DatabasePath, ExportPreset, ShowPreview)

Used to export data to the database with a different format (such as mdb or xls). DatabasePath is the path to the database to which database software records are to be exported. ExportPreset is the import template, ShowPreview defines whether the export dialog will be displayed. If ShowPreview is not set, the exporting process will start without any notification. If ShowPreview is set, the dialog for setting up exporting parameters will be displayed. The dialog for setting up exporting parameters will also be displayed if the DatabasePath or ExportPreset parameters are not specified.

RETURN VALUE: Returns the number of exported database software records.


Export DB Operation
(Operation, Column, RecordType, Data)

Allows to work with a 3rd party Database, directly export and import any data. To learn more, see the Exporting to 3rd part DB using script section.

RETURN VALUE: Returns cell value.


Execute Query
(Query)

Used to execute a query. If the Query parameter is not specified, a dialog with the list of all queries in the database will be displayed.

RETURN VALUE: Returns the number of database software records found by the query.


Share Database
(DbNetName, DbNetPass, UserName)

Used to make the current database available for using in a network. In the DbNetName parameter you should specify the netname of the database; the DbNetPass parameter specifies the password used to connect to the database, and the UserName parameter specifies the name of the user who works with the database as a server. See the Networking section for more details.

RETURN VALUE: Returns 1 if the database was shared, otherwise 0 is returned.


See Also:

List of Actions