Daniel44 Active Member Licensed User Sep 29, 2020 #1 Hi everyone! I've been searching for nested clv to display data from a Sqlite Db and just found nested clv examples but with items from a loop. I've found Erel's examples with floating titles and others but without Sqlite db. I have a Sqlite db with countries and their important cities some countries have 4 important cities other has 3 or less..and what I'd like to display is That Countries (without repeating) as Title and their important cities as items.. just I know how to do the sql sentence in my db but I can't implement that results into a Nested Clv. If there someone to help me I'll appreciate it. Thanks. Last edited: Sep 29, 2020
Hi everyone! I've been searching for nested clv to display data from a Sqlite Db and just found nested clv examples but with items from a loop. I've found Erel's examples with floating titles and others but without Sqlite db. I have a Sqlite db with countries and their important cities some countries have 4 important cities other has 3 or less..and what I'd like to display is That Countries (without repeating) as Title and their important cities as items.. just I know how to do the sql sentence in my db but I can't implement that results into a Nested Clv. If there someone to help me I'll appreciate it. Thanks.
mangojack Expert Licensed User Longtime User Sep 29, 2020 #2 Here is a small example as promised. I am unsure how your DB is structured , but it still should be a guide to get you going. Attachments CLV Nested DB example.zip CLV Nested DB example.zip 14.1 KB · Views: 791 Upvote 0
Here is a small example as promised. I am unsure how your DB is structured , but it still should be a guide to get you going.
Daniel44 Active Member Licensed User Sep 29, 2020 #3 mangojack said: Here is a small example as promised. I am unsure how your DB is structured , but it still should be a guide to get you going. Click to expand... @mangojack thanks a lot!! Upvote 0
mangojack said: Here is a small example as promised. I am unsure how your DB is structured , but it still should be a guide to get you going. Click to expand... @mangojack thanks a lot!!
Daniel44 Active Member Licensed User Sep 30, 2020 #4 mangojack said: Here is a small example as promised. I am unsure how your DB is structured , but it still should be a guide to get you going. Click to expand... Hey @mangojack you're a genius. That's what I was looking for !!! Thank you so much!! Upvote 0
mangojack said: Here is a small example as promised. I am unsure how your DB is structured , but it still should be a guide to get you going. Click to expand... Hey @mangojack you're a genius. That's what I was looking for !!! Thank you so much!!
P ProjectGroup19 Active Member Licensed User Longtime User Apr 21, 2021 #5 Hi, please, I followed your example and It work for me but can I twerk it to group similar items with a custom layout? Something like this but the group them According tho the heading. The Treasurer position has two candidates, how do I put them under on heading. Upvote 0
Hi, please, I followed your example and It work for me but can I twerk it to group similar items with a custom layout? Something like this but the group them According tho the heading. The Treasurer position has two candidates, how do I put them under on heading.
