This example is provided with sources and executables for MorphOS and OS4.
Comments will help to understand how to manage the sqlite3 library, a static
one provided in archive sqlite-3.6.1-amiga.lha that I used for testing.

It is as simple as possible but keeping an interest : you can write queries to
the
database and display results in a list.

To try it, a small database is provided, it contains a kind of bug tracker data,
with tables projects and tickets.

A button allows to execute the query written above and another one lists
the database tables. At the bottom, an area will display errors.

Let me know if you have interest. Else you can improve yourself !

 PERMSSN    UID  GID    PACKED    SIZE  RATIO METHOD CRC     STAMP          NAME
---------- ----------- ------- ------- ------ ---------- ------------ -------------
[generic]                  509    3072  16.6% -lh5- 7d30 Oct 22 22:30 sqlitequery/bugs.db
[generic]                 4051   11768  34.4% -lh5- bcd7 Oct 22 22:30 sqlitequery/sqlitequery.c
[generic]               270574  603520  44.8% -lh5- 5278 Oct 22 22:30 sqlitequery/sqlitequery.mos
[generic]               318772  677756  47.0% -lh5- ef4c Oct 22 22:30 sqlitequery/sqlitequery.os4
[generic]                  518     960  54.0% -lh5- cfac Oct 22 22:30 sqlitequery/sqlitequery.readme
---------- ----------- ------- ------- ------ ---------- ------------ -------------
 Total         5 files  594424 1297076  45.8%            Oct 23 07:03