All Questions
24 questions
-1
votes
2
answers
1k
views
Inserting value into sqlite table iOS
I am trying to insert some values in my table , not getting any error but values not getting inserting . I defined some values as varchar(100) and some is integer . if you go through the code you will ...
- 1,626
0
votes
1
answer
68
views
Elaborate a mechanism to save objects in SQLite database without write any SQL commands [closed]
Actually, I'm writing all my SQL requests, and it's a source of mistakes. So I'm thinking about a way to save an object in my SQLite database without write any SQL requests. I think it's possible to ...
- 2,364
1
vote
2
answers
93
views
IPhone ios 5, recreate database on each simulator run?
How can i replace the database (with the one i am working on) in my app on each simulator run? (Still adding data and want to check that it looks good)
I tried this but it doesn't seem to be working, ...
- 5,592
0
votes
1
answer
374
views
Open & Manipulate Records of the .xcdatamodeld-File / SQLite?
I'm trying to write my first iPhone-App, which should be data-driven.
Now I have some problems with providing an output - and I'm not sure how well the insert goes in the first place...
So what I ...
- 751
1
vote
2
answers
16k
views
xcode sqlite3 libsqlite.dylib
I have an error in project, but I d'nt know were is the problem. this is my error after compilation.
ld warning:
in
/install/Platforms/iPhoneSimulator.platform/Developer/SDKs/iPhoneSimulator3....
- 31
0
votes
1
answer
154
views
how can I selectively update some SQLite table to preserve user data for an iphone app update?
can you selectively update certain sqllite tables when updating an iphone app, in order to preserve user stored data? how? appreciate the help!
- 5,481
3
votes
3
answers
243
views
Is it feasible to store a sqlite DB containing 333,000 rows locally on an iPhone/iPod Touch?
I have a huge table, which has 3 columns and about 333,000 rows. The sql dump is about 58 MB, and the sqlite DB containing this one table is about 20 MB.
I want to implement a sort of "autocomplete" ...
- 157
4
votes
1
answer
503
views
NSKeyedArchiver encode only part of an array
I have a list of objects that can sometimes change, and I want to keep a persistent cache on the device whenever the app is closed or move to the background.
Most of the objects in the list will not ...
- 81
0
votes
2
answers
279
views
sqlite query in iphone causes leak
I would like to know if calling a method in the following format is any reason for LEAKS?
[userLookupWS initWithUsername:[NSString stringWithUTF8String:(char *)sqlite3_column_text(select_system, 2)] ...
- 139
0
votes
2
answers
5k
views
Sqlite3_step() keeps returning SQLITE_MISUSE on this query. Any pointers?
I am trying to open a sqlite db in the viewDidLoad routine and trying to send a sql query through to the db, but the sqlite_step() fails every time. I am not sure what's wrong here. I am just trying ...
- 892
2
votes
2
answers
4k
views
coredata sqlite malformed DB
I have problems with my coredata sqlite DB, which hosts a book DB. After a crash a user experiences has the problem, that the data isn't shown properly any more in his/her tableview.
This is due to ...
- 635
1
vote
1
answer
733
views
NSCompoundPredicate fails to match
I'm building a NSPredicate using the code below for an iPhone app. The logging shows the prediate to be: location CONTAINS "head" AND shape CONTAINS "oval" AND texture CONTAINS "bumpy" AND colour ...
- 678
0
votes
1
answer
132
views
SQLitePersistent objects only loading NSNumber fields, everything else left null
I've used SQLitePersistentObjects for a lot of different iPhone projects and haven't yet encountered this issue. I'm not sure if it's a bug or merely an issue on my part.
I have a model with quite a ...
- 1,947
7
votes
2
answers
11k
views
CoreData INSERT or REPLACE?
I'am currently migrating an iphone application using SQLite to CoreData.
I need to do an INSERT or REPLACE to add only the new content, is there a way to do this or do I have to fetch all the DB and ...
- 4,649
0
votes
1
answer
264
views
SQLite in iPhone:I want to Retrieving 1 row for each date from sqlite
i only want to know that whether data is available for any specific date or not.If there are more than one data with the same date, i do not want to fetch all the data.I try to use
LIMIT 0,1 in where ...
- 817