U++ framework: U++ SQL » master/detail sqlite3 example

Home » U++ Library support » U++ SQL » master/detail sqlite3 example

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

master/detail sqlite3 example [message #33044]

Mon, 04 July 2011 15:30

forlano
Messages: 1237
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

[Message index]

		master/detail sqlite3 example By: forlano on Mon, 04 July 2011 15:30
		Re: master/detail sqlite3 example By: sergeynikitin on Tue, 05 July 2011 10:12
		Re: master/detail sqlite3 example By: forlano on Tue, 05 July 2011 15:48
		Re: master/detail sqlite3 example By: sergeynikitin on Tue, 05 July 2011 19:43

Previous Topic:	Sqlite with U++
Next Topic:	SqlArray and data validation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon May 25 01:48:17 GMT+2 2026

Total time taken to generate the page: 0.00525 seconds