The All-in-One Database Software Solution

Online Help System

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

Operations with records

Add Record
(RecordType, ParentFolder, Relation, CreationMethod)

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

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

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

Popup Record(s)
(RecordsToShow, RecordByDefault)

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

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

Clone Records ()

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

Delete Records ()

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

Move Records
(Folder)

Used to move the selected records into the specified Folder.
RETURN VALUE: Returns 1 if 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 records in the current folder using the specified SortOrder. If SortOrder is not specified, the dialog for sorting records will be opened.

Select all Records (Folder)

Used to select all records in the specified Folder.