UltraLite Embedded SQL User's Guide
Tutorial: Build an Application Using Embedded SQL
Once you have tested that your program is functioning properly, you can replace the code that manually insert data into the ULProduct table with instructions to synchronize the remote database with the consolidated database. Synchronization will fill the tables with data and you can subsequently execute a select query.
Synchronization via TCP/IP
Running the sample application with synchronization