Databases
Table of Contents
The database is a main component of the AI-Framework Model.
Below you find the main concepts of databases within the AI-Framework, followed by a list of articles that describe the details .
Main concepts
- The database can be chosen freely. Presently the AI-Framework works with Firebird (free open source database), MS SQL (Microsoft), Informix (IBM), and SQL Anywhere (SAP). When changing to one of these databases or yet another, no changes are needed in the model itself.
- Database functions, like insert, update, delete, will be executed fully automatically. Making a Save button in the model does the job.
- See also Software dependencies
- For general information about databases, read Working with databases
Note: The database in the AI-Framework has two sides.
There is the model-side. That is where we access data and manipulate it. This will be described in the articles below.
There is also the technical side of the database. This will be described in the chapter Building applications > Working with databases.
Categories and articles in this chapter
Read a description of the categories in this chapter and go to that category, or straight to its main articles. From the main articles can be navigated to all related articles.
| Category | Description | Cat. | Article |
|
Database expressions |
Several database expressions |
||
|
QueryFields |
Different ways to query the database |
||
|
Stored Procedures |
A stored procedure is a piece of software stored in the database, typically written in a database language like SQL. It can be used many times and enhances data manipulation. |
||
|
Stored Procedure statements |
Stored Procedure statements are instructions to manipulate data. |
||
|
CustomDbChanged |
This is a set of custom database functions. |
||
|
Tables |
Within the AI-Framework, a number of distinguished table fields are distinguished. |
Quick acces
Find here all articles in the different chapters.
- Database expressions
- ConstantSetExpression
- DbKeyExpression
- DbKeyConditionExpression
- DbKeyConstantExpression
- AutoIncrement
- LastAutoIncrementValue
- ConvertToDbKeyExpresion
- CurrentDbUserName
- DbKeyBooleanItemAtExpression
- DbKeyEnumItemAtExpression
- DbKeyIntegerItemAtExpression
- DbKeyLongItemAtExpression
- DbKeyStringItemAtExpression
- DbKeyNull
- DbKeyNvlExpression
- DbKeyNull
- DbToday
- QueryFields
- BlobQueryField
- BooleanQueryField
- CommonQueryField
- DateTimeQueryField
- DecimalQueryField
- EnumQueryField
- IntegerQueryField
- KeyQueryField
- LongQueryField
- StringQueryField
- Stored Procedures
- BooleanStoredProcedureCall
- DateTimeStoredProcedureCall
- DecimalStoredProcedureCall
- IntegerStoredProcedureCall
- LongStoredProcedureCall
- StringStoredProcedureCall
- Stored Procedure Statements
- DbDeleteWithParameter
- DbDeleteWithValues
- DbExecuteQuery
- DbInsertWithParameters
- DbInsertWithValues
- DbInsertTempTable
- DbUpdateWithParameters
- CustomDbChanged
- Tables