Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Lesson 1: Create a project architecture

The first procedure describes how to create an UltraLite database.

To create an UltraLite database

1. Create a directory for this tutorial.

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

2. Create a database using UltraLite in Sybase Central.

   See Creating an UltraLite database from Sybase Central.

   • Table name  Customer

   • Columns in Customer  

     Column name	Datatype (size)	Column allows NULL values?	Default value
     ID	integer	No	autoincrement
     FName	varchar(15)	No	None
     LName	varchar(20)	No	None
     City	varchar(20)	Yes	None
     Phone	varchar(12)	Yes	555-1234

     In an application with synchronization, it is usual to choose a global autoincrement or UUID data type for primary keys. An autoincrement method is chosen here to simplify the tutorial.

   • Primary key  Ascending ID

3. Save the database.

   If you are developing an application for Windows or Windows CE, choose File > Save and choose tutcustomer.udb in your tutorial directory as the file name.

Create a Crossfire project