The All-in-One Database Software Solution

Online Help System

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

Operations with database software records

Add Record
(RecordType, ParentFolder, Relation, CreationMethod)

Used to create a new database software record of the specified RecordType in the specified ParentFolder. If the RecordType parameter is not specified, the new database software record will be of the same type as the selected one. If no database software record is selected, a database software record of the main type will be created (a top row in the Add menu). If the ParentFolder parameter is not specified, the database software record will be created in the current folder. If the Relation parameter has the Yes value, the added database software record will be linked to the selected database software record; otherwise the relation will not be created.
CreationMethod parameter may possess the following three values:

Create and select - a new empty database software record is created and opened for editing;
Just Create New Record - a new empty database software record is created, but not highlighted, i.e., the database software record marked as current before creating the new database software record, remains the same;
Create using popup form - a pop-up form for a database software record entry is displayed to the user. If the user clicks OK, a database software record will be created with all entered data. If the user clicks Cancel, the database software record will not be created.

RETURN VALUE: Returns a database software recordset with the created database software record if database software record was added; otherwise 0 is returned.

Popup Record(s)
(RecordsToShow, RecordByDefault)

Used to show the database software recordset specified in the RecordsToShow parameter in a new window:

The database software records opened in a new window can be edited. To choose the database software record for editing, use the arrow at the bottom of the screen. For this operation to be successful, all database software records in the set should be of the same type.
Using a database software recordset RecordByDefault variable, you can set up a default database software record for the opened window.
Learn more about database software recordsets...

Clone Records ()

Used to create a replica of the selected database software records.
RETURN VALUE: Returns 1 if database software records have been cloned successfully; otherwise 0 is returned.

Delete Records ()

Used to delete the selected database software records.
RETURN VALUE: Returns 1 if database software records have been deleted; otherwise 0 is returned.

Move Records
(Folder)

Used to move the selected database software records into the specified Folder.
RETURN VALUE: Returns 1 if database software records have been moved successfully; otherwise 0 is returned.

Find Records
(DefaultFolder, DefaultText)

Used to open the Find Records window. By default, the specified DefaultText will be searched in the specified DefaultFolder.

Sort Records
(SortOrder)

Used to sort database software records in the current folder using the specified SortOrder. If SortOrder is not specified, the dialog for sorting database software records will be opened.

Select all Records (Folder)

Used to select all database software records in the specified Folder.