[SOLVED] SQLite Single quotes in the query expression

A string constant is formed by enclosing the string in single quotes ('). A single quote within the string can be encoded by putting two single quotes in a row - as in Pascal. C-style escapes using the backslash character are not supported because they are not standard SQL

 

Source: sqlite.org.

[SOLVED] Edit SQLite database of your app from your PC

Very nice solution to browse and edit the SQLite database file of your app directly from your PC.

1. Download


2. Set right path in settings.ini


3. start it

java -jar AndroidDBEditor.jar

Or you can create small batch file AndroidDBEditor.bat

@echo off
rem set current path
set CURRENT_PATH=%~dp0

rem replace slashes
set CURRENT_PATH=%CURRENT_PATH:\=/%

echo sqliteeditorpath=%CURRENT_PATH%sqlitebrowser.exe > settings.ini
rem start app
java -jar AndroidDBEditor.jar

Android DB Editor - troido.de its all about android.

[SOLVED] Creating and Using Databases in Android

Creating and Using Databases in Android.