Strange behavior with almost the same code

[Stephen_Malekar]

There are two different .aia files attached.

In Bible_Sample.aia file the SELECT query opens the DB properly, with the help of TinyDB and JewelFilePicker.

The Bible.aia file has a custom SELECT query which opens the DB properly, with the help of TinyDB and JewelFilePicker but in the ListView1 shows, "Completed" result.

Bible.aia (436.3 KB)
Bible_Sample.aia (441.5 KB)

When the Set Path or Choose Bible, is pressed choose the following file to open,

Bible file

Bible_Sample.aia, works well. But Bible.aia does not yield any records...

Clear Data and Clear Cache to start again....

If two SimpleSQLite are added to Bible.aia, screen goes blank???

[TIMAI2]

What is your testing environment: Android version of device, companion or compiled app?

[Stephen_Malekar]

Everyone please note, matter is solved...

In Bible.aia, in the SELECT statement after the WHERE clause the space was missing...
I gave space to frame the proper SQL SELECT query...
Everything working...

Bible (1).aia (436.4 KB)
Corrected aia file attached above...

Thanks ...

I will try to add more of Commentary/ Dictionary etc...

Sharing Screenshots of Bible app developed by me in another Android platform

https://drive.google.com/file/d/1-PisMbJwNYifebx77qQGe4Amrr038Udq/view?usp=sharing, https://drive.google.com/file/d/11ySQVuQDBC0HrfbFSVKBMng9CHtghgCX/view?usp=sharing, https://drive.google.com/file/d/13f9nwKgAYoNvPyJtD3iAMzljWhoI9z0f/view?usp=sharing, https://drive.google.com/file/d/14uVU8d2gP5D66rTfceAgXvmznXFClQx5/view?usp=sharing, https://drive.google.com/file/d/18LeB6PJWQvdVkJROJXgBdHF61iRD0zVH/view?usp=sharing, https://drive.google.com/file/d/18pdgJBkpdSkp4wLcN01Aaj-4hch0ZVTg/view?usp=sharing, https://drive.google.com/file/d/1AsZC26IombDfFmVVhYX5QXvMeblcuvbA/view?usp=sharing, https://drive.google.com/file/d/1B9tSZVsIpCOfESdT9D_NroG8EllTR5OT/view?usp=sharing, https://drive.google.com/file/d/1BIEgDct4nclDwlMk8ip66RgP9dGt3Eud/view?usp=sharing, https://drive.google.com/file/d/1BXO6N9yZ6WWVmzB-6P_yRjT23VEXg7sy/view?usp=sharing, https://drive.google.com/file/d/1CCla8P6eFyJEEAhV8BqPmjPZekEItMOt/view?usp=sharing, https://drive.google.com/file/d/1DevGGjnRGzn427pZYWK81mxHgQYKv7AZ/view?usp=sharing, https://drive.google.com/file/d/1EY01tMJCbWHpvaUduP2tH2tARsqQFZ2U/view?usp=sharing, https://drive.google.com/file/d/1Gya6yGWNWoT6aXl2Hq6Oki2qvVDj3WE_/view?usp=sharing, https://drive.google.com/file/d/1JhRNO6b-uBN67JDtPqMY0LQ9lAXn6975/view?usp=sharing, https://drive.google.com/file/d/1KYGcYU3H8dTR36QNXmzUH9WM203xYlOd/view?usp=sharing, https://drive.google.com/file/d/1Ni22APC1NbVkJSb1beoCMj_ZRVx-uuIy/view?usp=sharing, https://drive.google.com/file/d/1NowE69OYctdGcCtq9HBIFv5nNIbHy2MA/view?usp=sharing, https://drive.google.com/file/d/1PBNjm-YEJYq1vb0dZgLtK808Pe4np1Mq/view?usp=sharing, https://drive.google.com/file/d/1R8Gy9wBXlRnN58OrfDAHjakGeVPY2awG/view?usp=sharing, https://drive.google.com/file/d/1Rsa-S1zgRnpiWfeugAKGkV5PEZDTbXM7/view?usp=sharing, https://drive.google.com/file/d/1Sll61q5yMrHEbCeBd9mjyr3vKgupNhmg/view?usp=sharing, https://drive.google.com/file/d/1W6UOgBN6NuqzonC1tjpmgujln9Y86Bjg/view?usp=sharing, https://drive.google.com/file/d/1Z7B2IXKrjmx7QV8lOFfFKR3LmEKqO-79/view?usp=sharing, https://drive.google.com/file/d/1ZgaQKm4rlxcE-xWzjt7tmifhoYh5rgB7/view?usp=sharing, https://drive.google.com/file/d/1_Jqlb39AljwMOniIn3Ug0VQpttTU2EnE/view?usp=sharing, https://drive.google.com/file/d/1aPkm1j_Yr_N17yxB6weKWqN0OYwUJywT/view?usp=sharing, https://drive.google.com/file/d/1b-V1BymRZh4SYGrynWYwkyOaFEAlnoOH/view?usp=sharing, https://drive.google.com/file/d/1bla54qSJK36ZKs-axCYwPfoICEcl84QF/view?usp=sharing, https://drive.google.com/file/d/1c-Ir5hSyagI8x1GzU3e0g-acSRghLR5t/view?usp=sharing, https://drive.google.com/file/d/1djvNAD9X2EFIUEV1evblGvCQsjZS7U1d/view?usp=sharing, https://drive.google.com/file/d/1dqsm_t9_Ftx4TPF5hEdD1yC82jIhwOmM/view?usp=sharing, https://drive.google.com/file/d/1eRkZWj-V639rWHqdtEnxhHxyN0hm3CFn/view?usp=sharing, https://drive.google.com/file/d/1f8yMGA52TrNrpoolz3S5Dg3t9cGLeKhm/view?usp=sharing, https://drive.google.com/file/d/1fTNO8tJ8xL1pY2YWggJgRjJim_dZQ338/view?usp=sharing, https://drive.google.com/file/d/1gPN1FQttYSYBmmryK8f66K4vC7XtqTI7/view?usp=sharing, https://drive.google.com/file/d/1gQF5TAosqJSlY78gLZG4i6I3BlKAa6jO/view?usp=sharing, https://drive.google.com/file/d/1k7XXL-5Wx2wOIOtzU9iCpd1qK9QaLl4l/view?usp=sharing, https://drive.google.com/file/d/1kBp4RAJU2EOhCZwIfo9p5J3fGC7pDK-o/view?usp=sharing, https://drive.google.com/file/d/1m8sggRPCuXE9ajiBh7sovFOKm14x6xCc/view?usp=sharing, https://drive.google.com/file/d/1n1us8vGEPTcBYAdk8KM31umKizBMRgB3/view?usp=sharing, https://drive.google.com/file/d/1oXpE6_SaJM7Y6Jh2UBhYyLAAsSQUqA0Z/view?usp=sharing, https://drive.google.com/file/d/1oafgD3mcTRVkQR5VWoYPj5of6W7RmD_v/view?usp=sharing, https://drive.google.com/file/d/1sgC8WipRMtQJ95PxaLSRqmEFShaA9ltc/view?usp=sharing, https://drive.google.com/file/d/1t2zZytK_rdwAqn1eKVlxRDh5a0KtyuT9/view?usp=sharing, https://drive.google.com/file/d/1tDGhzqBS0Q7BeSyUde7J3GUulHxpdydu/view?usp=sharing, https://drive.google.com/file/d/1u1FArwITXISDwP5zs6euN1Yczqeug-qe/view?usp=sharing, https://drive.google.com/file/d/1vuvtDv95Lq-f4dQCvaoDVvYkpfpfs9Ci/view?usp=sharing, https://drive.google.com/file/d/1wGeCTV-cSkhLWkJxkll4oAX0sJTUZEXp/view?usp=sharing, https://drive.google.com/file/d/1wn27rd5pxhrI3fuKLSgqhb6I4VX-wAbd/view?usp=sharing

Sorry... I have bothered you...

[TIMAI2]

@Stephen_Malekar

I had a little play with this to see if I could streamline your use of SQLite and databases.

1. I combined the Books and Bible databases to make one database. You can currently download it from here: https://drive.google.com/file/d/1bOHghKovgIfP9ZJu8w5v9k_HEmOa5z88/view?usp=drive_link.
2. The app downloads the database from Google Drive to the ASD on first run of the app (for Android versions +11). Ensure that your file is set to Anyone with the link.
3. My guess is that the database will generally be read only, so you can leave it where it is, and just set the DBName. You can share your download url for anyone who may want the actual file outside of the app.
4. I did my best to follow your sequence: Load the Bible, select a Book and a Chapter, then display the verses in a listview.
5. Storing the db in the ASD should avoid any nonsense with permissions and android versions after 4.0.
6. For Android version <11 you may need to make some adjustments...
7. Hopefully a better use of SimpleSQLite and Spinners!

BLOCKS

AIA

BibleII.aia (28.1 KB)

You will need to enter your own google drive file ID...