Introduction

UltraLite for MobileVB 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 for MobileVB 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 MobileVB and Microsoft Visual Basic 6 installed on your computer
you are familiar with AppForge MobileVB and Microsoft Visual Basic 6
- you can write, test, and troubleshoot a MobileVB application
- you can add references and components as needed
you know how to create an UltraLite schema using the UltraLite Schema Painter.

Note

You can perform most of this tutorial without SQL Anywhere Studio. The synchronization sections of the tutorial require SQL Anywhere Studio.

To develop applications using the UltraLite for AppForge MobileVB component, you will need the AppForge Booster. If you are missing Booster, you can get it from http://www.appforge.com/booster.html.

Goals

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