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.

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.sql

push error - urgent

I'm able to pull the metatdata down from my sql server to my handheld for table, I can then add data to that table on the handheld, when I try to push it back to Sql Server table I pulled from, I'm getting the following error message:

The Push method returned one or more error rows. See the specified error table. [ Error table name = ErrorTable ]

what does this mean, and how can I push my table back to the table I pulled from? I have trackingOn set on the pull process.

I'm getting the same error. Can anyone help?|||

When the SqlCeRemoteDataAccess.Push method encounters a problem it puts an error message in a database table. In your case the table is called "ErrorTable." (You can specify a different table name in the Pull method if you care to.)

Use Query Analyzer on the device to look at this table. The problem will probably be obvious when you see the full error message. If not, post the error message(s) in the forum.

Query Analyzer is supposed to be installed on the device automatically by Visual Studio when you do a debug build, but it isn't always. If you don't have it already, you can install it manually as described here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=314754&SiteID=1

The most common reasons for a push error are primary and foreign key constraint violations.

sql

push error - urgent

I'm able to pull the metatdata down from my sql server to my handheld for table, I can then add data to that table on the handheld, when I try to push it back to Sql Server table I pulled from, I'm getting the following error message:

The Push method returned one or more error rows. See the specified error table. [ Error table name = ErrorTable ]

what does this mean, and how can I push my table back to the table I pulled from? I have trackingOn set on the pull process.

I'm getting the same error. Can anyone help?|||

When the SqlCeRemoteDataAccess.Push method encounters a problem it puts an error message in a database table. In your case the table is called "ErrorTable." (You can specify a different table name in the Pull method if you care to.)

Use Query Analyzer on the device to look at this table. The problem will probably be obvious when you see the full error message. If not, post the error message(s) in the forum.

Query Analyzer is supposed to be installed on the device automatically by Visual Studio when you do a debug build, but it isn't always. If you don't have it already, you can install it manually as described here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=314754&SiteID=1

The most common reasons for a push error are primary and foreign key constraint violations.