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

Java Development

Reply
Developer
Posts: 141
Registered: ‎07-13-2011
My Device: BB Bold
My Carrier: Vodafone

Re: Sqlite Multiple insert

Try and run your program in debug mode and print the query into console.

Using sqliteDatabase browser try to run it.....u may find some error in sql

Developer
Posts: 467
Registered: ‎07-16-2009
My Device: Z10 LE
My Carrier: Vodafone NL

Re: Sqlite Multiple insert

My appologize - SQlite allow SELECT without FROM

Developer
Posts: 141
Registered: ‎07-13-2011
My Device: BB Bold
My Carrier: Vodafone

Re: Sqlite Multiple insert

There is nothing wrong in SQL..... I think it is when it  tries to read from the file.

 

Try to run and print sql in debug mode..and compare with ur original sql

Developer
Posts: 467
Registered: ‎07-16-2009
My Device: Z10 LE
My Carrier: Vodafone NL

Re: Sqlite Multiple insert

According to this one:

http://www.blackberry.com/developers/docs/6.0.0api/net/rim/device/api/database/Database.html#createS...

 

You will get error if db is closed. Also previous statement should be explicity closed after execution.