Lycia LowCode Features

Lycia LowCode offers:

• Automated database queries processing (Selecting, Filtering, Searching and Sorting of data), possibility to add sql_where and sql_where_static filtering;
• Automated routines of SQL database operations like INSERT, UPDATE, DELETE and others;
• Error messages handling (output to the screen and to the log file);
• Customisation of the program runtime behaviour:
  • Paged (buffered) data retrieval on the client side;
  • Definition of default behaviours on DISPLAY and INPUT statements;
  • Optional dialog box for action confirmation on INSERT, UPDATE and DELETE commands triggered by user actions.
• Data consistency adherence:
  • Validation of data using the database constraints;
  • Management and processing of the Primary Key and Foreign Key relationship;
  • Support of any valid data type for Primary Key and Foreign Key, including SERIAL and UNIQUE constraints;
  • Creation of additional data validation logic in BEFORE and AFTER events;
  • Optimistic and pessimistic table row locking;
  • Prevention of PRIMARY KEY values editing by the user (disabled fields).
• Addition and extension of the program logic by creating and / or overwriting events: you can add any of the built-in events (for example, AFTER and BEFORE blocks of the INPUT control clauses) to your program;
• Built-in and automated user navigation between records (accessing next record, previous record, first and last records);
• Generation of forms from database tables and forms templates;
• Automated ComboBox population;
• Support of Lookup Fields in TextFields and ComboBoxes;
• Support of multi-language translation on different levels, such as: specific translations for particular executing, specific translation for whole application and global translating.

 

See next: Prerequisites for Working With Lycia LowCode