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
sharath_moblie
Posts: 104
Registered: ‎09-25-2013
My Device: BB 10
My Carrier: BB 10

check if table exist/created already in BB 10 cascades

Hi friends,

 

const QString query("CREATE TABLE IF NOT EXISTS push (seqnum INTEGER PRIMARY KEY AUTOINCREMENT, pushdate TEXT, type TEXT, pushtime TEXT,alertId TEXT, extension TEXT, content BLOB, unread INTEGER);");

 

now how can i check if table created/existed already? Is there any query for that?

help me, Thanks

Please use plain text.
Developer
simon_hain
Posts: 16,001
Registered: ‎07-29-2008
My Device: Z10 LE
My Carrier: O2 Germany

Re: check if table exist/created already in BB 10 cascades

why do you want to do that? the command creates the table only if it is not already there.
----------------------------------------------------------
feel free to press the like button on the right side to thank the user that helped you.
please mark posts as solved if you found a solution.
@SimonHain on twitter
Please use plain text.
New Developer
sharath_moblie
Posts: 104
Registered: ‎09-25-2013
My Device: BB 10
My Carrier: BB 10

Re: check if table exist/created already in BB 10 cascades

each time I am droping the table when closing the app and on reopen i want to to something if table doees not exits

Please use plain text.
Retired
PBernhardt
Posts: 749
Registered: ‎12-16-2008
My Device: BlackBerry Z30
My Carrier: Bell

Re: check if table exist/created already in BB 10 cascades

There are a couple of solutions here: http://stackoverflow.com/questions/1601151/how-do-i-check-in-sqlite-whether-a-table-exists

 

I haven't tried it myself though, so I can't say how well they will work. Looks reasonable though.

Paul Bernhardt
Application Development Consultant
BlackBerry
@PBernhardt

Did this answer your question? Please accept this post as the solution.
Found a bug? Report it to the Developer Issue Tracker
Please use plain text.