Basic4Android - SQLite Demo (Add, Delete, Update/Edit)

Operating System

The beauty of this simple little program is not in its novelty value, but that it can be added to any other program to add functionality and make a point of difference. Please install the apk installer to see the sample demo in action. To our webmaster your kindness is highly appreciated. Hobert Starks always at your service!

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Submitted byAnonymous (not verified)on Mon, 09/24/2012 - 09:46

nice sir
Submitted byhob2006on Mon, 09/24/2012 - 16:24

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. ------------------------------------------------------------
Submitted byAnonymous (not verified)on Tue, 09/25/2012 - 09:55

Not quite understanding what this is? You can access a mysql database via an android?

>I use SQLite database for this application.Please read my post about SQlite. >Please install the apk file to an android phone. >This Simple program can Add, Delete, and Edit/Update data using SQLITE database. >It is possible to use mysql database to an android phone via a network connection (wi-fi) or in webserver. >Thank you for your inquiry

It is in the FILEs FOLDER.To see this simple program in action, kindly install the apk installer (in the Objects folder). This apps is for Android phones, tested in samsung galaxy y
Submitted byAnonymous (not verified)on Mon, 01/07/2013 - 15:22

what are the softwares needed to run sqlitedemo program
Submitted byhob2006on Tue, 01/08/2013 - 15:47

In reply to by Anonymous (not verified)

SQLite database engine and Basic4Android IDE.Thank u sir
Submitted byAnonymous (not verified)on Sun, 02/10/2013 - 20:31

Thank you for the nice example. More are appreciated!
Submitted byAnonymous (not verified)on Sat, 02/23/2013 - 04:10

Hi, Im very interested in your app code. I have installed Basic4Android and i paste your code inside. I need add reference to sql and cursor, how i do it? I need install sqlite, it can be installed in emulator? Thanks!
Submitted byhob2006on Sun, 02/24/2013 - 10:07

In reply to by Anonymous (not verified)

Sir, This is due to broken license. It works on a licensed b4a IDE. Thanks!
Submitted byAnonymous (not verified)on Mon, 03/04/2013 - 17:57

Can we use Eclipse helios in running this application? Thanks.
Submitted byhob2006on Tue, 03/05/2013 - 11:17

In reply to by Anonymous (not verified)

This apps was written in Licensed Basic4Android. This is not compatible with eclipse helios. Thanks!
Submitted byAnonymous (not verified)on Tue, 05/28/2013 - 14:44

Can you please tell me how to connect MS SQL Server data base through basic4android. thanks Manoj

http://www.basic4ppc.com/forum/basic4android-getting-started-tutorials/13166-connect-android-ms-sql-server-tutorial.html#post74199
Submitted byAnonymous (not verified)on Sat, 06/15/2013 - 14:00

so beautif i learn with this sql lite sooooooo tahnks
Submitted byAnonymous (not verified)on Fri, 07/05/2013 - 20:35

hello i need help for run this program source in basic4android one error runtime >> error device [email protected]
Submitted byhob2006on Fri, 07/26/2013 - 11:06

This is due to your broken licensed IDE.Thanks!
Submitted byDriss (not verified)on Sat, 07/27/2013 - 19:57

1 - Je veux savoir l'emplacement de la base de données SQLDemo dans le système ANDROID... 2 - Est ce que c'est possible de définir un emplacement spécifie dans le chemin d'acces Basic4Android exp. /sdcard/Android/data/db.dql Merci
Submitted byDriss (not verified)on Thu, 08/01/2013 - 01:59

Hi, I want connect my device with my sqllite data base in my pc (ethernet) but the SMB not work in declaration : Dim SMB1 AS SMB (B4A not now it) ??? Thanks for help
Submitted bymanuaaa (not verified)on Sat, 08/17/2013 - 16:17

Dear Permalink Please help me to update a table from Webserver to devise database in basic4android. I am using the below mentioned code it is updating only one value to all columns. a.setDatabase("XXX.67.248.XXX","xxxx","manxxx","manxxxx") L= a.Query("select * from TabDate") For i = 1 To L.Size -1 SQL1.ExecNonQuery2("INSERT INTO datemstr VALUES (?, ?, ?, ?, ?)", Array As Object(i) Next Please help me. Thanks in Advance Manoj Kumar
Submitted byAnonymous (not verified)on Wed, 09/11/2013 - 20:31

sir pano po maupdate ung data ng .sql file? di sya naguupdate pag nagedit ako ng user and pass
Submitted bycambel (not verified)on Tue, 11/05/2013 - 13:47

Hello Sir ! In An android its possible to store the data(Image, text) in SqlLite and retrieve in xml ? pls advice , thank..
Submitted byprimadonaa (not verified)on Wed, 11/13/2013 - 18:35

thank;s for your tutorial, its relly helpful, i wonder.. how if my database have a table contain image blop, can i make it grid thumbnail.. like contact grid ? thnks
Submitted byMoBangon (not verified)on Tue, 11/26/2013 - 21:11

Nice
Submitted bymej (not verified)on Tue, 09/30/2014 - 11:42

In reply to by sofiane (not verified)

hey can i have the full source code about the Basic4Android - SQLite Demo (Add, Delete, Update/Edit) PLEASE... I badly need it. JUST SEND IT @ [email protected]
Submitted byLisa Tampubolon (not verified)on Mon, 06/30/2014 - 12:34

hello, can you help me? how are the syntax to show data from sqlite to listview in basic4andoid? thankyou.
Submitted byKolekcionar (not verified)on Tue, 09/30/2014 - 06:03

How to store data from XML to SQLite in B4A ? thanks in advance.

Add new comment