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. RemoteService and RemoteServiceBinding - Different package (apk) - Problem

Hi!!

I have made two different packages for API Demo sample -
RemoteService in Service app package (Service.apk)
RemoteServiceBinding in Client app package(Client.apk)
(two different apk and two different projects in eclipse)

The Service app offer services which Client app binds to and utilizes.
The Service app gets started during BOOT COMPLETE.

This model works great when I do a full source build(without eclipse).

But when I make them under Eclipse, and my Client app invokes
registerCallback method on Service app interface, the
IRemoteServiceCallback instance(interface implemented in Client app)
is received null in Service app.

I have confirmed that mCallback (object passed) is not null.

I couldn't observe any error in logs. What could be the problem?

Thanks in advance
Ash

#####################
Client app - code
#####################
private IRemoteServiceCallback mCallback = new
IRemoteServiceCallback.Stub() {
        /**
         * This is called by the remote service regularly to tell us
about
         * new values.  Note that IPC calls are dispatched through a
thread
         * pool running in each process, so the code executing here
will
         * NOT be running in our main thread like most other things --
so,
         * to update the UI, we need to use a Handler to hop over
there.
         */
        public void valueChanged(int value) {
            mHandler.sendMessage(mHandler.obtainMessage(BUMP_MSG,
value, 0));
        }
    };

 private ServiceConnection mConnection = new ServiceConnection() {
        public void onServiceConnected(ComponentName className,
                IBinder service) {
            // This is called when the connection with the service has
been
            // established, giving us the service object we can use to
            // interact with the service.  We are communicating with
our
            // service through an IDL interface, so get a client-side
            // representation of that from the raw service object.
            mService = IRemoteService.Stub.asInterface(service);
            mKillButton.setEnabled(true);
            mCallbackText.setText("Attached.");

            // We want to monitor the service for as long as we are
            // connected to it.
            try {
                mService.registerCallback(mCallback);
            } catch (RemoteException e) {
                // In this case the service has crashed before we
could even
                // do anything with it; we can count on soon being
                // disconnected (and then reconnected if it can be
restarted)
                // so there is no need to do anything here.
            }

######################
Service app code
######################
private final IRemoteService.Stub mBinder = new IRemoteService.Stub()
{
        public void registerCallback(IRemoteServiceCallback cb) {
            if (cb != null) mCallbacks.register(cb);
        }
        public void unregisterCallback(IRemoteServiceCallback cb) {
            if (cb != null) mCallbacks.unregister(cb);
        }
    };

####################
PROBLEM---------
---------------------------------
The registerCallback gets invoked on Service app code but parameter
'cb' is null
#####################

-- 

2. Updating SDK through AVD

Is there a proper fix for this

      Unzip failed: Cannot run program "chmod": java.io.IOException:
error=24, Too many open files

Problem yet? I have SDK 2.0 installed, now trying to add 1.5 through
the AVD and get the above warning.

I tried the workarounds, running it from the commandline, forcing http
instead of https but nothing works. I even tried moving the 2.0 out of
the platforms directory but that doesn't help either. I can download
the package, it installs to about 60% or so and then the error. Does
anyone have the direct url to the SDK's so I can at least unzip /
install it myself?

Running this on Fedora 8 as root and ultimit is unlimited.

Cheers,

Lew

-- 

3. loop sound

4. R file not generating automatically

5. Tasks Running in Androi

6. How to exclude com.android.internal.R from my apk

7. Is there any way to but an Object to transfer between some Activities without Serialization