That looks rather good, is there a URL where we could get more info or
download something?
-----Original Message-----
From: David Fishburn <[EMAIL PROTECTED]>
To: 'Mandar Joshi' <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Thursday, July 22, 1999 8:54 AM
Subject: RE: relational databases?
>> The APIs dont provide any means to join the tables, you can
>> not open more
>> than
>> one database at a time. these facts force you to design your
>database
>> tables
>> in denormalized format.
>
>The Sybase Ultralite software does this for you. The code you write
>does not directly reference any Palm DBs, it just uses embedded SQL to
>access your tables. You would write the SQL just like you would with
>any relational database regardless witch platform you actually deploy
>your application to (ie Win32, DOS, CE, Palm, RIM, ...)
>
>Here is a couple of examples:
>
> EXEC SQL
> INSERT INTO ULIdentifyServer( "server_id" )
> VALUES ( :sql_server_id );
>
> EXEC SQL UPDATE ORDERS
> SET "server_id" = :sql_server_id
> WHERE "table_id" = :sql_table_id
> AND "order_status" <> :sql_order_status;
>
>JOINS:
> EXEC SQL BEGIN DECLARE SECTION;
> long sql_table_id;
> long sql_pk;
> EXEC SQL END DECLARE SECTION;
>
>
> EXEC SQL
> SELECT kp.table_id, min( "key_id" )
> INTO :sql_table_id, :sql_pk
> FROM KEY_POOL kp, KEY_POOL_TABLE kpt
> WHERE kp.table_id = kpt.table_id
> AND kpt.table_name = :sql_table_name
> GROUP BY kp.table_id;
>
>You have full access to the functions the database supports, like the
>above min() function.
>
>The file needs to be pre-processed and then compiled in with your
>application. We have a CodeWarrior 5 plugin that automates this for
>you. It will also add any files to the project that is required.
>
>Since many of our applications need performance, the projects I have
>worked on, queries on tables that contain over 15,000 rows had
>sub-second response times! These have been running mainly on Palm III
>and IIIx.
>
>Any updates to the database are automatically flagged for
>synchronization, which is also taken care of for you with any of the
>major DBMS vendors out there.
>
>I am happy to answer any questions people might have.
>
>David Fishburn
>Mobile and Embedded Computing (MEC) Sivision
>Sybase
>
>
>> -----Original Message-----
>> From: Mandar Joshi [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, July 22, 1999 12:32 AM
>> To: [EMAIL PROTECTED]
>> Subject: Re: relational databases?
>>
>>
>>
>>
>> Hi Michael,
>>
>> I dont have much idea about the Olite on Palm.
>> But its quite tough job to implement relational database in
>> the current
>> palm
>> database format.
>> The APIs dont provide any means to join the tables, you can
>> not open more
>> than
>> one database at a time. these facts force you to design your
>database
>> tables
>> in denormalized format.
>>
>> Comments welcome.
>>
>> Mandar
>>
>> Michael McFarland wrote:
>>
>> > Is there a fast/easy way to manipulate relational
>> databases (such as
>> > Oracle Lite,
>http://www.oracle.com/mobile/olite/html/olite35_ds.htm)
>> > through the Palm SDK? Or how difficult is it to implement
>> a relational
>> > database type of structure based on the standard Palm
>> databases? Any
>> tips
>> > or resources would be appreciated.
>> >
>> > Michael
>>
>>
>
>
