Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rauken
Posting Yak Master
108 Posts |
 Posted - 2007-11-20 : 17:52:03
|
| I've setup RDA (Sql Server 2005) for my WM5 device and it works great to pull a simple table, even with a simple where clause.I tried to join to tables to limit the number of records but I'm getting an error saying something about cannot track because of multitable query. So is it only possible to pull simple tables with RDA. If it is, is there a workaround?Jesus saves. But Gretzky slaps in the rebound. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-20 : 18:52:58
|
| What is RDA? What is the query you are trying? What is the error?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Rauken
Posting Yak Master
108 Posts |
Posted - 2007-11-21 : 03:22:45
|
| RDA is Remote Data Access a synchronization method for Sql Server Compact Edition together with Sql Server. With Sql Server Merge which is a more sophisticated sync method I can apply filter with joins to narrow down number of records I want to pull to my device. With RDA I don't need to configure the Sql Server on the backend, I just write code (.net compact framework) to pull the data I want and push back the changes.Jesus saves. But Gretzky slaps in the rebound. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-21 : 03:26:57
|
quote:
So is it only possible to pull simple tables with RDA.
No. You can pull any query with TRACKING_OFF. If you use TRACKING_ON, it only works on single table.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
RDA filter with join?