contact: 
Uki D. Lucas

Recent site activity

180b. strings.xml - CREATE TABLE






























































<?xml version="1.0" encoding="utf-8"?>

<resources>

<string name="app_name">180. SQLite Database</string>

<string name="sql_onCreate">"

CREATE TABLE locations(_id INTEGER PRIMARY KEY AUTOINCREMENT, longitude DOUBLE, latitude DOUBLE, created DATETIME);

INSERT INTO locations

(_id,latitude, longitude, created) VALUES (NULL, '42.2905', '-87.9550', datetime('now'));

INSERT INTO locations (_id, latitude, longitude, created) VALUES

(NULL, '41.889923', '-87.629077', datetime('now'));

"

</string>

<string name="sql_onUpdate">" UPDATE ... "</string>

</resources>