fmdb Questions
2
Solved
I have a problem with a sqlite project that i'm doing, I'm using FMDB, I follow a simple example, but doesn´t work. And I can't find the error. I did my database schema from the terminal, I put som...
1
I have used FMDB to create a SQLite database in Swift. But now I want to encrypt it. So can anyone please help me with the Swift version of encrypting and decrypting SQLite database using 'FMDB/SQL...
4
Solved
On iPhone, what's the best way to get the ID of the last inserted row on an SQLite Database using FMDB ?
Is there a better way rather than doing :
SELECT MAX(ID)
Sibilla asked 3/5, 2011 at 9:11
8
Solved
does anyone know how to return the count of a query when using FMDB? If I executeQuery @"select count(*) from sometable were..." I get an empty FMResultSet back. How can I get the row count of the ...
Potentiate asked 1/10, 2010 at 8:13
1
Solved
Sorry for repeating a question albeit slightly differently but I've tried everything, searched this forum and google but can't solve this issue. I have a Sqlite database (only 20kb size) which I wa...
3
Solved
In my app I'm using FMDatabase. I'm trying to add new column to existing table and then insert data in that column. When I added the column by Alter Table, I got no errors but when I'm trying to in...
Hoist asked 1/1, 2014 at 15:32
3
Solved
I think this is a simple question but I didnt find the answer in the FMDB git page.
When you use the command:
[database executeUpdate:@"create table T_table(name text primary key, age int)"];
do...
2
Solved
I have a preloaded SQLite database, named "myDB.dms". I want to package the DB and access the contents from within the app.
So to that first, I dragged and dropped the DB file in my Xcode ProjectN...
3
Solved
I'm using sqlite file to get the diaryEntriesTeacher from the authorId. it generates the following object of authorId when I print the variable authorId is nil
Code :-
func applySelectQuery() { ...
2
Solved
I am using the FMDatabase wrapper for SQLite3 in my OSX App. I do tons of inserts into the database:
FMResultSet *results;
results= [db executeQuery:@"select count(*) from `items` where key = ?",[...
1
I'm working on an app that's in the app store, which uses FMDB for interacting with its sqlite database. We've received some crash reports with stack traces like this:
Thread : Crashed: NSOperatio...
2
Solved
I am trying to include a pre-populated SQLite database (with FMDB wrapper) in a build to my physical iPhone. However, the pre-populated database is not being included in the build to the physical d...
4
Solved
I'm just going to try out using transactions with the FMDB SQLite iOS wrapper.
The documentation is a little vague on transactions but from having a quick look at some functions I have come up wit...
Tomsk asked 5/7, 2011 at 9:6
6
Solved
6
Solved
Is it possible to pass an array to a SELECT … WHERE … IN statement via FMDB?
I tried to implode the array like this:
NSArray *mergeIds; // An array with NSNumber Objects
NSString *mergeIdString = ...
3
Solved
I am using SQLite in an iOS application and I am using FMDB as a wrapper. This is my database schema :
CREATE TABLE Offer (code TEXT PRIMARY KEY NOT NULL, name TEXT);
CREATE TABLE OffreMarket (co...
Lines asked 14/6, 2015 at 22:46
3
Solved
I'm having trouble when I try to use FMDatabase.
I have added theese files:
FMDatabaseQueue
FMDatabaseAdditions
FMDatabase
FMResultSet
FMDatabasePool
..and I have also added the libsqlite3.dyli...
1
Solved
I believe that my use case is fairly common, but I could not find an authoritative answer for this.
I have a sync mechanism that runs in background and write data to my database. This sync can ta...
Inelegant asked 6/5, 2015 at 13:2
4
Solved
I am using FMDB to deal with my database which works fine. The app uses a background thread which is doing some work and needs to access the database. At the same time the main thread needs to run ...
Lambrecht asked 29/6, 2010 at 21:2
2
Solved
I followed the tutorial for compiling SQLCipher on iOS devices using a binary located here: http://sqlcipher.net/sqlcipher-binaries-ios-and-osx/
I've made several changes to build settings, adding ...
Seljuk asked 14/1, 2014 at 10:55
2
Can someone explain what the best way to insert a lot of data on the iPhone using FMDB is? I see things like using the beginTransaction command. I'm honestly not sure what this or setShouldCacheSta...
2
Solved
I have seen other questions on here about reading the user_version, and that seems to be working fine for me. However I'm trying to use sqlite in FMDB to set my version number and it isn't setting....
3
I'm trying to send a request to FMDB via a Swift class.
This is working:
self.database.executeQuery("SELECT * FROM foods WHERE id = ?", withArgumentsInArray:[anID])
because I used the method ex...
1
Solved
I'm getting a EXC_BAD_ACCESS when using va_args (iOS 7, Xcode 5.1.1, ARC on):
// ...
int val = sqlIntQuery(@"format_string", @"arg1"); // <-- does not work
int val = sqlIntQuery(@"format_str...
Military asked 4/8, 2014 at 20:17
4
I have a system that is based on the SQLite database. Each client has a local database, and once in a while the update arrives from the main server, just a small delta .db file. The task is to merg...
Leprosarium asked 11/1, 2012 at 13:11
1 Next >
© 2022 - 2024 — McMap. All rights reserved.