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

iPhone,FMDatabase : executeQuery not working

Below is the code i am using: FMDatabaseQueue *queue = [[DataBaseHelper sharedManager] queue]; [queue inDatabase:^(FMDatabase *db) { FMResultSet *results = [db executeQuery:@"select * from EVENT where ESTATUS='unread' and HIT_ATTEMPTS < 5…
TechFanatic
  • 1,218
  • 4
  • 13
  • 31
0
votes
1 answer

Fmdb Select query with variable table name

I want to get results from different tables, tables are selected by the user. So, I am using table name as variable but it returns nil query. FMResultSet *query = [db1 executeQuery:@"SELECT Image, Explanation FROM %@ WHERE Image…
Ali Sufyan
  • 2,038
  • 3
  • 17
  • 27
0
votes
0 answers

FMDB sql query brings no results while they exist in db

I'm using the FMDB with the sqlite library in the iOS framework and having a problem where a query to the db gets no results, while if I run the same query from my Database Browser it brings me the expected results. this is the code for fetching…
user2730555
  • 1
0
votes
1 answer

Select data from variable_tableName in Sqlite

I am using Fmdb wrapper around Sqlite, everything is working fine. Now I want to load data from a variable table, the table name is stored in an NSString. I don't know how to write query for that. Please help!
Ali Sufyan
  • 2,038
  • 3
  • 17
  • 27
0
votes
3 answers

create database structure using .sql file and FMDB

I have a .sql file which I have exported from MySQL. I am trying to add that table structure into SQLite using FMDB framework but it is not executed and always return false. Here is the structure: CREATE TABLE IF NOT EXISTS `admin` ( `admin_id`…
SandeepM
  • 2,601
  • 1
  • 22
  • 32
0
votes
2 answers

ios 6 sqlite with fmdb not working on iPhone

i'm building an app with sqlite db using FMDB, on simulator everything works fine,on jailbroken iPhone everything works fine, But on idevice with developer account i get this error error opening!: 14 i create the db like this NSString *bundelpath…
Homam
  • 568
  • 7
  • 17
0
votes
1 answer

ios fmdb memory leaks

hi Im asking this question for my friend, who is struggling with this fmdb memory issue. his project read a list from a db, and he opens the db and read the data for each cell, (which is not a good idea but he did), in init, init the database…
nickyu
  • 141
  • 1
  • 11
0
votes
1 answer

FMDB queueing - how does is this pattern correctly implemented?

I have some code using the FMDB sqllite wrapper (https://github.com/ccgus/fmdb) and I'm expecting this code to be executed from multiple threads. As such, I'm using the FMDatabaseQueue class to execute all DB work. I'm a little bit confused by the…
ConfusedNoob
  • 9,826
  • 14
  • 64
  • 85
0
votes
1 answer

SELECT from VIEW with FMDB

I have an SQLite database with the following tables: Player Card Team PlayerCard CardDataComposed is a VIEW created with the following SELECT: SELECT Player.PlayerID, Player.PlayerFirstName, Player.PlayerLastName, Card.CardID, Team.TeamID,…
Brian Palma
  • 641
  • 1
  • 7
  • 13
0
votes
1 answer

FMDB returns 0 results when it should

Im using FMDB in my iphone app (SDK 6.1). I had 3 DB's working using FMDB in this app. I added another DB file to the same app. This one should also return results, but in fact its just returning 0 results. If I used sqlite3 in the unix prompt…
Tim
  • 647
  • 1
  • 10
  • 21
0
votes
2 answers

FMDB executeUpdate not altering database

Inserting new items to the table works perfectly, updating however has no effect. I am using the following statement to update my db. BOOL success = [fmDB executeUpdate:@"UPDATE activities SET type = ?, author = '?', time = '?',…
Bongeh
  • 2,300
  • 2
  • 18
  • 30
0
votes
1 answer

Floating error sqlite ios

I am using FMDatabase in my application and I have a small error when I try to insert these values -0.02, -0.01, -0.03. I've tried to insert a simple plain query with exact values which is working, but when I had tried to insert values above with…
flatronka
  • 1,061
  • 25
  • 51
0
votes
1 answer

Remove call history article call one of the data in the database

The database is read-only. Code: //获取数据库 FMDatabase * db = [dataManager openDataBase]; //判断数据库是否能打开 if ([db open]) { //获取通话记录中所有的address FMResultSet * rs = [db executeQuery:@"SELECT address FROM privacy_call"]; …
lun
  • 1
0
votes
1 answer

Error with FMDB - unknown column name

I am trying to use a NSMutableArray to show some data from my sqlite database in my tableview. When I use AssetDesc as my cell text I can see my description from my sqlite database in my UITableCell. So I know everything is working okay. However…
Blake Loizides
  • 985
  • 2
  • 20
  • 43
0
votes
2 answers

Application freezes with FMDB execute update query

I am using FMDB wrapper class for database in my iphone app. App freezes many times when i call a class with database execute update query. Sample : BOOL success = [database executeUpdate:@"UPDATE JOBTABLE SET ST = ? WHERE jobid =…
TechFanatic
  • 1,218
  • 4
  • 13
  • 31
1 2 3
…
45 46