Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Native Development

New Developer
Posts: 92
Registered: ‎01-23-2009
My Device: Z10
My Carrier: klarmobil


I have a problem with "ON DELETE CASCADE". Does somebody know which version of SQLite BlackBerry 10 has? Or has somebody other (more successful) experiences?

Posts: 6,473
Registered: ‎12-08-2010
My Device: PlayBook, Z10
My Carrier: none

Re: ON DELETE CASCADE not working

The /usr/lib/libsqlite3.so in reports itself as version "" using the sqlite3_libversion() routine.

Peter Hansen -- (BB10 and dev-related blog posts at http://peterhansen.ca.)
Author of White Noise and Battery Guru for BB10 and for PlayBook | Get more from your battery!
Posts: 6,152
Registered: ‎07-05-2012
My Device: Playbook, Dev Alpha C, Z10 LE, Z30
My Carrier: Orange

Re: ON DELETE CASCADE not working

[ Edited ]

I can report the opposite from what you wanted, less successful, it's not supported.


You can create your tables with it anyway then when it becomes available hopefully it will speed up delete transactions with only a quick rebuild and you won't have to deal with migrating customer databases.


Anyway this is what I'm hoping as this is what I've done. Smiley Happy


Or alternatively switch to one of the other database drivers.


If you've been helped click on Like Button, if you've been saved buy the app. Smiley Happy

Developer of stokLocker, Sympatico and Super Sentences.