BitsAndBytes Active Member Licensed User Nov 9, 2016 #1 Is it possible for Jacckess , if you have 2 columns with 10 rows on a table, to read all rows from a specific column and add it to a list? Thank you!
Is it possible for Jacckess , if you have 2 columns with 10 rows on a table, to read all rows from a specific column and add it to a list? Thank you!
Erel B4X founder Staff member Licensed User Longtime User Nov 9, 2016 #2 Don't use Access databases if you have a choice. You need to call Table.GetNextRow and then get the column value with Table.GetColumnValue. Call it in a loop to read all the values. https://www.b4x.com/android/help/jackcess.html#jackcesstable_getcolumnvalue Upvote 0
Don't use Access databases if you have a choice. You need to call Table.GetNextRow and then get the column value with Table.GetColumnValue. Call it in a loop to read all the values. https://www.b4x.com/android/help/jackcess.html#jackcesstable_getcolumnvalue
BitsAndBytes Active Member Licensed User Nov 9, 2016 #3 yes my project is on access , what choices i have to use other data base? Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Nov 10, 2016 #4 SQLite with the SQL library is a good option. Upvote 0
BitsAndBytes Active Member Licensed User Nov 10, 2016 #5 Thank you Erel. Always willing to help! Upvote 0