Community Questions & Answers

SQLite and BLOBs

Hi there, Have a question. I'm working with an embedded sqllite database with stored images (I know that a common practice says to store filepaths in database and the image itself on the filesystem). Long story short, I HAVE to get blobs (images) from...

[ERROR] invalid SQL statement. Error Domain=com.plausiblelabs.pldatabase Code=3 "An error occured parsing the provided SQL state

Thank you for reading my question. My question is regarding Appcelerator-Titanium-Smartphone-App-Development-Cookbook Chapter 2 – Recipe 7. Book: Appcelerator-Titanium-Smartphone-App-Development-Cookbook Chapter: Recipe 7 – Chapter 2. Background:...

The Cost of SQLLite

Hey guys, I was wondering if you knew what the performance cost of SQLLite was? I am attempting to get our Android version of our app working as fast as possible, and I realized part of the issue may be the fact that I am generating lists and each time...

Executing of SQL from file

Hi, I try create sql table. Here my code: ~~~ var sqlfile = Ti.Filesystem.getFile( Ti.Filesystem.resourcesDirectory,'web/data/table.sql'); var sql = sqlfile.read(); conn.execute(sql); ~~~ In this file is: ~~~ CREATE TABLE IF NOT EXISTS users ( id INTEGER...

Can't insert TEXT into SQLITE table

I'm having a heck of a time inserting a string into a SQLLITE table in my iPhone app. I've tried several different methods, and always the app just crashes and exits with no error msg in the log. I'm very much a noob, can someone please help me out, I feel...

Showing 1-17 of 17