The person's original plan was to use the category attribute of individual
records to split a single Palm database into multiple "tables". This
category attribute is the one that's limited to 16 values. Though he
only needs 14 tables, in the future if he needs to add more tables to the
database, in which case he'll have to replace that mechanism with
something else. I was just warning him of that possibility.
If he instead uses the first byte of each record or some other mechanism
to replace the built-in category mechanism he won't hit that limit. I
think it would be simpler to just use multiple Palm databases, though.
-Bob Whiteman
-----Original Message-----
From: Dave Lippincott
To: Palm Developer Forum
Sent: 7/27/2000 12:34 PM
Subject: Re: multi table relational databases
What does having 14 Tables/DBs have to do with the Palm only having 16
categories? (really only 15 if you count the obligatory 'all'
category).
Category use is definable or ignoble by the programmer. To get around
the #
limitation, you just ignore the PDB built in category mechanism and use
your
own if need be. I've seen applications from other developers with
essentially an unlimited # of categories.
----- Original Message -----
From: "Bob Whiteman" <[EMAIL PROTECTED]>
To: "Palm Developer Forum" <[email protected]>
Sent: Thursday, July 27, 2000 1:58 PM
Subject: RE: multi table relational databases
> Well 14 tables raises a new concern. You can only have 16 categories in
> a Palm database. If you were to add a couple more tables to your already
> extensive database you'll be out of luck.
--
For information on using the ACCESS Developer Forums, or to unsubscribe, please
see http://www.access-company.com/developers/forums/
