I keep trying to use wildcards in a search in an android app, and keep running into errors. I'm performing a search on my application using the string below: Cursor c_name = b.query("namedrxns", new String[] { "_id", "name" }, "name LIKE %?%", new String[] { query }, null, null, null); when I use name LIKE %?% or name=...
I was storing an image in a sqlite table as blob data and displaying it using the following code: self.myImage.image = [[[UIImage alloc] initWithData:recipe.image] autorelease]; I'm now using the image file name in the sqlite fields instead and storing the image on the filesystem. what would the code be to display it that way? I'm havi...
I want to build an iphone app with data pre-filled sqlite db. But how to fill data in the beginning comes to be a small problem. My partner and I may both need to access the db and edit data. I thought to build a web interface to edit the data, but my host service only provide PHP+MYSQL solution for me, then if I put the data in MYSQL...
Hi everyone, Currently I am developing an iPhone app with sqlite database, this database just has only one table with many records. And my server is using MySQL database. I would like to ask: Can I send many records from sqlite database to MySQL database to update the table in MySQL database. Because I think I can do update with just o...
How would i translate these mysql queries to work with sqlite3?: self.find(:first, :conditions => ['concat(first_name, \' \', middle_names, \' \', last_name) = ?', name]) self.find(:all, :conditions => ['(concat(first_name, \' \', last_name) LIKE ?) OR (concat(first_name, \' \', middle_names, \' \', last_name) LIKE ?)', "%#{name}%", "%...
Hi again all, I'm still trying to implement a search function into my Android app. So far it's going ok, although currently the search can only query one table and display the results for this table (its a ListView using SimpleCursorAdapter). What I want is to be able to search multiple tables, but I'm not sure how to get this all into...
android code to delete the database from the application? ...
Hello. I have an SQLite database in the first version of my iPhone application (which is on the app store). Now I want to roll out the second version of the application, which also has an SQLite db in it. I understood that upon update, the SQLite database is removed and then the new one is added. I don't want this to happen, since that...
hai i a'm trying to create a sqlite database programmatically at the run time. can anybody say how to create it in iphone sdk. thanks in advance ...
EDIT: I found the problem, which was totally unrelated to the below. It was due to me doing a bitwise comparison that I failed to mention below - I thought it wasn't relevant - I removed this (and found an alternative solution) and my query now executes in < 1 second on device. I'm currently working on my first iPhone application which ...
I want a debug function to do this, but I'm unaware of whether one already exists. Going through and using 'drop table' for each of my tables will be a pain. Help appreciated. ...
var imageData:ByteArray = new ByteArray(); var headshotStatement:SQLStatement = new SQLStatement(); headshotStatement.sqlConnection = dbConnection; var headshotStr:String = "SELECT headshot FROM ac_images WHERE id = " + idx; headshotStatement.text = headshotStr; headshotStatement.execute(); Error references the final line in this block...
We've recently had the need to add columns to a few of our existing SQLite database tables. This can be done with ALTER TABLE ADD COLUMN. Of course, if the table has already been altered, we want to leave it alone. Unfortunately, SQLite doesn't support an IF NOT EXISTS clause on ALTER TABLE. Our current workaround is to execute the A...
Hello everyone, This is my first application with a database. I'm using SQLite and Visual Studio. I have the database added, but how do I store and retrieve information from it? I'm using System.Data.SQLite as the .NET wrapper. The wrapper obviously provides me with methods to create connections and execute queries, but is there an ea...
How would I do the equivalent of this statement in Core Data? Basically I want to get a list of the 10 most occurrences of foo along w/ how many times it occurs. Basically I'm recording all of my users searches as individual entries in Core Data. I want to be able to select their 10 most searched items and display them in order starting...
I have a sqlite3 database with one table called orig: CREATE TABLE orig (sdate date, stime integer, orbnum integer); What I want to do is select the first date/time for each orbnum. The only problem is that stime holds the time as a very awkward integer. Assuming a six-digit number, the first two digits show the hour, the 3./4. show ...
Does sql query degrade the performance in iphone App? Join is a good or bad for the iphone app performance. ...
I consider to use SQLite in a desktop application to persist my model. I plan to load all data to model classes when the user opens a project and write it again when the user saves it. I will write all data and not just the delta that changed (since it is hard for me to tell). The data may contain thousands of rows which I will need to ...
First, a bit of my background. I have been working on large web systems for over a decade, Android is something I have been looking at for the past two months; as you can imagine, the gap is quite wide :) Looking at Android's Security and Permissions and Data Storage part of documentation, talking directly to developers, reading books a...
Hey guys!! I have database table with the columns {Name, Time (UTC format) , Latitude, Longitude} I display the table using a ListActivity with a SimpleCursorAdapter. I would like that the column Time show the time in a human readable format (13-07-2010 10:40) rather than in UTC format (18190109089). How can I specify that the values...