Building the CustDB sample application

Choosing how to link the runtime library

UltraLite Embedded SQL User's Guide
Developing UltraLite Applications for Windows CE

Building the CustDB sample application

CustDB is a simple sales-status application. It is located in the UltraLite samples directory of your Adaptive Server Anywhere installation. Generic files are located in the CustDB directory. Files specific to Windows CE are located in the ce subdirectory of CustDB.

The CustDB application is provided as an eMbedded Visual C++ 3.0 project.

For a diagram of the sample database schema, see The UltraLite sample database.

To build the CustDB sample application

Start eMbedded Visual C++.
Open the project file that corresponds to your version of eMbedded Visual C++:
- Samples\UltraLite\CustDB\EVC\EVCCustDB.vcp for eVC 3.0.
- Samples\UltraLite\CustDB\EVC40\EVCCustDB.vcp for eVC 4.0.
Choose Build > Set Active Platform to set the target platform.
- Set a platform of your choice.
Choose Build->Set Active Configuration to select the configuration.
- Set an active configuration of your choice.
If you are building CustDB for the Pocket PC x86em emulator platform only:
- Choose Project > Settings. The Project Settings dialog appears.
- On the Link tab, in the Object/library modules box, change the UltraLite runtime library entry to the emulator30 directory rather than the emulator directory.
Build the application:
- Press F7 or select Build > Build EVCCustDB.exe to build CustDB.
  
  When eMbedded Visual C++ has finished building the application, it automatically attempts to upload it to the remote device.
Start the synchronization server:
- To start the MobiLink synchronization server, select Programs > Sybase SQL Anywhere 9 > MobiLink > Synchronization Server Sample.
Run the CustDB application:

Press Ctrl+F5 or select Build > Execute CustDB.exe

Folder locations and environment variables

The sample project uses environment variables wherever possible. It may be necessary to adjust the project in order for the application to build properly. If you experience problems, try searching for missing files in the MS VC++ folder and adding the appropriate directory settings.

The build process uses the SQL preprocessor, sqlpp, to preprocess the file CustDB.sqc into the file CustDB.c. This one-step process is useful in smaller UltraLite applications where all the embedded SQL can be confined to one source module. In larger UltraLite applications, you need to use multiple sqlpp invocations followed by one ulgen command to create the customized remote database.

For more information, see Pre-processing your embedded SQL files.