UltraLite for MobileVB User's Guide
Tutorial: An UltraLite Application for PocketPC
The first procedure describes how to create an UltraLite database schema. The database schema is a description of the database. It describes the tables, indexes, keys, and publications within the database, and all the relationships between them.
For more information about database schemas, see Creating UltraLite database schema files.
To create an UltraLite database schema
Create a directory for this tutorial.
This tutorial assumes the directory is c:\tutorial\mvb. If you create a directory with a different name, use that directory instead of c:\tutorial\mvb throughout the tutorial.
Create a database schema using the UltraLite Schema Painter.
Schema filename tutcustomer.usm
Table name customer
Columns in customer
Column Name | Data Type (Size) | Column allows NULL values? | Default value |
---|---|---|---|
id | integer | No | autoincrement |
fname | char(15) | No | None |
lname | char(20) | No | None |
city | char(20) | Yes | None |
phone | char(12) | Yes | 555-1234 |
Primary key ascending id
For more information about creating a database schema, see the UltraLite Schema Painter Tutorial.