Benches iPhone

5

iPhone SQLite UPDATE: is LIMIT supported

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I am not able to use the LIMIT keyword in a SQLite UPDATE query. Do people know if it's available, i.e., if SQLite was compiled with SQLITE
ENABLE_UPDATE_DELETELIMIT?

thanks

Tsachi

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    xnav

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    LIMIT works on OS X, are you asking about iPhone?

  2. 0

    Tsachi

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yes, I'm asking about iPhone.

  3. 0

    xnav

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Probably not. Also, it does not work in the Apple supplied SQLite, I forgot I was pointing to a library I built.

  4. 0

    Tsachi

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I wonder why Apple chose not to build with this symbol. Perhaps they could revisit the decision. I believe that for the iPhone, Apple may have optimized SQLite for the iPhone hardware, and so I would not want to build my own. Thanks, xnav.

  5. 0

    xnav

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Actually Apple is moving toward CoreData for the iPhone thus the SQL is invisible to the Cocoa developer.