Daniel44 Active Member Licensed User Aug 24, 2019 #1 Hi everyone! Im working on B4A and bxtable and dialogs retriving data from json and sqlite Im using bxdialog for editing data. The proyect works with 2 tables, Books and Authors and they're linked each other by foreign keys. On the event LongClick of Bx4table I Call the bxdialog and retrive all data from sqlite db by a sentence which retrieve Name and author's name by a field called AuthorId of type Int (FK) but I'd like retrieve that Author'name in combobox from sqlite by a sql sentence.. I mean a Dynamic combobox INSIDE the dialog. So I declared sql sentence variable inside the long click and then inside the json the type key and otptions harcoded but it doesn't work . I don't know how to retrieve just the author's name on that Combobox either how handle a combobox inside that event. If anyone can help me I apreciate it thanks
Hi everyone! Im working on B4A and bxtable and dialogs retriving data from json and sqlite Im using bxdialog for editing data. The proyect works with 2 tables, Books and Authors and they're linked each other by foreign keys. On the event LongClick of Bx4table I Call the bxdialog and retrive all data from sqlite db by a sentence which retrieve Name and author's name by a field called AuthorId of type Int (FK) but I'd like retrieve that Author'name in combobox from sqlite by a sql sentence.. I mean a Dynamic combobox INSIDE the dialog. So I declared sql sentence variable inside the long click and then inside the json the type key and otptions harcoded but it doesn't work . I don't know how to retrieve just the author's name on that Combobox either how handle a combobox inside that event. If anyone can help me I apreciate it thanks
Erel B4X founder Staff member Licensed User Longtime User Aug 25, 2019 #2 Might be helpful: https://www.b4x.com/android/forum/t...table-table-and-export-to-csv.102847/#content Upvote 0
Might be helpful: https://www.b4x.com/android/forum/t...table-table-and-export-to-csv.102847/#content
Daniel44 Active Member Licensed User Aug 25, 2019 #3 Thank you Erel I've already seen all of them ..but there's no one that use a combo/spinner bringing data from sqlite by json in a dialog. Whatever thank you Erel Upvote 0
Thank you Erel I've already seen all of them ..but there's no one that use a combo/spinner bringing data from sqlite by json in a dialog. Whatever thank you Erel
KMatle Expert Licensed User Longtime User Aug 26, 2019 #4 Daniel44 said: Thank you Erel I've already seen all of them ..but there's no one that use a combo/spinner bringing data from sqlite by json in a dialog. Whatever thank you Erel Click to expand... Not a thing. Just check how SQlite and Json works. There are lot's of examples here. Upvote 0
Daniel44 said: Thank you Erel I've already seen all of them ..but there's no one that use a combo/spinner bringing data from sqlite by json in a dialog. Whatever thank you Erel Click to expand... Not a thing. Just check how SQlite and Json works. There are lot's of examples here.
Daniel44 Active Member Licensed User Aug 26, 2019 #5 KMatle said: Not a thing. Just check how SQlite and Json works. There are lot's of examples here. Click to expand... Thank you for answering..yes you're right I've seen all about sqlite and json. That's not the problem.. just anything teaches about sqlite and json Inside a dialog with a spinner retriving data .There's a lot of examples about sqlite but not what I'm searching for. Thanks Upvote 0
KMatle said: Not a thing. Just check how SQlite and Json works. There are lot's of examples here. Click to expand... Thank you for answering..yes you're right I've seen all about sqlite and json. That's not the problem.. just anything teaches about sqlite and json Inside a dialog with a spinner retriving data .There's a lot of examples about sqlite but not what I'm searching for. Thanks
