Android Tutorial SQLiteDB

Below you find an application with a SQLite database and a ScrollView based table.
What the program can do:
- Read a database, 'Load' button.
- Edit, modify or delete date sets (single- or multi-selection), 'Edit' button.
- Edit and modify a single cell, 'Long_Click' on a cell in a selected row.
- Filter the database, 'Filter' button, Click filter or unfilter, LongClick definition of filter criterias.
- Sort a column ascending or descending, clickink onto the column header.
- Create a new database, 'New' button.
- Scroll the table verticaly with the standard Scrollview, and horizontaly on the blue line between the ScrollView and the toolbox (or with a SeekBar, hidden by default.
- Change the table setup, alignment, column width, text size, colors, etc.

What the program connot do:
- Share multiple tables.

I post it as a tutorial more to show what could be done, rather than a specific program in Share Your Creations.
Questions, constructive critics, comments, wishes and bug reports are welcome.

You can use the source code, or parts of it, for your own applications.

EDIT: 2012.07.05
Added a version using the ScrollView2D library.

EDIT: 2013.02.08
Amended error reported in post #27
Updated zip file SQLiteDB_2D_v_1_2.zip

EDIT: 2013.02.09
Amended error reported in post #30
Updated zip file SQLiteDB_2D_v_1_3.zip

EDIT: 2013.04.19
Eliminated error with Null values in a database reported in post #45.
Updated zip file SQLiteDB_2D_v_1_4.zip

EDIT: 2013.07.01
Eliminated some errors.
Removed most of the compiler warnings.

EDIT: 2014.02.09
Amended bug reported in post #57
Missing DBFilePath on btnLoad_Click

Best regards.

 

[Beja]

Hi Klaus,
kind of weird.. the error is only when I use the emulator.. but on real device it is running fine, no problem.

 

[klaus]

Did you set a memory size for SD card in the emulator ?

 

[Beja]

The storage page items are grayed out and I had no chance to edit them. (image)

 

[klaus]

You need to set it when you define a new emulator.
Beginner's Guide page 14.

 

[Beja]

Then will re-install it again... danke!

another minor issue,
in the horizontal scroll, one can easily lose his record.. is it possible that the alternating color be for the rows instead of the columns?

 

[klaus]

Feel free to adapt it to your needs.
Shouldn't be difficult.

 

[Beja]

looking into the cel-col part of the code.. hopefully will get it..

many thanks.

 

[IslamQabel]

Dear Kalus.....your program is so great and wonderful....Actually, i want to record GPS real time data (long & lat & speed) in table...i succeeded to record these data on a txt file ....which part of the program could be useful for storing my data? ....As your program is so large so i can not get the useful part for me
Thanks

 

[klaus]

Have a look at the two SQLiteLight examples in my signature, these are simple examples to get started with SQLite.
You might also have a look at chapter 3 SQLite Database in the User's Guide.

 

[cncncn]

Hi,

Thank you for this work.
But when i load my file.db i have got this message :

Error occurred


An error has occurred in sub:main_loaddatabase(java line: 2595)
android.database.CursorIndexOutOfBoundsException: Index 0
request, with a size of 0
Continue ?

 

[klaus]

Can you test the program in Debug mode and post the message in the Log.
Or post your project with the database as a zip file (IDE menu Files / Export As Zip).
Is your database a SQLite database ?
SQLiteDB works only with SQLite databases !

 

[LucaMs]

Hi,

Thank you for this work.
But when i load my file.db i have got this message :

Error occurred


An error has occurred in sub:main_loaddatabase(java line: 2595)
android.database.CursorIndexOutOfBoundsException: Index 0
request, with a size of 0
Continue ?

check YourCursors.RowCount

 

[cncncn]

Can you test the program in Debug mode and post the message in the Log.
Or post your project with the database as a zip file (IDE menu Files / Export As Zip).
Is your database a SQLite database ?
SQLiteDB works only with SQLite databases !

ah ok. It isn't SQLite databases but Paradox databases (.db)

 

[JUAN CARLOSORDOÑEZ]

Hello:

How I can do to make the database do not take it from the device but from pc? thanks!!

 

[DonManfred]

How I can do to make the database do not take it from the device but from pc?

You need to run a RDC on the PC.