Community Questions & Answers

android.database.CursorWindowAllocationException: Cursor window allocation of 2048 kb failed. # Open Cursors=741 (# cursors opened by this proc=741) run time error in titanium app this error come when execution time of query or coming data isti too large

I want to display random strings from different tables within the same line/row to form a complete sentence. I can return one result per line but cant work out how to manipulate tableviews/rows to include different pieces of data on the same line. I have...

I'll try to be short. I have a database which I turn into a tableView with sections and rows. The rows are all mixed up. I need to retrieve a specific id that allows me to identify its primary key in the database on click. Using the rows position in...

Hi, The problem I have when running the instruction to install the database Titanium.Database.install not working properly. I put the database file on all sites but always installs the empty database. When I access one of the tables produces error table...

Hey there. Im building my first Titanium application for mobile. Its a very simple application where the idea more or less is to add the users information to a database and then return statistics based on all the user inputted data. Its only based on 3...

- Titanium SDK: 3.1.0.GA - Android Runtime: V8 - Target: Android - O.S: Windows 7 Hi, i want upload a string into my database that is in the folder resources/data, unfortunately it doesn't work, any suggestions? ~~~ var win =...

~~~ Ti.UI.setBackgroundColor('#fff'); var win=Ti.UI.createWindow({ backgroundColor:'#fff' }); var data=[]; var xhr=Ti.Network.createHTTPClient(); var url='http://example.com'; xhr.onload=function(){ var...

Hello there, I have a problem with installing a database; In the app. js i have the following code: ~~~ var db = Ti.Database.install('radar.db', 'radar'); db.close();In my resources folder there is a file/database called radar.db. in another .js...

hi everybody i want to show extract data from my sqlite database and show it in a list view but my code didn't work ~~~ var win = Ti.UI.createWindow( { layout:'vertical' }); //invoke a web service // create...

I have a venue map in my application. Accodring to the rules i can leave that venue map as it is. I am thinking of making it more advanced. I want to apply some concepts from near by places, means, for example if i have a list rooms in my list view and i...

Hi guys, I'm creating a database using Ti.Database. I'm trying to have an auto-increment column so that i can update values of the row or delete the row. When i try create the column, i encountered an error. Can anyone help me debug? And I wanted the...

Hi all i'm trying to parse data using json web service and poster it in emulator so i create a database like below but now i want to post up the data and i don't know how can someone help me please ~~~ var win = Ti.UI.createWindow( { ...

Hello everbody, I simply want to retrieve data from my database but somehow I can't read my data. Here's the code ~~~ this.getGameGUIList = function(){ var db = Titanium.Database.open('longomatch'); var query = db.execute('SELECT name FROM gamegui...

Has anyone gotten this to work? http://docs.appcelerator.com/cloud/latest/#!/guide/atomic_increment I'm assuming it may just be my syntax. Here is what I have tried so far. ~~~ Cloud.Objects.update({ classname: 'someclass', id: someid, fields:...

Hi Everyone iwant to know how to load data from the server and show those data in a listview ? thanks

This is driving me crazy. I dont even know if its a syntax problem or a titanium problem. I'm just trying to create a database with 2 values at columns. ~~~ var db = Ti.Database.open('users'); try { db.execute('CREATE TABLE IF NOT EXISTS...

Hi Developers , 1. My application based on feedback form submission,validation,show the final status and more... 2. In this app specifically I'm creating for iPad Device. 3. In this case i done with feedback page. and feedback data's are stored in the...

Hi Everyone, Every time I click on the tableview and trying to open a new tableview I'm getting this error message uncaught typeerror cannot call method 'open' of null Location: [58,27] detail.js Source:...

Currently I am creating the database via command db.Execute (), is fine for me, but do not know if it is better to create the file sqlite externally and install from within the application by db.install. 1. What are the advantages and disadvantages of...

I am calling a database file and pushing the results into a TableView. This is how I'm calling my code: ~~~ var db = Ti.Database.install('/categories.sqlite', 'list'); var rows1 = db.execute('SELECT DISTINCT cat FROM items'); while(rows1.isValidRow())...

Hi all, I am creating my first project that uses sqlite. I have had trouble creating the database last week and luckily help was found in this forum. After another long week of programming, I find myself stuck again. So I hope I am as lucky as last time....

I want to retrieve the last inserted record...now I am getting the first record ... and db.lastInsertRowId I cant seem to make return the singular record I want ... Any ideas ? ~~~ var SelectStroke = function(){ var db =...

I am trying to collect data from different modules and place the data when appropriate into my DB... you press the button and it sends this data fine to the module ... sort of ... if I comment out //SelectStroke(); it enters all the variable data...

Hi Everyone, I'm trying to figure out a way to get all of my list items to populate from the database I'm installing on a phones device. For example, if you were to click on "Rhode Island", in my next page createTableView your only getting one...

Hi, I need some help with titanium.datatabase.install. I'm having problem with database on iOS device. When I pass de app to device and try to run on, error appear with the next message: invalid database install path....

I use this code to execute SQL staments ~~~ function execute(_db, _sql, _params) { try { _db.execute(_sql, _params) } catch(e) { alert(JSON.stringify(e)); } } ~~~ but when I execute a wrong SQL command as...

Hi, I have to create few sql lite databases in my application. All db's must be stored in the resources not in default place. Problem is: How to save/open-read database in the resources folder? Do I have to create database by Ti.Database.open and then move...

When I execute a SQL stament that has a sintatx error as: ~~~ db.execute('insert into table(x,y,z) values (?,?,?)',[100,200]); ~~~ How I cant get the last error message or error code? Thanks :)

In my app, how to display a bargraph based on the datas from the db?, how to fetch datas from db to plot a bargraph?

Where in the SDK can I find the database files I generate... here is the code I'm using to generate... I can't find the DB so I don't know if the db is generated or not generated... I'm getting no errors ... ~~~ var db =...

Hi all, I am completely new to using local database on titanium project. I have read a lot in the last two days and i am giving up using the install method to install from a sqlite database i exported from SQLite Manager in Firefox. I have a deadline to...

hello experts, please I am trying to develop an android application with tianuim in this application I need to allow the user to move the database file sqlite from internal memory to the external memory (SD card) in extension. sql so that he can import it...

We are building a content managed app that downloads a lot of data as XML for the apps pages from a server... Would it lead to a better performance, to read the XML and store it in a database and then query the database for the relevant data, or just read...

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

Hello, Anybody have a idea how to insert,update,delete,view data from database using Alloy framework. is this any demo apps or code ? Thanks....

Hi guys, I need some help please. Is there any reason to why I'm getting the following error when I install my app on my iPhone, everything seems to be working fine on the simulator but on the actual device I receive the following error. Basically it's...

Hey, I'm trying to have a common class to make some database operations, so, I'm using prototype inheritance model, here's the code: ~~~ var Barrel = {} || Barrel; Barrel.DB = function () { this.conn = null; }; Barrel.DB.prototype.setConn = function...

Hello, iám searching a way where i can find the primary key of a existing e.g. phone number. My case: User save a contact with 2 phone numbers. One day later, there is a third phone number. How i can identify these phone numbers. In my app i need to...

Hi, Thanks in advanced.... I am new in Alloy Framework and i want a simple database connectivity in which insert name,add. delete record and edit record. Please Help me.....

hi all, i want to make an application in android using titanium connected to mysql database so, i want any tutorial to let me know how to make it using json,php and so on and what is easier using alloy or json and php.please anyone till me and if you have...

Hello, I want to just know that is there any hope to get database support in TIZEN soon or have to wait for next SDK release? Thank you.

I want to get the record from database to create map annotation , I can only success with 2 record with 2 column, if I add more column. It will have error that force to close ? What is wrong of this? PS. My database have 2 record with 5 column (latitude,...

How to force reinstall database every time open my app, with Alloy Framework?

Sorry for my stupid question , I am new to titanium. I want to insert the data into the online database. How can I do that? For example I have data A, how can I pass this value to php so that the INSERT value will become data A ?I hope there are some...

I am new here and I have a database for my website in my server and I want to know How can I connectmy android mobile app to mysql database on the server ? Thanks

How to force reinstall database every time open my app, with Alloy Framework?

My problem with this is that the documentation ([Alloy Migrationst](http://docs.appcelerator.com/titanium/3.0/#!/guide/Alloy_Sync_Adapters_and_Migrations)) says that it is possible to choose which migration to use by adding the timestamp to the...

Hi, Can anyone have an example to use database migration. For example the first version looks like this ~~~ config: { "columns": { "name":"string", "contact":"string" }, "adapter":...

Hi guys, As the title says. Thanks!

Just started using alloy for a project that occasionally needs to insert 1,000s of records into an SQLite table. Previously when I've needed to do this I've used transactions which speeds up the database write time considerably but I can't find any...