Each attribute is characterized by an identifier and a data type.
The identifier must have a unique name within the class and cannot have spaces: the Designer automatically replaces the typing of each
space with the
The data type determines what kind of information is stored through the attribute. The following data types are supported:
String: a string of characters;
Text: a text;
Integer: a numeric data element representing an integer;
Real: a numeric data element representing a decimal number;
Boolean: a truth value (
Date: a date;
Time: a time;
Datetime: concatenation of a date and a time;
Serial: a progressive number that takes on a unique value for each object in the class;
File: reference to a file stored on the server.
Attribute Types #
The following attribute types are supported:
- native attribute: information stored directly in the object table of a class; it is editable, and it is possible to narrow its domain (the set of values that the attribute can take);
- derived attribute: attribute whose value is calculated attribute whose value is calculated from the value of other attributes;
- platform attribute: contains metadata about objects in the class and is automatically managed by Livebase;
- predefined attribute: attribute defined only on the
__Userclass, managed by the platform.
The Object title #
The Object title is the name by which the object of a class being examined in the application is identified; this name is represented by the value of a single attribute.
Set an attribute as Object title #
Select the attribute and right click to open the
Attribute menu; from the drop down menu check the
Object title option.
Create an Object title composed of several attributes #
It is possible to set as Object title a derived attribute of type math that corresponds to the concatenation of several attributes. This concatenation is a string defined in the Math expression editor by means of an expression, which by default is
concat(s1," ",s2,...), where
s2 are the names of the attributes involved and
" " indicates a space separating them. The name of the object shown in the application is thus calculated by concatenating the values of all the attributes that make up the Object title.
Let’s take for example the
Client class shown in the figure; there are three attributes in the list: the first name (
first_name), the last name (
last_name) and the address (
address). If you want to set the full name of the customers as the name of the class object, you can define as Object title a derivative that computes the concatenation of the attributes
last_name (thus not including
Hold down the Ctrl key and select at the same time the attributes that should be part of the Object title; click on one of them to open the
Attribute menu and select
Create object title. Check the expression that is shown in the
Math expression editor: if the expression is valid,
Expression validated as STRING appears in the panel. By clicking
Ok a new attribute, /title, is added to the list. Then you can rename the created Object title as any other attribute.
The resulting output expression in the editor will then be
By default an Object title defined over multiple attributes has the name
/title. Once created, you can rename