dbTalk Databases Forums  

to synchronize in 2 parts the information

sybase.public.sqlanywhere.mobilink sybase.public.sqlanywhere.mobilink


Discuss to synchronize in 2 parts the information in the sybase.public.sqlanywhere.mobilink forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Luis Ponce Ibarra - Hotmail
 
Posts: n/a

Default to synchronize in 2 parts the information - 07-18-2006 , 08:07 PM






I am synchronize with asa 9.0.2.3320 and code warrior 8.1 for palm os
in the palm has ten tables and I have defined at the mobilink database
consolidated 2 versions.
The first sinchronize all tables and the second sinchronize only 3 tables.
my question is I won't have problem whenever to make the following thing

Usually in a transaction in the palm is saved in the 10 tables information
but I want to transmit via GPRS alone information of 3 tables that they are
necessary but the information of 7 tables was sinchronized when the user
returns with the palm. The 7 tables are not needed to sinchronize via gprs

this one can make and as I make it

Thanks you





Reply With Quote
  #2  
Old   
Greg Fenton
 
Posts: n/a

Default Re: to synchronize in 2 parts the information - 07-18-2006 , 08:28 PM






Luis Ponce Ibarra - Hotmail wrote:
Quote:
my question is I won't have problem whenever to make the following thing

Usually in a transaction in the palm is saved in the 10 tables information
but I want to transmit via GPRS alone information of 3 tables that they are
necessary but the information of 7 tables was sinchronized when the user
returns with the palm. The 7 tables are not needed to sinchronize via gprs
I don't foresee any problems with what you have outlined.

But just so that you are aware, there is no need to use two different
ScriptVersions in your consolidated. You are using two separate
publications (3 tables in one, 7 tables in the other), and those two
publications can use the same ScriptVersion (unless you specifically
have separate logic in the connection_level scripts).

g.f
--
Greg Fenton
Some Random Dude


Reply With Quote
  #3  
Old   
Luis Ponce Ibarra - Hotmail
 
Posts: n/a

Default Re: to synchronize in 2 parts the information - 07-18-2006 , 08:53 PM



in asa 7 the upload sent all registers that had modified in the palm and if
it was not defined their event in the scriptversion didn't save in the
database consolidated I thought that in asa 9 worked equally.
you can indicate me where I can see information or example to need them.


"Greg Fenton" <greg.fenton_nospam_ (AT) googles-mail-site (DOT) com> escribió en el
mensaje news:44bd8ab5$1 (AT) forums-1-dub (DOT) ..
Quote:
Luis Ponce Ibarra - Hotmail wrote:
my question is I won't have problem whenever to make the following thing

Usually in a transaction in the palm is saved in the 10 tables
information
but I want to transmit via GPRS alone information of 3 tables that they
are
necessary but the information of 7 tables was sinchronized when the user
returns with the palm. The 7 tables are not needed to sinchronize via
gprs

I don't foresee any problems with what you have outlined.

But just so that you are aware, there is no need to use two different
ScriptVersions in your consolidated. You are using two separate
publications (3 tables in one, 7 tables in the other), and those two
publications can use the same ScriptVersion (unless you specifically
have separate logic in the connection_level scripts).

g.f
--
Greg Fenton
Some Random Dude



Reply With Quote
  #4  
Old   
Usmanov A.
 
Posts: n/a

Default Re: to synchronize in 2 parts the information - 07-19-2006 , 05:47 AM



It is easy:
ul_synch_info info;
m_conn.InitSynchInfo( &info );
info.user_name = pszUser;
info.password = pszPwd;
info.stream = ULSocketStream();
info.stream_parms = pszStreamParms;
info.version = SCRIPT_VERSION;
info.upload_only = false;
info.observer = observer;
info.user_data = &sqlca;
info.send_download_ack = ul_true;
info.publication=UL_PUB_PUB1;//<-- This is first part of tables
m_conn.Synchronize( &info );
res&=m_conn.LastCodeOK();
if (res&&bNeed2){
info.publication=UL_PUB_PUB2; ////<-- This is second part of tables
m_conn.Synchronize( &info );
res=m_conn.LastCodeOK();
}

There is one caution. If you have tblChilds referenced to tblParents you
may lost new records from tblChild after sync if tblChilds will synced
before tblParents. Therefore you must insert both tables in the same
publication or tblParents must be synced before tblChilds.



--
Sincerely yours,
Alex Usmanov
(ASA 9.0.2.3131, MW CW 9.2)
"Luis Ponce Ibarra - Hotmail" <luisponceibarra (AT) hotmail (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ
× ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:44bd8ee8 (AT) forums-2-dub (DOT) ..
Quote:
in asa 7 the upload sent all registers that had modified in the palm and
if
it was not defined their event in the scriptversion didn't save in the
database consolidated I thought that in asa 9 worked equally.
you can indicate me where I can see information or example to need them.


"Greg Fenton" <greg.fenton_nospam_ (AT) googles-mail-site (DOT) com> escribió en el
mensaje news:44bd8ab5$1 (AT) forums-1-dub (DOT) ..
Luis Ponce Ibarra - Hotmail wrote:
my question is I won't have problem whenever to make the following
thing

Usually in a transaction in the palm is saved in the 10 tables
information
but I want to transmit via GPRS alone information of 3 tables that
they
are
necessary but the information of 7 tables was sinchronized when the
user
returns with the palm. The 7 tables are not needed to sinchronize via
gprs

I don't foresee any problems with what you have outlined.

But just so that you are aware, there is no need to use two different
ScriptVersions in your consolidated. You are using two separate
publications (3 tables in one, 7 tables in the other), and those two
publications can use the same ScriptVersion (unless you specifically
have separate logic in the connection_level scripts).

g.f
--
Greg Fenton
Some Random Dude





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.