When a table is created in the database via Tersus, a primary key is automatically created.
The primary key includes all fields which have the property primaryKey set to true (when adding a data element to a Database Record structure, the property is set to false).If none of the fields have the property set to true, the first field in the structure will be used (even though its setting remains false).
Once a database table has been created, the primary key cannot be changed - changing the primaryKey property for a given field will have no effect.
To create additional indexes use the administration tools provided by the database you're using. If you're using the embedded database (which is an HSQDB database maintained in the database subfolder of the project), look for further details in the HSQL documentation pages (http://hsqldb.org/web/hsqlDocsFrame.html).
Regards,
David
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign
