Re: [pilot-db-list] make a relation between two tables

[Yedidyah Bar-D. <di...@ta...>]

On Mon, Aug 30, 2004 at 02:41:50PM -0300, cybersamurai wrote:
> Some questions:
> 
> How can I make a relation between two tables?

Can you be more specific?
This is a weak poing in pilot-db, the main thing is "link" and "linked"
fields. Try to play with them.

> 
> Is possible I make a program in C or C++ and access some API for work with data make with Pilot-DB?

On a PALM? I don't know. On a PC? You can use palm-db-tools. While not
properly documented and not separatly packaged, it is divided to a few
libraries and two main programs. Note that I recently wrote a patch
that makes it read/write some more data, which is, for now, only at
<http://www.cs.tau.ac.il/~didi/palm-db-tools-with-filters-and-scripts.patch>.

Nate says we need to adopt here palm-db-tools and apply the patch.
Maybe I'll soon do this.

> 
> Can I make a simple form for insert data and make some search?

On a PALM? There are already forms for this. If they are not good enough
you'll have to fix them :-)
On a PC? You can try using the lib parts of palm-db-tools, as I wrote
above, but I think it's easier to convert the data to some SQL DB and
write an interface to it. I intended to work on this, and know others
did, but didn't do anything generally-useful (except the above patch,
which helps make this possible).

> 
> The source is good documented?

I do not know. I only read parts of it, and managed to survive. You
can look at my patch to see what I had to change, it will probably
give you some hints at its structure. pilot-db's source - I only read
parts and wrote one-liner fixes. I do not know if it's easy to make
big changes to it.

> 
> Thanks about some help.

Good luck,
-- 
Didi