Community Questions & Answers

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

sqlite troubles

hi im little stucked with a script in db where i select a number: ~~~ SELECT ('%.2f', FPRE_VALOR) as value FROM FIJACION_PRECIO"+ WHERE FPRE_ID ="+id ~~~ this fuction is like toFixed() in javascript for format a number in 2 decimals example:...

sqlite real issue

~~~ CREATE TABLE IF NOT EXISTS FIJACION_PRECIO( FPRE_VALUE REAL ); ~~~ i want store decimals numbers but dont allow me with the following case: '4.00' or 4.00 in field fpre_value but not storing the 2 zeros after dot what im doing wrong?

Save on db with Alloy

Titanium Studio, build: 3.3.0.201407100905 Mac OSX Mavericks 10.9.5 Titanium SDK 3.3.0 Platform: Android Device with 4.3.1, iOS Device (versions 7 and 8) I've got a problem in my controller when I try to save on internal sqlite db. I create the model...

SQLite update query

Hello all. I am new to Titanium Alloy development but not new to Javascript. I have been trying to work with SQLite in a Titanium Alloy application. The SQLite insert and create DB queries work fine. However my update query is not working at all....

opening sqlite db on external storage

Hi experts, Does Titanium really support opening sqlite database on the external storage ? Very simple code as below makes 'File appdata:///test.db contains a path separator' run time error. ~~~ hdbImp = Ti.Database.open(...

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