Atteya

For the definition of a new dynamic genome it is necessary to enter a “Denomination” and a “Description”.
The genome is transferred to the correction mode upon clicking the “Enter” key. It is possible to enter tables and links here, see fig. No. 5.


The key “Correct” enters new features.
SQL Intelligent assigns newly defined features to the original SQL query and executes a check whether it is in order. In our case the check was performed without a problem, see fig. No. 6. It is necessary to adhere to bracket conventions when creating embedded selects. It can happen that the query is not correct in the case of higher number of mutually linked genomes. In such case it would not be a critical problem.


In our example we add a table of Inventories and values of quantities inventories. Further we define the first and the last transaction per an item.


By this we have prepared new features, which can be used in the “Dynamic Field Definition” function.