Help with SQLite reader

Discuss
1

Can you help me? I’m stuck. When I try to read the database, it won’t read it. I’ve attached my blocks and the AIA in case anyone can check and tell me what I’m doing wrong.

The image shows a visual programming code block for initializing a process that attempts to load a database, displaying alerts for loading status or errors, and controlling the visibility of a button based on the success of the database operation. (Captioned by AI)
The image shows a visual programming code block for initializing a process that attempts to load a database, displaying alerts for loading status or errors, and controlling the visibility of a button based on the success of the database operation. (Captioned by AI)784×297 23.3 KB

This image shows a block-based programming script that queries a SQLite database to retrieve book names and updates a list view component with the retrieved book list, selecting the first item if the list is not empty. (Captioned by AI)
This image shows a block-based programming script that queries a SQLite database to retrieve book names and updates a list view component with the retrieved book list, selecting the first item if the list is not empty. (Captioned by AI)907×282 28.3 KB

A block-based programming script triggers actions when an item is selected in a list, setting global variables, querying a SQLite database for the maximum chapter number of a book, and then closing the database and updating the chapter list display. (Captioned by AI)
A block-based programming script triggers actions when an item is selected in a list, setting global variables, querying a SQLite database for the maximum chapter number of a book, and then closing the database and updating the chapter list display. (Captioned by AI)1110×337 35.7 KB

The image shows a block-based programming script that initializes and fills a chapter list, updates a ListView with chapter elements, and sets the selected index if the list is not empty. (Captioned by AI)
The image shows a block-based programming script that initializes and fills a chapter list, updates a ListView with chapter elements, and sets the selected index if the list is not empty. (Captioned by AI)672×323 28.6 KB

proyecsqlite.aia (28.4 KB)

3

Do some debugging:

image
image816×620 59.4 KB

(there is no sql database in your assets in your aia project, but you probably left it out for a reason. This however, makes it difficult to test your aia project)

You may need to select Show Lists As JSON ?

4

You’re right. I don’t understand why it doesn’t appear in the assets. Because I reopened Kodular and had to upload it again.

5

biblesqlitedcop.aia (3.7 MB)

6

image
image998×243 39.3 KB

This way, it works for me.

1 Like
7

Thank you so much, it works perfectly. I’ll continue with the other part of the blocks. Thank you so much :face_blowing_a_kiss:

1 Like
8

Look, I made these blocks to use the last list view and it shows me the following error

A colorful block-based programming script that initializes and queries a SQLite database to display verses related to a selected chapter in a list view. (Captioned by AI)
A colorful block-based programming script that initializes and queries a SQLite database to display verses related to a selected chapter in a list view. (Captioned by AI)1205×375 43 KB

EROR: Argument () to ‘apply-to-args’ has wrong type (gnu.mapping.Values) (expected: procedure) at gnu.kawa.functions.ApplyToArgs.applyN(ApplyToArgs.java:170) at gnu.mapping.ProcedureN.apply1(ProcedureN.java:31) at io.makeroid.companion.Screen1.processException(Screen1.yail:10101) at io.makeroid.companion.Screen1.dispatchEvent(Screen1.yail:10157) at com.google.appinventor.components.runtime.EventDispatcher.delegateDispatchEvent(EventDispatcher.java:242) at com.google.appinventor.components.runtime.EventDispatcher.dispatchEvent(EventDispatcher.java:198) at com.google.appinventor.components.runtime.ListView.AfterPicking(ListView.java:335) at com.google.appinventor.components.runtime.ListView.onItemClick(ListView.java:303) at android.widget.AdapterView.performItemClick(AdapterView.java:380) at android.widget.AbsListView.performItemClick(AbsListView.java:1371) at android.widget.AbsListView$PerformClick.run(AbsListView.java:3669) at android.widget.AbsListView$3.run(AbsListView.java:4855) at android.os.Handler.handleCallback(Handler.java:959) at android.os.Handler.dispatchMessage(Handler.java:100) at android.os.Looper.loopOnce(Looper.java:257) at android.os.Looper.loop(Looper.java:342) at android.app.ActivityThread.main(ActivityThread.java:9638) at java.lang.reflect.Method.invoke(Native Method) at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:619) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:929)
Note: You will not see another error reported for 5 seconds.

9

Maybe the query is throwing an error and returning an empty list, or you’re not passing a list to the ListView.
During debugging, always add a notifier to see what you’re getting.
Here, I think you need to add some spaces.

immagine
immagine640×198 11.4 KB

And add a block that shows you the SQLite errors.

immagine
immagine422×158 9.34 KB

1 Like
10

Hey, it works perfectly for me. The problem was in the spaces you indicated. You’re very wise, and thanks for supporting the community.

1 Like
11

Thank you so much, you’re really very kind,
It’s a pleasure to help you all :heart_hands:

1 Like