Can I use UNIQUE in the query() parameter?

by Ralf » Mon, 13 Apr 2009 13:36:24 GMT


Sponsored Links
 What Mark said, you probably meant DISTINCT.

For reference, the Sqlite3 doc on SELECT is here:
   http://www.sqlite.org/lang_select.html 

Also remember that you have the sqlite3 binary either in SDK/tools or
via adb shell. It can be handy to simulate your select manually once
before you code your query.

R/





--~--~---------~--~----~------------~-------~--~----~



Other Threads

1. PV ColorConvert codec usage problem

Hi all
I use "ColorConvertBase* colorConverter = ColorConvert16::NewL();" in
CameraHardwareStub.cpp
It can work, but the video playback then result fail with following I/
O exception.
Anyone know the reason?? (It is wear since I think there is no
connection between them but after mark the code and the video comes
back normal....)

W/VideoView(  458): Unable to open content: 
content://media/external/video/media/1
W/VideoView(  458): java.io.IOException: setDataSource failed.:
status=0x80000000
W/VideoView(  458):     at android.media.MediaPlayer.setDataSource(Native
Method)
W/VideoView(  458):     at android.media.MediaPlayer.setDataSource
(MediaPlayer.java:603)
W/VideoView(  458):     at android.widget.VideoView.openVideo
(VideoView.java:191)
W/VideoView(  458):     at android.widget.VideoView.access$1600
(VideoView.java:48)
W/VideoView(  458):     at android.widget.VideoView$6.surfaceCreated
(VideoView.java:406)
W/VideoView(  458):     at android.view.SurfaceView.updateWindow
(SurfaceView.java:353)
W/VideoView(  458):     at android.view.SurfaceView.dispatchDraw
(SurfaceView.java:260)
W/VideoView(  458):     at android.view.ViewGroup.drawChild
(ViewGroup.java:1445)
W/VideoView(  458):     at android.view.ViewGroup.dispatchDraw
(ViewGroup.java:1211)
W/VideoView(  458):     at android.view.ViewGroup.drawChild
(ViewGroup.java:1445)
W/VideoView(  458):     at android.view.ViewGroup.dispatchDraw
(ViewGroup.java:1211)
W/VideoView(  458):     at android.view.ViewGroup.drawChild
(ViewGroup.java:1445)
W/VideoView(  458):     at android.view.ViewGroup.dispatchDraw
(ViewGroup.java:1211)
W/VideoView(  458):     at android.view.View.draw(View.java:5663)
W/VideoView(  458):     at android.widget.FrameLayout.draw
(FrameLayout.java:324)
W/VideoView(  458):     at com.android.internal.policy.impl.PhoneWindow
$DecorView.draw(PhoneWindow.java:1727)
W/VideoView(  458):     at android.view.ViewRoot.draw(ViewRoot.java:1178)
W/VideoView(  458):     at android.view.ViewRoot.performTraversals
(ViewRoot.java:1000)
W/VideoView(  458):     at android.view.ViewRoot.handleMessage
(ViewRoot.java:1436)
W/VideoView(  458):     at android.os.Handler.dispatchMessage
(Handler.java:99)
W/VideoView(  458):     at android.os.Looper.loop(Looper.java:123)
W/VideoView(  458):     at android.app.ActivityThread.main
(ActivityThread.java:3790)
W/VideoView(  458):     at java.lang.reflect.Method.invokeNative(Native
Method)
W/VideoView(  458):     at java.lang.reflect.Method.invoke(Method.java:
521)
W/VideoView(  458):     at com.android.internal.os.ZygoteInit
$MethodAndArgsCaller.run(ZygoteInit.java:745)
W/VideoView(  458):     at com.android.internal.os.ZygoteInit.main
(ZygoteInit.java:503)
W/VideoView(  458):     at dalvik.system.NativeStart.main(Native Method)
--~--~---------~--~----~------------~-------~--~----~

2. Looking for an example of using state with a custom control

I am writing a custom widget and would like to use   setState and the
like to handle the focus and pressed states. Is there any sample code
explaining how to do this?
--~--~---------~--~----~------------~-------~--~----~

3. Android File Upload (PHP)

4. GPS String hidden application

5. Why won't Intent pass along the extras

6. How to capture some/all of the log file from an application?

7. MediaRecorder Sound Quality?