SQL Anywhere Mobile - ASA9: Update problems

Author

ASA9: Update problems

Rodrigo Defavari

2005-10-27, 8:21 am

Good Afternoon,

I am working with ASA9 synchronizing with Oracle. It would like to know as
to make when I to make a Update in my remote bank (palm), to make the same
alteration in my Oracle.

Detail: The two DBs has in the table that desire to synchronize the same
names and attributes for the columns.

Thanks.

Rodrigo Defavari
Desenvolvedor
AKB IT Solutions Ltda. - Tel: 19 3466-9672
rodrigo.defavari@akbit.com

Evite imprimir ! Pense em sua responsabilidade e compromisso com o MEIO
AMBIENTE.

Breck Carter [TeamSybase]

2005-10-27, 8:21 am

You have to make sure that table is being synchronized from the Palm
side (it probably is, by default), and then you have to write an
upload_update script for that table and store it in the Oracle
database.

On 21 Oct 2005 12:04:07 -0700, "Rodrigo Defavari"
<rodrigo.defavari@akbit.com> wrote:

>Good Afternoon,
>
>I am working with ASA9 synchronizing with Oracle. It would like to know as
>to make when I to make a Update in my remote bank (palm), to make the same
>alteration in my Oracle.
>
>Detail: The two DBs has in the table that desire to synchronize the same
>names and attributes for the columns.
>
>Thanks.
>
>
>Rodrigo Defavari
>Desenvolvedor
>AKB IT Solutions Ltda. - Tel: 19 3466-9672
>rodrigo.defavari@akbit.com
>
>Evite imprimir ! Pense em sua responsabilidade e compromisso com o MEIO
>AMBIENTE.
>

--
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

David Fishburn

2005-10-27, 8:21 am

"Rodrigo Defavari" <rodrigo.defavari@akbit.com> wrote in
news:43593ba7$1@foru
ms-1-dub of sybase.public.sqlanywhere.mobilink:

RD> I am working with ASA9 synchronizing with Oracle. It would like to
RD> know as to make when I to make a Update in my remote bank (palm), to
RD> make the same alteration in my Oracle.
RD>
RD> Detail: The two DBs has in the table that desire to synchronize the
RD> same names and attributes for the columns.

Sounds like you need to begin with one of the tutorials.
Since you are using the Palm platform, this means you are using an
UltraLite database.

Depending on which UL API you choose to program with, you should follow
a tutorial for it.

From the 902 Help file:

UltraLite Database User's Guide
Tutorial: Working with UltraLite Databases

-------------------------------------------------------------------------
-------

About this chapter
This chapter walks you through several tasks related to UltraLite
database schemas and database files. It introduces the UltraLite Schema
Painter, the UltraLite Interactive SQL utility, and the UltraLite
command-line administration tools. It also shows how you can generate
and synchronize with an Adaptive Server Anywhere consolidated database
from an UltraLite database.

-------------------------------------------------------------------------
-------

Lesson 1: Create an UltraLite database schema
Lesson 2: Define and create a consolidated database
Lesson 3: Enter data in your UltraLite database
Lesson 4: Synchronize your databases

If you are only just now starting with this project please ensure you
begin with the SQL Anywhere 9.0.2 release. Then you should also get the
current 902 EBF. Both of these are available (for free) from:
http://downloads.sybase.com/swx/sdmain.stm

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links