Appcelerator-Q-A-banner

Community Questions & Answers

Sqlite + Json

Dears, good morning, I'm having trouble in sqlite, how do I see tables in my android by titanium, and I also created a table to download json information but I can not tell if the error is in this insert or the select someone could help me. the database...

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?

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