Community Questions & Answers

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

Infinite loop in SQLite - why?

I have a simple SQL statement in my iOS app, for SQLite, but it always goes into an infinite loop: genreSQL_TEST_ONLY = "select count(*) AS Counter from Movies_Genres"; rsTest = db.execute(genreSQL_TEST_ONLY); while...

Load data using HTTPClient or SQLite?

I've read [here](http://docs.appcelerator.com/titanium/latest/#!/api/Titanium.Network.HTTPClient) that HTTPClient is intended for a single request. Currently I'm using HTTPClient for multiple requests (getting several xml files from a server to create...

Fetch data from sql, Alloy

Well i just wanted to fetch data from persons table without using Query This is what im doing right now but i have no idea where i am wrong ~~~ function showPerson(event) { var selectedPerson = event.source; var recoverDatabase =...

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