[android-developers] About SQLite

[nunna narendra android developer]

when i am trying to fetch the data from local database it is not
working how can i solve this problem plz help me .

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

[android-developers] About sqlite

[eggerxu]

I already have a ms access database file with a big amount data(one
table with 10 rows). Now, i want to import it to sqlite.Any easy
methods?

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
Announcing the new Android 0.9 SDK beta!
http://android-developers.blogspot.com/2008/08/announcing-beta-release-of-android-sdk.html
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~--~~~~--~~--~--~---

[android-developers] About SQLite (query)

[daehoon]

Hi everyone.
I know db.query was written like below in Android sample.
I want to use other field instead of rowId witch is KEY_DATE,
but it's not worked as well.

public Cursor fetchNote(long rowId) throws SQLException {
Cursor mCursor =
mDb.query(true, DATABASE_TABLE, new String[]
{KEY_ROWID,
KEY_TITLE,  KEY_BODY, KEY_DATE}, KEY_ROWID +
"=" + rowId, null, null, null, null, null);

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~--~~~~--~~--~--~---

Re: [android-developers] About SQLite

[TreKing]

On Thu, Feb 23, 2012 at 9:08 PM, nunna narendra android developer <
nunnamca2...@gmail.com> wrote:

> when i am trying to fetch the data from local database it is not
> working how can i solve this problem plz help me .
>

http://catb.org/esr/faqs/smart-questions.html

-
TreKing  - Chicago
transit tracking app for Android-powered devices

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Re: [android-developers] About SQLite

[Jagruti Sangani]

local database means sqlite database you have created taht one or any other?
i have post below code it might be help  you.

-see code
below-

Sqlite3 use in android

 database creation***
SQLiteDatabase db;
db=openOrCreateDatabase("sip_db.db",SQLiteDatabase.CREATE_IF_NECESSARY,null);
 db.setVersion(1);
 db.setLocale(Locale.getDefault());
 db.setLockingEnabled(true);



* create table*
final String str ="CREATE TABLE history ("+ "id INTEGER PRIMARY KEY
AUTOINCREMENT,"+ "contact_num TEXT,"+ "call_time TEXT,”call_stime TEXT);";
db.execSQL(str);



** insert data **
String ins="INSERT INTO history (contact_num)values('9638095998')";
 db.execSQL(ins);


*** get all the data ***
Cursor cur = db.query("tbl_countries",
null, null, null, null, null, null);
 cur.moveToFirst();
 while (cur.isAfterLast() == false) {
 view.append("\n" + cur.getString(0)+"\t"+cur.getString(1));
cur.moveToNext();
 }
 cur.close();





On Fri, Feb 24, 2012 at 8:38 AM, nunna narendra android developer <
nunnamca2...@gmail.com> wrote:

> when i am trying to fetch the data from local database it is not
> working how can i solve this problem plz help me .
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to android-developers@googlegroups.com
> To unsubscribe from this group, send email to
> android-developers+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
>

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Re: [android-developers] About SQLite

[James Black]

Look at logcat and find the exception.
On Feb 24, 2012 5:40 PM, "nunna narendra android developer" <
nunnamca2...@gmail.com> wrote:

> when i am trying to fetch the data from local database it is not
> working how can i solve this problem plz help me .
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to android-developers@googlegroups.com
> To unsubscribe from this group, send email to
> android-developers+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

[android-developers] about sqlite and sql rownum

[Jose Luis Montes]

Hello!

I have been using rownum in sql to retrieve a limited set of records per
query. is there a way to use something like that in sqlite?

What i want is that when I do a query, only retrive 15 records of the table;
the first 15 records of the query (including the sort statement).

Do you have any clue about this?

Thanks in advance!

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Re: [android-developers] about sqlite and sql rownum

[Mark Murphy]

Jose Luis Montes wrote:
> Hello!
> 
> I have been using rownum in sql to retrieve a limited set of records per
> query. is there a way to use something like that in sqlite?

Look at the LIMIT clause of a SQL SELECT:

http://www.sqlite.org/syntaxdiagrams.html#select-stmt

-- 
Mark Murphy (a Commons Guy)
http://commonsware.com | http://github.com/commonsguy
http://commonsware.com/blog | http://twitter.com/commonsguy

Android Consulting: http://commonsware.com/consulting

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en