SQL StatementDate fields in SQL statements must be enclosed by "#"-characters,
Example:
#25.06.2001#
The hash character is replaced by date delimiters that are automatically recognised by each database.
eva/3 Application Builder supports subquerys and transcribes them differently, depending on the database. Inner selects or subquerys must be knowable for eva/3 Application Builder.
It is possible to insert other statements inside the project in the statement and they will be completely supported with 'drag and drop' by the visual editor.
Principally they should be signed with §QUERYNAME. The query will be found without this prefix, but if a table with the same name exist in the filesystem, this will be preferred at execution und the result will be sophisticated. By signing with ‚§’ explicitly is defined, that the query will be loaded from the filesystem.
In the query editor, the subquerys only have to be in the 'from' part of the statement. Otherwise you better use DSQL statements, because no database independecy can be guaranteed and maybe this statement can not be executed as query.
Subquerys must be enclosed by ‚§’:
„Select sub.* from contact, §(Select * adress)§ as sub”
Union will be supported as 'query' completely by eva/3 Application Builder, but it will not be represented in the visual editor.