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
1 answer

Full Text Search SQL has different effect between ios8 and ios7

I have use the "*" symbols to do selecting on ios7 sqlite which the effect what i want, but ios8 sqlite does not supporting "*" and show "no result". Is the FMDB problem or the ios 8 does not support the "*" symbols? SQL(with…
Jacky Shek
  • 953
  • 1
  • 11
  • 35
0
votes
1 answer

How do I see success of the following FMDatabase executeUpdate statement?

The following code does not give any error but does not do the insert and I can't figure out why. I am still a novice and wanted to know the best way to see the result of this query or see if there is an error message. I'm sure its something simple…
jroyce
  • 2,029
  • 2
  • 22
  • 45
0
votes
1 answer

using fmdb can't update blob type data

FMDB is working fine when I query or delete or insert database but when I try to update it returns me YES in return but actually does not change any thing. This is the code for updating data:(this doesn't work) [_db executeUpdateWithFormat:@"UPDATE…
Dongqing
  • 1
  • 1
0
votes
1 answer

FMDatabase - Use of unresolved identifier 'FMDatabase'

I'm rewriting an App purely in Swift. Just starting on the Database for which I use FMDB. I took some same code out of the "iOS8 App Development Essentials". When I compile the line: let locationsDB = FMDatabase(path: databasePath as String) It…
Edward Hasted
  • 3,201
  • 8
  • 30
  • 48
0
votes
1 answer

How to handle resultDictionary nulls in swift?

With FMDB resultset's resultDictionary method returns a dictionary for each row where the keys are the column names which have a value or are NSNulls. So I am trying to figure out how best to handle these and where. So with the new update of swift I…
Nate Uni
  • 933
  • 1
  • 12
  • 26
0
votes
2 answers

SQLite SELECT statement for column name where column has a value

What SQLite statement do I need to get the column name WHERE there is a value? COLUMN NAME: ALPHA BRAVO CHARLIE DELTA ECHO ROW VALUE: 0 1 0 1 1 All I want in my return is: Bravo, Delta, Echo.
CrazyGoose
  • 51
  • 1
  • 10
0
votes
2 answers

Line breaks using FMDB and Obj-C

I'm relatively new to iOS programming, so please bear with me. I'm creating an app that calls recipes from a table view, then listing the measurements and ingredients as labels in the detail view. I catalogued my recipes in Google Sheets, downloaded…
underriterd
  • 11
  • 5
0
votes
1 answer

How to save image in sqlite using FMDB in ios?

I want to save image in my database and retrieve it when i need them, i have tried all solutions which i get through searching [database executeQuery: @"INSERT INTO customerPresImage (cbFormFK, imageName, imagePath, imageData) VALUES (?, ?, ?, ?)",…
MQ.
  • 365
  • 6
  • 28
0
votes
1 answer

SQLite Datetime before 24 hours query

I have a database table and storing a datetime column with the UTC datetime, iOS [NSDate date] is returning always a UTC datetime. It's all good about it. I'm using FMDB to get the last 12 and 24 hours data with the following code. [self.fmQueue…
George Taskos
  • 8,324
  • 18
  • 82
  • 147
0
votes
1 answer

caching to memory, writing to file and saving to iCloud while iDevice is locked

Here is the deal, I have an application in which the device listens to iBeacons in the background and timestamps the moment user passes the area in range. Initially, as soon as I get a didEnter call back I used the chance to save the information to…
CppChase
  • 901
  • 12
  • 25
0
votes
1 answer

Fmdatabase select dates

I am use a FMDatabase in project, and my question is about selecting dates from database. Sqlite wants dates as seconds from 1/1/1970, but I notice, that if we save date as date in database, and then select with method stringForColumn: (not…
Troir1
  • 63
  • 3
  • 9
0
votes
1 answer

How to migrate *.sqlite database via FMDBMigrationManager?

I'm using FMDB IOS framework to manage my sqlite database. But now I have second version of my database, so I need to update my sqlite file (on devices with installed app) Here is my steps: (database is in Application Support/db/db.sqlite ) create…
kudinovdenis
  • 625
  • 6
  • 12
0
votes
1 answer

FMDatabaseQueue is not surviving a class init()

I've been trying to put together the code initializer into the init() function of model class I have like this: init?() { let docsDir = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)[0] as String let…
Mickey Mouse
  • 1,731
  • 3
  • 24
  • 40
0
votes
1 answer

FMDB freeze application when running execute update query

I am using FMDatabaseQueue to have the ability work with fmdb using GCD. But GCD does not help. When I try to perform any execute update query several times in one moment I got freeze of application. To improve the performance I done - complex…
Svitlana
  • 2,938
  • 1
  • 29
  • 38
0
votes
0 answers

Record count from LIMIT query

We are using a LIMIT/OFFSET query with the FMDB library. I know that I can easily get a count from the FMResultSet, but because we only return a subset of the records it will not be the count of the available records. Does anyone know if there is…
Rob Bonner
  • 9,276
  • 8
  • 35
  • 55
1 2 3
…
45 46