Welcome!

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

Reply
New Developer
georg
Posts: 86
Registered: ‎01-23-2009
My Device: Z10
My Carrier: klarmobil

ON DELETE CASCADE not working

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?

Please use plain text.
Developer
peter9477
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 10.0.10.672 reports itself as version "3.7.14.1" 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!
Please use plain text.
Developer
BBSJdev
Posts: 6,094
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. :smileyhappy:

 

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. :smileyhappy:

Developer of stokLocker, Sympatico and Super Sentences.
Please use plain text.