UltraLite ActiveX User's Guide
  Tutorial: Using Dynamic SQL in an UltraLite Application for PocketPC

Lesson 1: Create a project architecture

The following procedure creates 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

1. Create a directory to hold the files you create in this tutorial.

   This tutorial assumes the directory is c:\tutorial\evb. If you create a directory with a different name, use that directory instead of c:\tutorial\evb throughout the tutorial.

2. Create a database schema using the UltraLite Schema Painter.

   For more information about creating a database schema using the UltraLite Schema Painter, see the UltraLite Schema Painter Tutorial.

   • Schema filename    tutorial.usm

   • Table name    names

   • Columns in names    

     Column name	Data type (size)	Allow NULL?	Default value
     id	integer	No	autoincrement
     name	char(15)	No	None

   • Primary key    ascending id

Create an eMbedded Visual Basic project