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?
Imported from the Apple Support Forums via the Wayback Machine 🔗
LIMIT works on OS X, are you asking about iPhone?
0
Tsachi·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Yes, I'm asking about iPhone.
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.
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.
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.