Stack Overflow
Stack Overflow

Questions tagged [fmdb]

FMDB is a free, third-party Objective-C wrapper for SQLite, providing a simple, object-oriented interface for Mac OS X and iOS.

FMDB is a free, third-party Objective-C wrapper for SQLite, providing a simple, object-oriented interface for Mac OS X and iOS. FMDB isolates the Objective-C developer from the SQLite C interface and greatly simplifies the process of writing code that interacts with SQLite databases.

FMDB was developed by August "Gus" Mueller and is provided the public free of charge for use without restriction. See the LICENSE.

References

677 questions
0
votes
0 answers

Downloaded sqlite database saved to NSDocument Directory cant be updated using FMDB?

**UPDATE** I have discovered that the database is not opening in the ios device.(only for update?? but it does for a select statement) It will open in the similator. I am using FMDB wrapper for SQlite. Everything works fine in the simulator. On…
CrazyGoose
  • 51
  • 1
  • 10
0
votes
0 answers

ignore touch when FMDB do database method

is there any way to ignore touch event before fmdb complete it's database sequence for instance, i do a database pulling so i dont want user to tap on the screen before the database process completed i've tried using [[UIApplication…
Yonathan Jm
  • 442
  • 3
  • 12
0
votes
1 answer

How to block a selector from being accessed multiple times at once?

I've a selector that updates my sqlite (FMDB framework) database fillTopXTraps. When I call the selector up updates 2 separate databases, it fails in 'DataBase' class (shortly -> 'db'). And I've this error: The FMDatabase is currently in…
Idan Moshe
  • 1,675
  • 4
  • 28
  • 65
0
votes
2 answers

How to not reload NSMutableArray from SQLite every time when opening iOS TableView

I have an iOS app with three SQLite databases that I load from web services. When I open the TableView for one of the dbs I load the data into a NSMutableArray and use that as the datasource. Here is the viewDidLoad for the employee View... -…
Bryan Schmiedeler
  • 2,977
  • 6
  • 35
  • 74
0
votes
1 answer

Saving FMDatabase in SQLite database

How can I save my FMDatabase database to SQLite database (.db) in my project? I have a TableView, where I display my Sqlite database (.db) with FMDatabase. I changed that database with executeUpdate, but I can't apply this changes to the original…
Ike
  • 9
  • 5
0
votes
1 answer

Inserting int value into sqlite using (FMDB with iOS) and retrieving it: not what we would be waiting for

I am a little embarrassed since I spend my whole day on this trouble while it could seems really trivial for you, As mentioned in the title, I am storing values in a sqlite via FMDB (these values are 1, 2 or 3 in this case). When in another view, I…
sebastien FCT
  • 630
  • 1
  • 13
  • 28
0
votes
0 answers

ios: Create dynamic sqlite table using FMDB

NSString *mysql = [NSString stringWithFormat:@"CREATE TABLE %@ (fname VARCHAR(100),lname VARCHAR(100),company VARCHAR(100),address1 VARCHAR(100),address2 VARCHAR(100),city VARCHAR(100),state VARCHAR(100),zip VARCHAR(100),email VARCHAR(100),phone…
Pawriwes
  • 283
  • 1
  • 6
  • 21
0
votes
2 answers

ios: insert into sqlite table using FMDB

I am trying to create and insert into a table that is created on the way(dynamic table name). I am able to create the table, but can not insert into it. I am using the code that is given below, every time I try, success = 0. BOOL success = [db…
Pawriwes
  • 283
  • 1
  • 6
  • 21
0
votes
1 answer

FMDatabase Resultset

FMDatabase *database = [FMDatabase databaseWithPath:databasePath]; [database open]; FMResultSet *results = nil; results=[database executeQuery:@"SELECT * FROM CLINIQDB"]; while([results next]) { countryArr=[[NSMutableArray alloc] init]; …
Srinivasa Reddy
  • 77
  • 1
  • 2
  • 10
0
votes
2 answers

FMDB Result of table to JSON object respecting the order of the columns.

EDIT: NEW QUESTION AT BOTTOM It was getting all the rows I was wrong I am trying to get the results of an SQL query and place them into a json object to send to my server to do more work with the data. Right now my code is only returning 1 row of…
William Brasky
  • 61
  • 11
0
votes
0 answers

FMDB executeupdate hangs when calling

I am using FMDB to procedd sqlitedb in obj-c , but it hangs everytime i call executeupdate BOOL isSuccess = YES; [self openFMDB]; NSString* currentDatetime = [self getCurrentDatetime]; isSuccess = [fmDB executeUpdate:@"UPDATE liquors_list SET…
Popoyo
  • 213
  • 1
  • 2
  • 5
0
votes
1 answer

How do I import a class into an iPhone project?

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…
Gazzer
  • 4,524
  • 10
  • 39
  • 49
0
votes
1 answer

Return filtered LIKE results in SQLite using FMDB

Using SQLite is there a way of using the LIKE command where the search parameter could find results that would be considered a substring of itself ie. a search parameter of "delicious and tasty fruit and cinnamon." could return "delicious and…
Ron Myschuk
  • 6,011
  • 2
  • 20
  • 32
0
votes
1 answer

FMDB and threads and queues

I'm playing with FMDB which is a database wrapper for SQLite on iOS. it doesn't support multi threads, and it provides a queue , of course a serial queue, to execute SQL one by one (FMDatabaseQueue), In my project, I use this queue(FMDatabaseQueue)…
nickyu
  • 141
  • 1
  • 11
0
votes
1 answer

Best way to pass array of integers to sqlite for an 'IN' clause

I'm implementing an image dao that selects images based on a client_type (eg dropbox, facebook, etc), as follows: Return results from any enabled client matching the supplied list of client types: //clientTypes is an array of NSNumber objects -…
Jasper Blues
  • 28,258
  • 22
  • 102
  • 185
1 2 3
…
45 46