Android Question Jacckess Read All Values Of A Column

[BitsAndBytes]

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]

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]

yes my project is on access , what choices i have to use other data base?

 

[Erel]

SQLite with the SQL library is a good option.

 

[BitsAndBytes]

Thank you Erel. Always willing to help!