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

Working with SQLite in XCode

The application I made currently use XML files to store data and now want to Convert it to SQLite db as manipulating data in XML file is getting bit complicated. I decided on FMDB to be used as Wrapper for SQL. The problem is, the development…
Ankit
  • 319
  • 2
  • 7
  • 17
0
votes
1 answer

How to get the row count using FMDB with SELECT statements and JOINs?

This is my SQL to get the row count of OrderData. Using straight SQL (in SQLite Database Browser) it gives me the correct value; when I use this select statement in my app with FMDB, I get a count of zero (0). // get count of line items for…
SpokaneDude
  • 4,856
  • 13
  • 64
  • 120
0
votes
1 answer

Converting sqlite db to csv using chcsv parser (need to use core data instead of fmdb)

I am using CHCSVParser to convert sqlite file to csv format. At this link - How to export SQLite file into CSV file in iPhone SDK the example gives a precise way to to do it using FMDB library (wrapper over sqlite db). I am able to do it using…
user1140780
  • 988
  • 2
  • 13
  • 29
0
votes
1 answer

How do I get a NULL into this SQLite insert statement?

I have 3 SQLite tables. Each has an ID as primary key; if I provide a NULL when inserting a record to ID, it will auto-increment the key (at least that's what the SQLite docs say). I am trying to get the NULL into this insert statement, but it…
SpokaneDude
  • 4,856
  • 13
  • 64
  • 120
0
votes
1 answer

fmdb fmresultset not loading anything

some friends and me are developing a game in cocos2d :), and im using fmdb for some settings in it. Actually i have this code : NSString *path = [[NSBundle mainBundle] pathForResource:@"myDB" ofType:@"sqlite"]; mainDB = [FMDatabase…
Cazz Brunestud
  • 96
  • 1
  • 8
0
votes
1 answer

sqlite3_column_text returns only 255 bytes even though there is data in db

Ladies and Gents, I'm using FMDB in an iOS application. I have some text in columns which exceeds 255 bytes. I use BASE and browse the database file, and I can query the length of the data in the columns... So I know my data is there and that it is…
ivanhoe1982
  • 530
  • 1
  • 4
  • 14
0
votes
1 answer

How to identify the item ID in TableView and delete the database

I'm new and I still have some doubts. I created a class that does the loading of data from a database table into an array.Now I want to implement the deletion of records from the database by selectingDelete in a TableView. I'm having trouble. I have…
adrianosantospro
  • 139
  • 1
  • 9
0
votes
2 answers

fmdb locks application when running UPDATE-query

I'm having trouble executing an UPDATE-query with fmdb. It locks the application without any errors. It stops at this line: [db executeUpdate:@"UPDATE categories SET number_places = 21 WHERE id = 44"];
Stefan Edberg
  • 231
  • 2
  • 4
  • 15
0
votes
3 answers

Obj-C complaining about fields being "Expression result unused"

I am trying to do a FMDB insert with this code: dbCmd = @"INSERT INTO SiteData (SITE_ID, INITIAL_STA, ELEV, SITE_DESC, LOOP_COUNT, DATE) VALUES(?,?,?,?,?,?)", txtSiteID.text, [txtSTA.text floatValue], [txtElev.text floatValue], txtSiteDesc.text,…
SpokaneDude
  • 4,856
  • 13
  • 64
  • 120
0
votes
2 answers

Calling delegate in loop works only the first time

Some background info I'm making an app which has a adminsitration backend for updating it's data. The app saves all data in an SQLite datbase for offline support. The backend has a simple API that returns new data in JSON depending on the…
Stefan Edberg
  • 231
  • 2
  • 4
  • 15
0
votes
1 answer

FMDatabase: is it safe to leave failing inserts (unique PK key violated)?

Currently, developing an app that needs to synchronize its data between a server. The app heavily uses SQLite, so we moved to raw sqlite and decided to use FMDatabase. Our tables are denormalized and without keys because we do not manage data state,…
Centurion
  • 14,106
  • 31
  • 105
  • 197
0
votes
1 answer

Database path not been used by application - Logic issue

I have created a sqlite database. and dragged it on to my projects resource folder. In my project i am accessing a sqlite file from /Users/user12/Library/Application Support/iPhone…
user1315906
  • 3,374
  • 8
  • 30
  • 43
0
votes
1 answer

Opening connection to SQLITE database on iPhone too slow

I have created a simple iPhone/iPad app which reads some data from a SQLITE database and shows it on the screen. The database is added to the Xcode project and only needs to be read (not written). In the simulator all this works fine, but when I run…
dennieku
  • 83
  • 9
0
votes
1 answer

Logic issue, adding Buttons to UI based on database entries

In my SQLite database (FMDB) i have some attributes as listed below; Module | Student1 | Student2 | Student3 | Student4 | Student5 One Module may have a minimum of 2 students and a maximum of 5 students. So based on the number of students i have…
shajem
  • 2,111
  • 5
  • 22
  • 30
-1
votes
1 answer

Why I can't read my SQlite with FMDB in IOS

I've create a DB file from firefox tool SQlite manager names myTestDB the db has a table names ViewController1,and the table content 5 columns(there value are all TEXT) I want read the value by columns name,so here's my code.... -…
bbbbbird1
  • 55
  • 2
  • 6
1 2 3
…
45 46