You're assuming that the ordering is numeric, when the column is
likely being interpreted as character data. You have to work at it a
bit to get Sqlite to order numerically -- I don't offhand recall the
tricks, but they're probably out there if you Google them. (Try
ORDER BY (sigma + 0).)
(It
Thanks Dan,
That is actually what I was thinking, but wanted to check here as
well. I will test with your suggestion tomorrow.
On Dec 13, 5:46 pm, DanH danhi...@ieee.org wrote:
You're assuming that the ordering is numeric, when the column is
likely being interpreted as character data. You
Yeah, remember that Sqlite doesn't really pay any attention to the
declared column types, but types each individual data cell
separately. You have to use care on insertion (avoid quotes for
numerics, eg) to get the data type you expect, or else you have to
arrange your queries to coerce the data
Which explains the -1 I get since I don't move the cursor at all to
begin with.
Thanks to all, I think this is exactly what my problem is and you have
all
given me really excellent information to fix it. Much appreciated.
On Dec 9, 12:04 pm, Kostya Vasilyev kmans...@gmail.com wrote:
No need to
Ok thanks very much guys I will look into it. I did find a posting
that seemed
to be along the lines but I will follow your advice first:
http://stackoverflow.com/questions/41233/java-and-sqlite
On Oct 6, 5:39 pm, Mark Murphy mmur...@commonsware.com wrote:
On Wed, Oct 6, 2010 at 5:35 PM,
On May 24, 7:41 am, Mark Murphy mmur...@commonsware.com wrote:
schwiz wrote:
So I just watched the talk at Google I/O where they showed how to use
sqlite3in ADB to help debug your database. I didn't know you could
do that way cool. So I was doing it on my nexus which is rooted and
it
Hmm it should work as I've been using it for some time in 2.2. Try to su
root first.
On Sun, Jun 27, 2010 at 11:50 PM, Vincent Tsao caojunvinc...@gmail.comwrote:
On May 24, 7:41 am, Mark Murphy mmur...@commonsware.com wrote:
schwiz wrote:
So I just watched the talk at Google I/O where
Hi Mariano,
I use close only once. The DB object is held in an Android service.
When the service stops the DB object is closed. I think you should not
have two opened DB objects at the same time.
Mirko
On 23 Okt., 22:09, Mariano Kamp mariano.k...@gmail.com wrote:
Hey Mirko,
thank you very
Thanks.
You're right. I tried close on the readOnlyDB and it closed both database
object ;-(
Still not sure how to deal with the readlock then? ;-(
2009/10/27 mirko mirkocze...@googlemail.com
Hi Mariano,
I use close only once. The DB object is held in an Android service.
When the service
Hi Mariano,
I had the same problems with my app. After reading a little bit on the
SQLite Website my understanding was that locking is done with process
(thread) locks. So there are many reader treads possible, but only one
writer thread. For this reason your SQLiteDatabase object needs to be
a
Hey Mirko,
thank you very much for taking the time to give me such a detailed and
easy to understand answer.
I think that I already have implemented my code the way you describe as I
originally started out with the Notepad
Perfect!! Thanks Marcus!
On Dec 31 2008, 12:59 am, visionera gmbh visionera_andro...@yahoo.de
wrote:
hi michael,
try this
SELECT name FROM sqlite_master WHERE type = table
bye
marcus
Von: michael m mgmait...@gmail.com
An: Android Developers
I tried taking the /system/bin/sqlite3 from the M5 version and
installing it into 0.9_beta but it didn't work. I ran the M5-rc15
emulator with -wipe-data, used adb pull to get the program, ran the
0.9_beta emulator with -wipe-data, ran adb remount to make /system
read write, used adb push to
2008/9/11 Ed Burnette [EMAIL PROTECTED]
I tried taking the /system/bin/sqlite3 from the M5 version and
installing it into 0.9_beta but it didn't work. I ran the M5-rc15
emulator with -wipe-data, used adb pull to get the program, ran the
0.9_beta emulator with -wipe-data, ran adb remount to
use the path:
/data/data/com.android.providers.settings/databases/
adb pull /data/data/com.android.providers.settings/databases/settings.db
settings.db
---
On Aug 25, 7:18 am, Anjan [EMAIL PROTECTED] wrote:
I run command
adb pull
I run command
adb pull
/data/data/com.google.android.providers.settings/databases/settings.db
C:\Android
i get error
remote object /data/data/com.google.android.providers.settings/
databases/settings.db does not exists...
On Aug 21, 3:51 pm, Mark Murphy [EMAIL PROTECTED] wrote:
shan
Thanks for the information..it worked.. another hurdle
1. I download system.db to local
2. edit to add entry (99,'http_proxy','proxy:');
3. Upload system.db back to device.
but i could not run the browser successfully (i am expecting
http://www.google.com/ to show up on device).
i also
Thanks all, the browser is working behind the proxy, seems related
with multiple SDKs on the same machine messed up the proxy configs of
the emulator(a guess).
Refer :
http://groups.google.com/group/android-developers/browse_thread/thread/5bf421494daf6784/cfcc4ad406134b14#cfcc4ad406134b14
If
I need to access the system table in data/data/
com.android.providers.settings/databases/settings.db in the adb shell.
I had earlier did this in the m5 to insert the 'http_proxy' field, but
now i can't invoke sqlite3 from the adb shell.
Please assist.
On Aug 21, 1:30 am, Justin (Google Employee)
shan wrote:
I need to access the system table in data/data/
com.android.providers.settings/databases/settings.db in the adb shell.
I had earlier did this in the m5 to insert the 'http_proxy' field, but
now i can't invoke sqlite3 from the adb shell.
Please assist.
Use adb pull (or the
OK. it's really pretty annoying you forgot sqlite3 on windows. t'm
glad i have a virtual linux box, so i can use the linux sdk also. but
how am i supposed to access a database if the sqlite3 tool is now an
external tool, which is not available in the adb shell? which file
shall i open?
on m5 i
I too wasted time trying to figure out why sqlite3 was not found
using the Windows 0.9 Beta SDK. When's the next SDK release?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this
http://www.google.com/search?hl=enq=sqlite+windowsbtnG=Google+Search
Cheers,
Justin
Android Team @ Google
On Aug 20, 12:14 pm, Bob [EMAIL PROTECTED] wrote:
I too wasted time trying to figure out whysqlite3was not found
using the Windows 0.9 Beta SDK. When's the next SDK release?
You cab use sqlite3 from the sdk tools directory directly...
On Tue, Aug 19, 2008 at 2:26 PM, Brad Larson [EMAIL PROTECTED] wrote:
Has the sqlite3 command line tool been removed from 0.9beta? I
haven't been able to find anything in the documentation, but I do get
sqlite3: not found from the
Thank you for the reply Magha. I can't find anything related to
sqlite in the tools directory. Could you please provide more
information?
Thanks!
-Brad
On Aug 19, 4:52 pm, Megha Joshi [EMAIL PROTECTED] wrote:
You cab use sqlite3 from the sdk tools directory directly...
On Tue, Aug 19,
Which OS are you using?
On Tue, Aug 19, 2008 at 3:15 PM, Brad Larson [EMAIL PROTECTED] wrote:
Thank you for the reply Magha. I can't find anything related to
sqlite in the tools directory. Could you please provide more
information?
Thanks!
-Brad
On Aug 19, 4:52 pm, Megha Joshi [EMAIL
I'm using windows, although I have access to a linux box if that is
needed
On Aug 19, 5:27 pm, Megha Joshi [EMAIL PROTECTED] wrote:
Which OS are you using?
On Tue, Aug 19, 2008 at 3:15 PM, Brad Larson [EMAIL PROTECTED] wrote:
Thank you for the reply Magha. I can't find anything related to
It seems windows sdk is missing tools/sqlite3 which will be fixed in the
next release. For the time being if you use Linux, you will find
tools/sqlite3.
On Tue, Aug 19, 2008 at 7:31 PM, Brad Larson [EMAIL PROTECTED] wrote:
I'm using windows, although I have access to a linux box if that is
28 matches
Mail list logo