Re: What is Tracked Table: Native Error 28543

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

To PUSH the changes made on the device DB. The table MUST be PULLed with
RDA Tracking enabled.

For more details please have a look at RDATrackOption on MSDN

Thanks,
--
Laxmi NRO, SQL Mobile, Microsoft Design Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.


<pramodrenikindi@xxxxxxxxx> wrote in message
news:1125553814.917213.196410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello syed,
>
> I have one question regarding the same error . i am using merge
> replication for some tables .After doing replication i am creating some
> orders on pocket pc . I want one table like orders tables to sync back
> to sql server using rda.push method but i am getting the same error.
> How can i solve the problem ?
> Yours truly,
>
> Pramod Renikindi,
> creativesoft,australia
>
>
>
> "Syed N. Yousuf [MS]" wrote:
>> From SQL CE 2.0 Books Online:
>>
>> "The application must have created the local SQL Server CE table by
>> calling
>> the Pull method with RDA_TRACKOPTION set to TRACKINGON."
>>
>> "RDA_TRACKOPTION specifies whether SQL Server CE should track changes to
>> the pulled table. You should specify TRACKINGON if you want to update the
>> pulled table on the Windows CE device and then push changed records back
>> to
>> the original SQL Server table. When the TRACKINGON option is specified,
>> SQL
>> Server CE keeps track of every record that is inserted, updated, or
>> deleted
>> in the local table. When the application calls the Push method, SQL
>> Server
>> CE uses the change tracking information to locate the inserted, updated,
>> and deleted records in the local SQL Server CE table and propagate these
>> changes back to SQL Server."
>>
>> Thank you!
>> Syed N. Yousuf
>> Microsoft Developer Support Professional
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>


.

Relevant Pages

  • Re: RDA Pull() and Push() methods
    ... --You cannot Push the data back without having the Primary Key. ... roolback in sql server will happen or not ... with tracking off? ... --If you use Transactional RDA, the Push will be rolled back. ...
    (microsoft.public.sqlserver.ce)
  • Re: RDA Pull() and Push() methods
    ... i am developing an application which uses pull method to get values for the tables. ... Whether i will be able to push the data back to me sql server with tracking off. ...
    (microsoft.public.sqlserver.ce)
  • Re: What is Tracked Table: Native Error 28543
    ... Do PUSH back the changes to SQL Server, the table MUST be PULLed to device ... Otherwise, PUSH fails. ... >> CE uses the change tracking information to locate the inserted, updated, ... >> and deleted records in the local SQL Server CE table and propagate these ...
    (microsoft.public.sqlserver.ce)
  • RE: Stupid Manager Question
    ... > tracking, product and price databases. ... > outside sales force that contains a little bit of all of them. ... We are also looking at putting SQL Server on our Web ... > Server for customizable reporting. ...
    (microsoft.public.dotnet.general)
  • RE: Diverse Synchronisation
    ... | Content-Type: text/plain; ... non SQL server and maybe even non Database data sources. ... We need some means of tracking changes to the SQL CE Database but will not ... Does anyone have any ideas as to how to structurally track changes within ...
    (microsoft.public.sqlserver.ce)