This MobiLink client integration component sample provides sample code for the graphical version of the component.  It provides code for creating upload and message events which your application can expose to the end user.  There are comments in the code supplementing this readme.  The sample requires Version 9.0.1 Visual Studio.NET 2003 and it is recommended that you obtain 9.0.1 EBF 1760 of higher.

 

How To Use Sample

 

  1. Run the build.bat via command line or double click the build.bat from explorer.
    1. This build require application, databases and datasources this will take a couple of minutes.
  2. Once 1. is complete you should be looking at an application with five buttons.
    1. Press Button 1 Start MobiLink this will take a second or two.  Ensure no other MobiLink servers are running.
    2. Press Button 2. Initial Download to populate the remote database and generate synchronization scripts.  Again this will takes a few seconds..
    3. Press Button 3. Insert into DB.  This inserts a row into the department table with contents of the textbox above.  There is an event in the application that will populate the list box with the upload information in the next step.
    4. Press Button 3. Sync After Insert which actually calls the same code in step b but is included here to assist you with the order of operations.  You can validate that there is now             four additional entries in the text box which means the event was fired and is working.
    5. Be sure to stop the MobiLink server by pressing Button 5. Stop MobiLink and exit the application.
  3. Once complete you can either clean up what you have created by running the clean.bat file via command line or double click or review the code by double clicking on Review Code.

 

Remote database has the following definition applied to the asademo sample database.

 

        '--See rem.sql included with the sample

        'ALTER TABLE "DBA"."department" ALTER "dept_id" SET DEFAULT autoincrement

        ' go

        ' create publication FullSync(

        '  table DBA.contact,

        '  table DBA.customer,

        '  table DBA.department,

        '  table DBA.employee,

        '  table DBA.fin_code,

        '  table DBA.fin_data,

        '  table DBA.product,

        '  table DBA.sales_order,

        '  table DBA.sales_order_items

        ')

        'go

        '

        ' --Create synchronization user and subscription

        '

        '  create synchronization user remoteuser

        '  go

        '  create synchronization subscription to FullSync for remoteuser

        '  go

Enjoy.