UltraLite User's Guide
Tutorial: Build an Application Using Embedded SQL
Building the sample embedded SQL UltraLite application
Once you have tested that your program is functioning properly, you can remove the lines of code that manually insert data into the ULProduct table. Replace these statements with a call to the ULSynchronize function to synchronize the remote database with the consolidated database. This process will fill the tables with data and you can subsequently execute a select query.
Synchronization via TCP/IP
Running the sample application with synchronization