Primitive data types like Integer, character and date are supported. Time and BLOB data types are not supported.

A single field primary key (Serial number generated through counter) should identify Root Objects in Vaakya. Contained or Descendent objects can have combined primary keys. This approach is adopted so that, in a concurrent user environment, there is no specific coding or design approach required to manage concurrency control.

Vaakya supports only fixed length keys and indexes (keys other than primary key). To fill the key to constant length, zero prefix is used for numeric data types.

We do not recommend using String (char) data type for primary key. However, char data types can be used in indexes for searching provided they are of fixed length.

No. Default values can be assigned to fields only in a “Form” component or in a “Trigger.” This approach is adopted so that the storage and validation aspects are separated and handled by different components.