SQL IDE

SQL Integrated Development Environment

FADAcore allows you to develop an application:

  • using SQL for data management;
  • using an advanced scripting language;
  • using a graphical editor for forms.

Schema design

FADAcore allows you to create a complete database that includes:

  • primary keys, foreign keys, and the appropriate data types;
  • triggers;
  • views, which can be dynamic thanks to triggers.
Schema menu

Queries and query fragments can be tested directly from the editor.

Query test

The database is recreated with data restoration.

Advanced SQL/script editor

Syntax highlighting

Coloration syntaxique

Auto-complete

Auto-complétion

Link to definition

Clic sur un nom de table ou vue

 

 

Définition de la table ou vue

Search / Replace in all code

Search SQL database definition files, scripts, FADA property definition tables, and external resource files.

Recherche dans le code

WYSIWYG form design

An automatically generated, customizable form for viewing and editing data.

Conception de formulaire