App That Uses Both An SQLite And MySql Database

I am writing an app that uses both an SQLite and MySql database. The reason for this before you ask is that it means I can store a local copy of the data onto my user' own machines when they are offline, and then update them to a central server when they are next online.

The problem I have is that when using datasets (on tables created in identical fashion) the itemarray of the mysql database has 9 extra totally blank fields...where as the SQLite itemarray has only the values for the items.

here is a snippet of the code:

CODE:

ultimately I am getting an index size mismatch error but with both tables having the same number of fields this is confusing.