|
Home > Archive > SQL Anywhere database > October 2005 > Publishing in Mobilink
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Publishing in Mobilink
|
|
| Fantom 2005-10-27, 7:41 am |
| I have question about publishing table in mobilink.
When i have table x (id, name) :
1, a
2,b
3,c
and id published it with clausule WHERE ID=1, then :
1) When i change 2,b to 2,bb this is send to consolidate database ?
2) When consolidate datanbase download to me rows 4,d - this is insert into
my database ?
3) when consolidate database send me changed record 1,a to 1,aa is my
databse updatet this record ?
Fantom
ps. Sorry but my english is very poor
| |
| Breck Carter [TeamSybase] 2005-10-27, 7:41 am |
| On 27 Oct 2005 01:11:45 -0700, "Fantom"
<szczukot@skasujto.poczta.onet.pl> wrote:
>I have question about publishing table in mobilink.
>When i have table x (id, name) :
>1, a
>2,b
>3,c
>and id published it with clausule WHERE ID=1, then :
>1) When i change 2,b to 2,bb this is send to consolidate database ?
No, if you change a row on the remote database where id <> 1, that row
will not be uploaded because of the WHERE ID=1 clause in the
publication. That is the ONLY TIME that WHERE clause will affect you.
>2) When consolidate datanbase download to me rows 4,d - this is insert into
>my database ?
It depends on how you code your download_cursor script for that table.
>3) when consolidate database send me changed record 1,a to 1,aa is my
>databse updatet this record ?
Yes. The publication WHERE clause only affects the upload; it is only
part of the story. See this section in the Help:
MobiLink Clients
Adaptive Server Anywhere Clients
Creating a remote database
Partitioning data between remote databases
>
>Fantom
>ps. Sorry but my english is very poor
Don't worry about it! Your English is much better than my Polish!
Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Greg Fenton 2005-10-27, 9:23 am |
| Fantom wrote:
> I have question about publishing table in mobilink.
Breck has already provided you with the right answers, but I just wanted
to let you know that there is a MobiLink-specific newsgroup:
sybase.public.sqlanywhere.mobilink
That newsgroup is a better place for posting questions about MobiLink
and synchronization in general.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Fantom 2005-10-27, 9:23 am |
| > >2) When consolidate datanbase download to me rows 4,d - this is insert
into
>
> It depends on how you code your download_cursor script for that table.
Ok. Thats mean :
- clausule WHERE in remote database is only for UPLOAD_xxxx (insert, delete
and update)
- whats is download from consolidate to remote is only know download_cursor,
and WHERE in remote is not important when download_cursor send data
?
Fantom
|
|
|
|
|