Data Reinitialized When Filtered Column Changes

Hello,
We have SQL2005 Server, SQL Mobile 2005 CF2.0 application. It seems that
when we mark Orders as complete on the server, it redownloads all
OrderDetails from the server down to the PDA, even though there are no
changes to this table on the server, and there are changes on the PDA that
should get uploaded.
We have 2 tables Orders and OrderDetails. We want only non-complete Orders
and their OrderDetails to filter down to the pda.
So we have a base filter setup on our Orders table like this:
SELECT <published_columns> FROM
[dbo].[Orders] WHERE [Orders].[Completed] = 0 AND
[Orders].[OwnerContactID]=HOST_NAME()
Then we add a join filter to get OrderDetails for those Orders:
SELECT <published_columns> FROM [dbo].[Orders] INNER JOIN
[dbo].[OrderDetails] ON [Orders].[OrderID] = [OrderDetails].[OrderID]
Everthing works great most of the time, the problem is, when someone on the
server marks an Order as Complete, but there are still changes to
OrderDetails on the PDA, it generates conflict on OrderDetails. It does try
to upload from the PDA for OrderDetails, but they are filtered into a
conflict table, and the server wins. The OrderDetails table has not been
touched on the server, so I don't understand this. It's like the server
"sets" all the columns in OrderDetails when Orders.Completed is changed to
TRUE, and then the changes from the PDA are regarded as a conflict.
I don't think I understand how this works, and there probably is a reason is
for this. Any help or suggestions of a better way to do this, filter
Non-Complete items down without reinitializing the child data when that
filtered data changes, please let me know!
Thanks!
Are you using column level tracking? It seems that with column level
tracking this should work.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"nkleinjan" <nkleinjan@.discussions.microsoft.com> wrote in message
news:07D5DD6F-F0DF-4B4F-B1FB-C7CC3DE4F7D3@.microsoft.com...
> Hello,
> We have SQL2005 Server, SQL Mobile 2005 CF2.0 application. It seems that
> when we mark Orders as complete on the server, it redownloads all
> OrderDetails from the server down to the PDA, even though there are no
> changes to this table on the server, and there are changes on the PDA that
> should get uploaded.
> We have 2 tables Orders and OrderDetails. We want only non-complete Orders
> and their OrderDetails to filter down to the pda.
> So we have a base filter setup on our Orders table like this:
> SELECT <published_columns> FROM
> [dbo].[Orders] WHERE [Orders].[Completed] = 0 AND
> [Orders].[OwnerContactID]=HOST_NAME()
> Then we add a join filter to get OrderDetails for those Orders:
> SELECT <published_columns> FROM [dbo].[Orders] INNER JOIN
> [dbo].[OrderDetails] ON [Orders].[OrderID] = [OrderDetails].[OrderID]
> Everthing works great most of the time, the problem is, when someone on
> the
> server marks an Order as Complete, but there are still changes to
> OrderDetails on the PDA, it generates conflict on OrderDetails. It does
> try
> to upload from the PDA for OrderDetails, but they are filtered into a
> conflict table, and the server wins. The OrderDetails table has not been
> touched on the server, so I don't understand this. It's like the server
> "sets" all the columns in OrderDetails when Orders.Completed is changed to
> TRUE, and then the changes from the PDA are regarded as a conflict.
> I don't think I understand how this works, and there probably is a reason
> is
> for this. Any help or suggestions of a better way to do this, filter
> Non-Complete items down without reinitializing the child data when that
> filtered data changes, please let me know!
> Thanks!
>
>

Data Recovery Book

Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.BizYour page doesn't render at all in Firefox. You might want to check that
out.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.com...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz

data migration - new server uses different collation

Latin1_General_CI_AS on new server
All database created on old server use SQL_Latin1_General_CP1_CI_AS
I understand its can be a complete process to change the default collation
on my new server to SQL_Latin1_General_CP1_CI_AS
Can someone please help me understand what i need to do ?
Thanks for your time
Scott
SQL 2005 standard.i can use this on new DBs to make sure they use correct COLLATION (i.e same
as all user dbs.)
COLLATE SQL_Latin1_General_CP1_CI_AS
BUT my system dbs now use this > Latin1_General_CI_AS on new server.
What problems can i expect in future if these COLLATIONS differ on user /
system dbs ?