Android Question Insert data into sqlite database table

[gmustafa]

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]

I GOT IT!!

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

 

[klaus]

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]

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.