Android Question Insert data into sqlite database table

gmustafa · Oct 3, 2013

I can count rows form table but can't save data

IfFile.Exists(File.DirDefaultExternal,"HDSS.db")=FalseThen

File.Copy(File.DirAssets,"HDSS.db",File.DirRootExternal,"HDSS.db")

EndIf

SQL1.Initialize(File.DirRootExternal,"HDSS.db",True)

SQL1.ExecNonQuery("INSERT INTO BIRTH (UNIT,SEQ_NO,SRNO,REP_VILL)

VALUES

('"& unittxt.Text &"','"& pcnotxt.Text &"','"&slnotxt.Text&"','"&repvilltxt.Text&"')")

Msgbox("Birth Record Saved ","")

Aldy009 · Feb 26, 2015

I GOT IT!!

Thank you Erel. I just realized what you meant. I was looking at the wrong database. Cheers mate.

klaus · Feb 26, 2015

The folder in the Files Tab is the Assets folder.
You cannot acces a database in this folder, that's the reason why you need to copy it somewhere else.
To see a change you could either read the database back in your application or access the database from the device via a USB connection.

Aldy009 · Feb 26, 2015

klaus said:
The folder in the Files Tab is the Assets folder.
You cannot acces a database in this folder, that's the reason why you need to copy it somewhere else.
To see a change you could either read the database back in your application or access the database from the device via a USB connection.

Yes, thank you Klaus. Just realized it now. Still an Android newbie.

Android Question Insert data into sqlite database table

gmustafa

New Member

Aldy009

Member

klaus

Expert

Aldy009

Member

Android Question Insert data into sqlite database table

gmustafa

New Member

Aldy009

Member

klaus

Expert

Aldy009

Member

Privacy & Transparency

Privacy & Transparency