push table only on handheld database

I'm able to pull down all my tables needed, but I need to push a table from my handheld database that was not pulled. Is this possible?

The table is used to save data on some input screen on my handheld application and I need to push it to a 'staging' table on my main sql server before it is inserted into the correct tables.

Is there a way to do this?

Why not use RDA.SubmitSQL("INSERT INTO xxx ....) ?|||

SubmitSQL("insert xxx") will work?

So the insert statement will be the insertion of the table on my main SQL Server? I've been under the impression that you can't push a table unless you pull it first? Is that not true?

So here is what I have.

on my handeld database

table1 - pulled

table2 - not pulled

main SQL Server database

table1

table2 - 'staged table'

since table2 wasn't not pulled and is used as a data collection table on the handheld, I can do SubmitSQL("insert into table2 (xxx)") and that will work?

|||Yes, SubmitSQL simply executes SQL statements on the database server, any you can code whatever SQL statements you like.