U++ forum: Welcome to the forum

master/detail sqlite3 example [message #33044]

Mon, 04 July 2011 15:30

forlano
Messages: 1207
Registered: March 2006
Location: Italy

Senior Contributor

Hello,

I saw the reference example SqlArray but I need something different that I already perform under PHP/MySql with the right tool. I wonder if I can easily reply it with Upp/Sqlite.

I have two tables, for example:

Author
----------------------
id | name | birthday

and

Book
-----------------------
id | title | author_id

I want to show the table Book in an ArrayCtrl (SqlArray ?) but the column author_id should list, via a DropList, all the names contained in table Author. So the user simply select the author name already in table. Of course when the data is saved the record of Book should contain the 'id' and not the name of the author.
Is it possible in some easy way? I am able to realize it using ArrayCtrl and DropList building all pieces of code, but maybe does exist a super short way.

Thank you,
Luigi

Report message to a moderator