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

Introduction

This tutorial guides you through the process of building an UltraLite ActiveX application using dynamic SQL for data access. At the end of the tutorial you will have an application and a small database on your Windows CE device that synchronizes with a central database.

Timing 

The tutorial takes about 30 minutes if you copy and paste the code. If you enter the code yourself, it takes significantly longer.

Competencies and experience 

This tutorial assumes:

• you have Microsoft eMbedded Visual Tools installed on your computer

• you can program Microsoft eMbedded Visual Basic 3.0

  • you can write, test, and troubleshoot an eMbedded Visual Basic application

  • you can add references and components as needed

• you know how to create an UltraLite schema using the UltraLite Schema Painter.

Goals 

The goals for the tutorial are to gain competence and familiarity with the process of developing an UltraLite application using dynamic SQL.