SQLite database - UNIT4 Agresso

bawltherapistΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 6 μήνες)

172 εμφανίσεις

SQLite database
Create and use a file based SQLite database (Recorded in WebInfo 3.7 prerelease)
This guide shows how to setup a file based SQLite database from within WebInfo. The
database then works much like an SQL Server or Oracle database but without the more
advanced features (no TSQL or PL/SQL etc). It is also possible to create an in memory
SQLite database which can be used as a temporary storage for the current session or as
a global cache.
1.
Create a new SQLite database.
2.
Create a new database table
called tab1.
SQLite database
1
3.
Add a couple of rows to tab1
table.
4.
Use the new database table as a
datasource for the WebInfo table
object,
5.
This SQLite database is stored
under the WebInfo installation
directory.
SQLite database
2