I am new to the iPhone and have a problem with SQLite... I want to execute a query which contains multiple where conditions like: UPDATE tablename SET field1 = ?, field2=? WHERE Itemid=? AND field1=? AND field2=? Is this is the right way to do the update? If possible what would be the code to execute the query? ...
Hi! I've been asking lately about Obj-C circular buffer objects, assuming that would be the better way to control tons of data on a UITableView. I have found a solution as far as Circular buffer objects go, but I've been wondering about maybe a better, faster and much more memory efficient solution: Calling my SQLite DB to update the U...
I have an android list activity that is backed by a database cursor through a SimpleCursorAdapter. When the items are clicked, a flag field in the coresponding row in the database is toggled and the view in the list needs to be updated. The problem is, when the view that's updated goes off screen and is recycled, the old value is ...
Hi I'm doing an RSS reader application but I want the information that shows the iphone on a table can be saved in a DB or a file. Please can someone help me? ...
Hello, I am trying to build a text file which is a combination of predefined strings and variable values which I would like to take from a pre-existing sqlite database. The general format of each line of the text file is as such: constraint n: value i < value j Where n is an integer which will increase by one every line. Value i is...
Hi All, I'm developing iphone app which take pictures and store it in iphone (within app folder) and picture name and other information stored in sqllite database. If in future, I will release new version of iphone app then does it delete old pictures and update database? Thanks, Priya ...
Hi, I'm looking to clean all my app's leaks. As you can see on the picture below, SQLite makes a lot of memory leak. I do use SQLite through CoreData. The strangest thing is that AdresseBook is making all the libsqlite3 leak and I never use the AdressBook!!! Do you have an idea? Thank you :) ...
One of my android apps performs the following specific SQLite query: SELECT _id, hourMin, actions FROM profiles WHERE type=2 AND hourMin > -1 AND days & 8 != 0 AND prof_id >> 16 IN (256) ORDER BY hourMin ASC LIMIT 1 Now that works on some Android phones, but on a few of them it crashes with the following error: android.database.sqlit...
Hi guys, I'm quite new to the Iphone development and after search for an answer for 3 hours now, I hope that you guys can give me a hand. My problem is that I have a SQLite Database with german umlauts. Looking at it with a SQLite browser tool shows me that the data is stored with german umlauts, correctly. But selecting fields with g...
Hi Guys, I'm developing an Iphone App where the user types in any string into a searchbar and presses the search button. After that a result list should appear. In my SQLite I have four columns a, b, c, d. Let's say they have the following Values: Dataset 1: a: code1 b: report1 c: description1_1 d: description1_2 Dataset 2: a: code2 ...
Once I think about new software projects and current-age data uses, I cannot stand raw files anymore. they seem unnatural now. Basically a file should contain one or more data "streams", metadata/attributes, etc. The file should be optimized for sequential, parallel read (like mkv I think) but have reasonable performance for direct ("r...
Hello Brad, I have an application which sets an web image to the background of the homepage.From next time it loads the homepage background from web as my application stores just the name with the address.This is my code: Sqlite *sqlite = [[Sqlite alloc] init]; NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, ...
I'm sure this is very easy but I'm trying to get the fmdb sqlite wrapper to work in an iPhone project. I've grabbed the files via SVN, and there are 'h' and 'm' files inside an 'src' folder. I'd assumed that if I right-click the Classes folder and select Add > Existing Files... that would work. But when I try to compile I get an error...
I have installed WampServer 2.0 with MySQL 5.1.33. I can do Numeric and String functions like SELECT ABS(-2)orSELECT LOWER('ASD') but with Date and Time Functions such as SELECT CURDATE()orSELECT NOW() I get Error : no such function: CURDATE Am I doing something wrong, is there anything I need to install? Any help about where to...
Hi, How to insert fields values from HTML page to SQLite database ? How to connect from HTML to SQLite ? Thanks. ...
Hello, I'm just writing a SQLite powered android applications however I keep getting a NullPointerException when I call my DatabaseHelper class. The code which appears to be causing the error is below: public Cursor GetAllRows() { try { return db.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_PHRASE}, ...
I'm working in a database on vb.net with sqlite wich hosts a gallery and I want expand the search propieties. This the actual query string: "SELECT images.* FROM images JOIN nodes ON images.id = nodes.image_id WHERE tag_id = (SELECT tags.id FROM tags WHERE tag = '" & tagname & "') ORDER BY images."...
I am currently writing an App that needs the ability to modify and persist various pieces of data. I've decided to use Core Data for this purpose. When the user opens the Application for the first time I need to import a large amount of data from a sqlite database, this data consists of the many-to-many relationships. I'd like to find ...
I understand that sqlite_exec is for queries that does not return resultset and sqlite_query is for queries that return resultset. However can I use sqlite_query for all kinds of queries just like how mysql_query and are there any sideeffects to this? ...
I have two tables, ta and tb: ta: key col1 -------- k1 a k2 c tb: key col2 ------- k2 cc k3 ee They connected by "key". I want to know how can I get a table, tc, like: key col1 col2 ------------- k1 a k2 c cc k3 ee Is there a easy method instead of inserting every record? They are one million records of tables so ...