Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Schema

5 posts in General Discussion Last posting was on 2003-06-18 20:53:51.0Z
Oscar_Verdeja Posted on 2003-06-17 20:10:18.0Z
From: Oscar_Verdeja
Date: Tue, 17 Jun 2003 16:10:18 -0400
Newsgroups: ianywhere.public.general
Subject: Schema
Message-ID: <C14C89671D2F491A006ECE5C85256D48.006ECE7585256D48@webforums>
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1211
Article PK: 3453

I have know my MS SQL Server ODBC running in my Sybase Central, I have some
tables already created, how do I create my db files in order to have my
database in my handheld, so I can create my application?

I have read the PDF Files, but it says that I need to execute the SQL
statements in order to create the database, in this case I already have it,
so what's the next step?


Robert Waywell Posted on 2003-06-18 13:13:36.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <C14C89671D2F491A006ECE5C85256D48.006ECE7585256D48@webforums>
Subject: Re: Schema
Date: Wed, 18 Jun 2003 09:13:36 -0400
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <O0rU3xZNDHA.364@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1212
Article PK: 3456

Which deployment option are you planning on using on the handheld? The ASA
for CE, UltraLite, or the UltraLite Component suite?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Oscar_Verdeja> wrote in message
news:C14C89671D2F491A006ECE5C85256D48.006ECE7585256D48@webforums...
> I have know my MS SQL Server ODBC running in my Sybase Central, I have
some
> tables already created, how do I create my db files in order to have my
> database in my handheld, so I can create my application?
>
> I have read the PDF Files, but it says that I need to execute the SQL
> statements in order to create the database, in this case I already have
it,
> so what's the next step?


Oscar_Verdeja Posted on 2003-06-18 18:57:10.0Z
From: Oscar_Verdeja
Date: Wed, 18 Jun 2003 14:57:10 -0400
Newsgroups: ianywhere.public.general
Subject: Re: Schema
Message-ID: <E17399CA0F6901E800681C8085256D49.005026DD85256D49@webforums>
References: <C14C89671D2F491A006ECE5C85256D48.006ECE7585256D48@webforums> <O0rU3xZNDHA.364@forums-2-dub>
Lines: 3
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1213
Article PK: 3457

UltraLite...

What is the difference between UltraLite and Ultralite Component Suite?


Oscar_Verdeja Posted on 2003-06-18 18:59:44.0Z
From: Oscar_Verdeja
Date: Wed, 18 Jun 2003 14:59:44 -0400
Newsgroups: ianywhere.public.general
Subject: Re: Schema
Message-ID: <400C6B70ECA25ADD0068587D85256D49.005026DD85256D49@webforums>
References: <C14C89671D2F491A006ECE5C85256D48.006ECE7585256D48@webforums> <O0rU3xZNDHA.364@forums-2-dub>
Lines: 3
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1214
Article PK: 3458

Sorry, UltraLite Component Suite...

Im going to developt the solution using Appforge, for PocketPC


Shuchit Velkar Posted on 2003-06-18 20:53:51.0Z
Subject: Re: Schema
From: Shuchit Velkar <xxx@xxx.net>
References: <C14C89671D2F491A006ECE5C85256D48.006ECE7585256D48@webforums>
Message-ID: <Xns939EAAA2C32A0svelkarNOsybaseSPAMc@10.22.241.106>
User-Agent: Xnews/5.04.25
Newsgroups: ianywhere.public.general
Date: Wed, 18 Jun 2003 13:53:51 -0700
NNTP-Posting-Host: 172.31.140.214
Lines: 41
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1218
Article PK: 3462

Oscar_Verdeja wrote in
news:C14C89671D2F491A006ECE5C85256D48.006ECE7585256D48@webforums:

> I have know my MS SQL Server ODBC running in my Sybase Central, I have
> some tables already created, how do I create my db files in order to
> have my database in my handheld, so I can create my application?
>
> I have read the PDF Files, but it says that I need to execute the SQL
> statements in order to create the database, in this case I already
> have it, so what's the next step?

Since you are Appforge MobileVB and UltraLite Component Suite, you have
three options.

1) Use the Schema painter that ships with the Component Suite to define
the tables, index, foreign keys, etc and save is as a Schema file
(.usm by default). Your application will use this file on the device
to create the database
2) a. Import the schema from your MS SQL Server into an ASA database using
the "Migrate Data" utility.
b. Then create a publication which will define the subset of
tables/columns you want on the device.
c. Run the ulinit utility to create the schema file.
3) a. Generate an XML file that defines the schema (see help on
"ulxml" to get the XML format).
b. Run the ulxml utility to generate the schema file from
your XML file.

You might also want to go through the tutorial on the Appforge MobileVB
component. It is included in the UltraLite Component Suite help.

--
Shuchit Velkar
iAnywhere Solutions
Professional Services
Please only post to the newsgroup

EBFs and Whitepapers
http://www.ianywhere.com/developer