Appcelerator-Q-A-banner

Community Questions & Answers

SQLITE Wrapper with array?

Hello, Im trying to write a Sqlite database wrapper for my project, and everything seems to be fine- until now. (For iPhone, SDK 3.5.1) I really like the approach I use on our backend, where we bind each value before we put it in to the db-table. Since...

Display Graph in Titanium iOS

In my app, i need to display the status of the feedback by a Graph(chart) view. Is webview is needed? I tried RGraph framework, which is showing errors for me, how to use this framework? Are they're anyother ways their to achieve this?Can anyone pls,...

force reinstall of sqlite database

i have this code thats supposed to force a reinstall of an sqlite db on updates but its not working - any ideas ? (ios) ~~~ var f = Ti.Filesystem.getFile( Ti.Filesystem.applicationSupportDirectory+'/database', 'phonenew.sqlite'); //If it's there, delete...

Database value change did not reflect in App

I created a sqlite db using a Firefox plugin - SQLite Manager. I am able to select from the db and display the values in the App. When I modified the values in db thru SQLite Manager, such as changing the value in a VARCHAR, the newly built version does...

ALTER COMMAND

Hi, I need to a new column in existing table. Please suggest idea. If you already use Alter Command . Please share the sample code with me. Thanks in Advance

Table not found in classic project.

I have made a table using sqlitebrowser and copied it into resources folder of my project. But my insert query is giving me this error: "[ERROR] : TiDB: (KrollRuntimeThread) [5,46023] Error executing sql: no such table: barcode (code 1): , while...

SQLITE:select query like expression

Application type:mobile,titanium studio:3.3.0,titanium sdk:3.3.0,OSX:Mac osx. How can I select the exact value from the database select query: ~~~ var resultset = db.execute('SELECT * FROM members WHERE LOWER(bloodgroup) like "%' + win.bloodgroup +...

import sql file in titanium/alloy

I have sqlite dump file with many lines of code. It's very hardly do it like this: db.execute(every_line_of_code); Is it possible to import this file into database something like this: Ti.db.importSql('file.sql') or Ti.db.loadFromFile('file.sql')

import sql file in titanium/alloy

I have sqlite dump file with many lines of code. It's very hardly do it like this: db.execute(every_line_of_code); Is it possible to import this file into database something like this: Ti.db.importSql('file.sql') or Ti.db.loadFromFile('file.sql')

Sqlite Issue

i store decimals in tb using datatype (decimal,float or real) and work it, but when i try to store 23.80, is not storing the 0. what can i do?

Open Pdf File in android app

Hi all, I want to create an app in which i will store pdf file as blob in sqlite database .And the problem is to retrieve that pdf file within my app is it possible?if yes then please provide me with some link or pseudo code? If no then wht shud u suggest...

Best way to save table order after sorting?

I am SQLite Db with classic titanium. I have a favorites sections, that I want to allow sorting. Whats is the best way to save the order after the sorting a table? I was thinking about adding a column in the DB for the order, but not sure how I could save...

Showing 1-50 of 882 1 2 3 4 5 618