Database SQLite - read and write data

[Jaroslaw_K (Jarosław K.)]

Hi. I am a beginner programmer for the Android platform. I know the basics of SQL and I can use it in programs written for the Windows platform. Unfortunately I can’t do this in the Kodular wizard. I would like to display the result of an SQL query in a text box or display in a list. In the future, I would like to save the values from the text boxes to the database.
I attach 3 pictures. 1-list view (the program does not display anything), 2-text box view (does not display anything), 3-database view.

Please, give me a hint what I’m doing wrong?

[ShaikhSajidAli (Muhammed Sajid Ali)]

Query will be
SELECT ‘lmie’ FROM ‘Users’ WHERE ‘Id’ = 1

[Jaroslaw_K (Jarosław K.)]

Unfortunately it doesn’t work. I also tried by the way and it also doesn’t work. It seems to me that the SQL question is only correct in the program code I have an error.

[ShaikhSajidAli (Muhammed Sajid Ali)]

Did you get correct sql database path
I think you need to call open database check there is block for open database or load database

[Taifun]

@Jaroslaw_K

Please, give me a hint what I’m doing wrong?

see the documentation SQLite - Kodular Docs
Taifun

Raw Query

Executes the provided rawQuery Statement asynchronously. Returns a YailList with the selected data and number of records in the AfterQuery Event. Parameter: 1) String sql. 2) YailList selectionArgs: List with the arguments that will replace ‘?’ in where clause in the query, to prevent SQL injections

[Jaroslaw_K (Jarosław K.)]

Hey
I read the documentation a few days ago. I have been trying to fix the error for two days but unfortunately I don’t get it right :-(. Kodular documentation is well written but unfortunately there are no tutorials or examples on the Internet. I am looking for and trying to learn it.

[Taifun]

@Jaroslaw_K

but unfortunately there are no tutorials or examples on the Internet.

it seems to be, you have forgotten to search in the community…

How to use the Kodular SQLite component developed by Carlos Pedroza?

I extracted it from @carlospedroza27 's post – PedrozaSQLite Hello! Here I present to you my second extension ever created! It is an extension to access the local SQLite database! Background I know there is already a few extensions with this functionality, but here are the reasons why I made it: First of all, thanks to AppInventor and all its distributions I took my first steps on how to code . Later, I thought about creating extensions and I found that I really like Java and the whole pr…

Taifun

[Vee_Bee]

Hi. I also have similar need. Did you find some solution. Could you please share a working example. Thanks.

[Taifun]

@Vee_Bee

Could you please share a working example.

a working example you can find if you follow the previous link…
unfortunately it looks like you did not read my previous answers at all…
also @CarlosPedroza27 might be happy to answer your question…

Taifun

[Vee_Bee]

Hi Taifun, first of all let me credit you for a big support on many components especially SQLite.
Your answers, not only here, but on many chains of discussions, have guided my way to learn Kodular.

Kodular is a minimal coding tool and dummies like me find it as our only hope. But the level we are at, we need to cross a learning curve even to be eligible to understand the documentation.
I understand we might be sometimes irritating the community with questions as if to spoon feed.
But believe me the pro level you are at, when you spoon feed we still struggle to digest it.

Please don’t lose hope with us, we need the hand of you and the community. Thank you and all, for the support.