Programming guide to Unibase

14 : Database statements

Add statement

add table [as pointer]	Add a new record to the table. A pointer can be assigned to the new record.
... code ...	Within the add statement the fields can be changed or stay at the default value.
update

Delete statement

delete pointer	Delete the current record of the pointer.

Clear statement

clear table	Remove all records from the give table.

Edit statement

edit pointer	Edit the fields of the record of the pointer.
... code ...	Within this statement field values can be altered.
update

Search statement

search index [as pointer] [where expression]	Search records via an index. A pointer can be assigned for the records.
... code ...	Within this statement two extra fields can be read.
[pointer.first]	The field 'first' contains 'true' on the first record read.
... code ...
[pointer.recnr]	'recnr' contains the number of the current record within the search.
... code ...
next

Get statement

get index [as pointer] [where expression]	Get a single record from a table.
... code ...	After this statement the pointer contains the found record.
pointer.found	The field 'found' contains 'false' when no record matches.