Re: multi table relational databases

2008-05-29 Thread Dave Lippincott
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 palm-dev-forum@news.palmos.com Sent: Thursday, July 27, 2000 1:58 PM Subject: RE: multi table

RE: multi table relational databases

2008-05-29 Thread Bob Whiteman
, however, you only have one version for all your database tables. -Bob Whiteman -Original Message- From: K. Chugh [mailto:[EMAIL PROTECTED] Sent: Thursday, July 27, 2000 11:26 AM To: Palm Developer Forum Subject: Re: multi table relational databases hi bob. thanks

RE: multi table relational databases

2008-05-29 Thread Bob Whiteman
I've implemented a fairly simple relational database for an appliation. One problem with your suggested approach below is that it may be very tricky to sort the tables. Also, searches and inserts will take longer because they have to deal with a much larger Palm database. I used separate Palm

Re: multi table relational databases

2008-05-29 Thread Tim Astle
I programmed an app that uses 3 databases, and they're set up in a one to many relationship. It works great. I even have a delete which will work through the sub databases and delete useless records in them too. (Basically what a database is to plam, is what I consider a table... so if it's

Re: multi table relational databases

2000-07-27 Thread Steve Mann
i was thinking of opening one database and using the category for the table identifier then just inserting records in the appropriate "table." has anyone tried this? I'm not sure I totally understand your proprosal, but I've done something like what I think you're describing. I created a

RE: multi table relational databases

2000-07-27 Thread Bob Whiteman
I've implemented a fairly simple relational database for an appliation. One problem with your suggested approach below is that it may be very tricky to sort the tables. Also, searches and inserts will take longer because they have to deal with a much larger Palm database. I used separate Palm

Re: multi table relational databases

2000-07-27 Thread Tim Astle
I programmed an app that uses 3 databases, and they're set up in a one to many relationship. It works great. I even have a delete which will work through the "sub databases" and delete useless records in them too. (Basically what a database is to plam, is what I consider a table... so if it's

Re: multi table relational databases

2000-07-27 Thread K. Chugh
hi bob. thanks for the reply. i am looking at like 14 or so tables, and i figured i don't want all those handles open at the same time. this is my first database program so i'm not sure if this is a rational concern or not. some of the tables will have only a few records, while others will

Re: multi table relational databases

2000-07-27 Thread Dave Lippincott
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: mu