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

Lesson 1: Create a project architecture

The first step is to create an UltraLite for MobileVB project for your application. You can use a MobileVB project to get MobileVB controls that are suitable for small devices. On the Visual Basic toolbar on the left of the Visual Basic environment, MobileVB tools appear in addition to the standard Visual Basic tools.

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\mvb. If you create a directory with a different name, use that directory instead of c:\tutorial\mvb 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

To create an UltraLite for MobileVB reference

1. Start MobileVB.

   Click Start > Programs > AppForge MobileVB > Start MobileVB.

   The Project Manager appears.

2. Click New Project.

3. Choose a target and click OK.

4. Name the Project.

   • Click Project > MobileVBProject1 Properties

   • Under Project name, type UltraLiteTutorial. This is the name of the application as it will appear on your device.

   • Click OK.

5. Save the Project:

   • Choose File > Save Project.

   • Save the form as c:\tutorial\mvb\Form1.frm.

   • Save the Project as c:\tutorial\mvb\UltraLiteTutorial.vbp.