SQLite Database

gunaztar · by **gunaztar** » Tue Feb 26, 2008 5:36 am

I am working with SqLite database using m5 version. The following line in thee code showing error. Cannot find symbol.. Wat to do...

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 Cursor c;
 
        c = myDB.query("SELECT FirstName,Age FROM " + MY_DATABASE_TABLE ,null);
Parsed in 0.030 seconds,  using GeSHi 1.0.8.4

snowtiger · by **snowtiger** » Tue Feb 26, 2008 5:17 pm

Here u can have a look at a complete SQLite example:

http://developer.db4o.com/ProjectSpaces ... rd_Manager

API sais:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

query(Uri, String[], String, String[], String) //which returns data to the caller
Parsed in 0.030 seconds,  using GeSHi 1.0.8.4

Can't see this Strings in ur code snippet.

plusminus · by **plusminus** » Tue Feb 26, 2008 7:29 pm

Hello gunaztar,

in m5 you have the possibility snowtiger, but also still the old style is possible.

The function now is called "Cursor android.database.sqlite.SQLiteDatabase.rawQuery(String sql, String[] selectionArgs)".

Regards,
plusminus

living_sword · by **living_sword** » Wed Feb 27, 2008 3:43 am

try this,

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

String[] myCols = {"FirstName","Age"};
 
Cursor c = myDB.query(true, MY_DATABASE_TABLE, myCols, null, null, null, null, null);
Parsed in 0.033 seconds,  using GeSHi 1.0.8.4

i've used this form of query,

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public Cursor query(boolean distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)
Parsed in 0.035 seconds,  using GeSHi 1.0.8.4

chitgoks · by **chitgoks** » Tue Mar 11, 2008 7:55 am

hey, can an existing sqlite db be included in your source and compile time? i want to populate data to the db before the person can actually use my app

SQLite Database

SQLite Database

Who is online