mercredi 4 mai 2016

SQLite in Android How to update a select set?

    UPDATE event
SET EVENT_PROCESS = 4
WHERE
    LEARNING_EVENT_GROUP_ID IN (
        SELECT DISTINCT
            LEARNING_EVENT_GROUP_ID
        FROM
            event
        WHERE
            EVENT_TYPE = 1
        AND EVENT_PROCESS != 4
        AND (
            (
                (
                    EVENT_SEQUENCE = 1
                    OR EVENT_SEQUENCE = 2
                )
                AND 1463681631460 >= (
                    EVENT_EXPECTED_FINISHED_DATE + 86400000
                )
            )
            OR 1463681631460 >= (
                EVENT_EXPECTED_FINISHED_DATE + 172800000
            )
        )
    )

Here is my sql, I want to update EVENT_PROCESS to 4 depends on the select set,but it didn't work on my project,without error. If SQLite does not support like this,What am I supposed to do?

Aucun commentaire:

Enregistrer un commentaire