Community Questions & Answers

How to attach SQLite databases?

I am trying to create a separate db to save favorites, so that when I update the main database that it the favorites are not written over. Also, I want to save favorites and notes to cloud. I have been trying the following along with several variations...

Upgrade sqlite database

Hello, I have an alloy application with a preloaded sqlite database inside. Is there a way to upgrade this database with a newer one when the user who has installed my app is online? Do i have to update the whole app (uploading a new version on play...

sqlite possible to call row by variable?

wondering if its possible to use a variable string to declare a row in an sqlite statement. for example ~~~ ('UPDATE measurements SET row1=?', row1.value); ~~~ so row1 would be a value saved from a labels text, and it also refers to the row name in my...

Alloy SQLite DB

Hello, I am just trying to select only one field from table. Below code works and it returns whole row. ~~~ var subscribers = Alloy.Collections.subscriber; subscribers.fetch({query:'SELECT * from subscriber where id="' + args.id +...

SQL Alloy translation

~~~This seems simple but... where titledb is the column name. Classic: var db = Ti.Database.open('myDB'); var grabData = db.execute('SELECT titledb FROM myTableInDb'); To Alloy sync adpater: var library =...

Autocomplete with AJAX?

Hi guys, I googled a bit around and I saw that jquery was supported in Titanium Mobile in the past and of course still is inside a Webview, which would also work for my problem, but maybe there is another solution for this task: I have a database which...

invalid number of rows error at TableView

Hi Guys, I m facing strange problem .I m using Titanium 3.2.3 and developing for ios 7 .I have sqlite database. I m taking photo and storing path to sqlite database. after that I m adding this photo to tableview.But the problem is When I load app first...

Sqlite select send parameter

I m working Titanium 3.2.3 and developing for ios 7.My problem is ~~~ // its working var query=db.execute("Select * from photos order by tarih desc limit 5 offset 0"); // When I do this its cannot work .Where I missing? var...

SQLite Select all record performance

I m using Titanium 3.2.3 SDK and developing for ios 7 .My apps taking picture storing image path at sqlite and showing tableview.but there is a performance problem with tableview. Because each image 1.5 MB and in one screen 2-3 image. its maybe 100-1000...

database locked

Hi all... Does anybody knows how do I solve this problem ? Error occurred calling next on a PLSqliteResultSet. SQLite error: 'database is locked' for 'UPDATE tb_item SET qt = 2, buy = 0, preco_U = '8,00', totalPrice = '16,00' WHERE ds_item = 'Dental cream''

Titanium SQLite select pefromance

Hi Everyone I m using latest sdk and studio developing for ios and my question is I m taking photo with iphone and storing sqlite database and add table all photos .But select is very slow. each image 1.5 MB apporixametly. How can speed up this .I tried...

SQLite select timestamp gives me wrong value

I have an SQLite database running locally on the iPhone simulator. On of the tables in the database has a timestamp column called `updated`. I am using the application SQLite Pro to examine the contents of the database. I can see clearly that the column...

How to download data from remote database.

Hi, I have a webpage, and in it, a database. I want to download some data from my webpage to an app. Is it possible? How can I achieve this? What im trying to do, is download the information, and populate a TableView with it, I know how to populate it with...

Using databases with CommonJS

Hi, I have a CommonJS module for a text area where the user can input the name of a task. In my app, I am wanting to have multiple windows for different task groups(such as art or design) that include this text area. However, I am wanting to save each...

Database is locaed

IN my iphone app am using sqllite db and i can perform select,insert query but I cant perform delete ,each time I perform delete an row by using where condition am getting this error message = "Error occurred calling next on a PLSqliteResultSet....

login screen

app type:mobile,android,titanium sdk:3.2.2.GA Hi, I created a login screen which works fine,but for only one username and one password.I want to create a login screen for more users and i don't know how to modify my code.I need also to find a way to...

sql command help

Hi, I want to get the last value from a table's column if i select a value from a picker,but i don't know how to adapt the code for titanium: ~~~ var a = db.execute('SELECT serie_contor FROM clienti where nume_prenume =?',picker2.getSelectedRow(0).title...

Control Backups to iCloud with Alloy

If there is an Alloy Model/Collection being saved to SQLite what is the best practice to disable backups to iCloud? Essentially I'd like to do something like this below. This may be very trivial but if anyone has done this before please let me know....

How to apply index on models in Alloy

Hi Folks, I searched on internet but couldn't get a way to add and index on Models in Alloy. I having a large set of records (10K+) in one of the table, which is properly structured, but when I access the db using collection.fetch(), it becomes slow. It...

picker help

app type:mobile,android,titanium sdk:3.2.2.GA Hello, I have a problem with my android application: I have more windows,in one window,i insert data into a sqlite database table,in an another window i have a picker which returns the data from a column of...

Array and SQL

Hi everyone. I'm trying to create an app where you get data from SQLite database and with that data you create new imageViews, labels and then adds event listeners to those new created items to send you to another window. I was able to create these views...

Showing 1-50 of 808 1 2 3 4 5 617