Android Tutorial (Kotlin) - 30 - SQLite Database Creation and Insertion

Amazon India Affiliated Link:
Please use below link to support my channel

Also you can support via Paypal using

Thank you
#CodeAndroid #Flutter

[sraavanchevireddy]

I feel you are under rated. You got so much of content Brother. All the best and Good Luck. Go ahead with other programming like iOS

[KamilBojara]

Hello Hindusino Love From Poland <3 Only your code works fine for me. Awesome :D

[mysticakira]

For someone viewing this video now,
I have an advice if the app closes on inserting the values
And even after checking every command line by line and having no error in writing the command

Follow this

1)Create a new Project
2)Copy all the stuff from old project(the one which was closing)
3)Run new app(worked for me)....

Reason for not working

Maybe first project created multiple database so it kept closing

Conclusion

Making new project refreshed every error and databases

Hope it helps you guys in future
:)

[rossbaring]

This still works to this day if anyone is wondering, just double check stuff properly when you incorporate it into your app

[snehalkadav]

Sir the app is getting closed once I enter the values in given field and toast is also no visible please give solution for this

[lexinexiai]

You are great, efficient and fast thanks man.

[jaureguiAxel]

my app keeps stopping, i dont know what i did wrong i have no error, can you help me :(

[pikachuu]

At 3:49 db.execSQL(createTable)
The 'db' is red. Why?

Please help🙏

[kkrshn]

Hi Vignesh,
I want to develop an app, can we collaborate and execute it.
Thanks
-Krishna

[Shivam-kzdg]

I'm creating a database which includes two double values and a string

So I'm defining two real values and a text in the last but it is only showing text and ignoring real values . How to fix this issue ?

Sql : "CREATE TABLE " + TABLE_NAME + " (" + COL_ID + "INTEGER PRIMARY KEY AUTOINCREMENT, " + COL_LONGITUDE + " REAL, " + COL_LATITUDE + " REAL, " + COL_MESSAGE + " VARCHAR(256))"

PLEASE tell if it has some issues.

[ankitasharma]

where is the etv variable defined which u used in mainActvity.kt class

[georges.]

Great video! One question... Does the app create a new database each time it is opened, or the db is created once and just "opens" from that point on?

[juanmartinsaravia]

I couldn't get it to work.
Even copying the github code.
It simply says that the table does not exist or that the column does not exist.
Could it be that something has changed?

[nielokun]

can you make a tutorial for fetching data from sql database(local) to tableview(or to a table like view) Thanks.

[mohammadatif]

bro can you please share the github link for the source code..the link shared above are not secure and have so many spams in them

[KyriafinisBill]

I have a question I have around 7 variables in my class and I don't want to update them all at the same time in the data base do I need multiple insertData functions (one for every variable) and same for updating values ? Thanks in advance. Keep up the great tutorials!!

[ashu]

Hello sir can you make more videos on SQL in kotlin programming ??

[muhammettan]

Great tutorial, very useful and clear

[ianschoenrock]

Make sure that CREATE Table is not CREATE_TABLE. I made that mistake and it put me back an hour and a half. Needless to say I made a note of that.

[techdecipher]

Can we make same thing with recycler view?