Home > Archive > SQL Anywhere Mobile > November 2005 > Mobilink / PocketBuilder Question -- Remote Database









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 Mobilink / PocketBuilder Question -- Remote Database
Tom Rolseth

2005-11-04, 11:44 am

I was going through the PocketBuilder tutorial and more specifically, was
reading through the sql that creates the remote database. If the
consolidated database has a table with 100 columns, does the remote version
of it need to have all 100? Or does the remote table you want to work with
simply need the primary key and the columns that you want to update?

Thanks, Tom


Liam Cavanagh

2005-11-04, 11:44 am

Yes, if you are using MobiLink you can choose as many or as few columns as
you like (as long as the Primary Key exists in the remote table).

--
Liam Cavanagh
Sr. Product Manager
Certified ASA Developer Version 8
iAnywhere
"Tom Rolseth" <tpr@npomn.com> wrote in message news:436b7c7c@forums
-1-dub...
>I was going through the PocketBuilder tutorial and more specifically, was
> reading through the sql that creates the remote database. If the
> consolidated database has a table with 100 columns, does the remote
> version
> of it need to have all 100? Or does the remote table you want to work
> with
> simply need the primary key and the columns that you want to update?
>
> Thanks, Tom
>
>



David Fishburn

2005-11-04, 11:44 am

"Liam Cavanagh" < cavanagh@NOSPAM_iany
where.com> wrote in
news:436b805b@forums
-1-dub of sybase.public.sqlanywhere.mobilink:

LC> Yes, if you are using MobiLink you can choose as many or as few
LC> columns as you like (as long as the Primary Key exists in the remote
LC> table).

create publication pub1 (
table t1 (pk1, pk2, col6, col7)
);

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





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com