How to add the sqlite3 framework to project

Hi all,

Here's a simple question, though I can't seem to figure it out on my own. I am trying to use sqlite on my app. I have #imported the sqlite3.h header file. But when I compile, I get a few warnings and the program does not compile:

Code:

Ld /Users/ocampos/Library/Developer/Xcode/DerivedData/SueldoCalc-erlcpmxwibxgvoewahrcnyaigkot/Build/Products/Debug-iphonesimulator/SueldoCalc.app/SueldoCalc normal i386
    cd /Users/ocampos/Documents/SueldoCalc
    setenv MACOSX_DEPLOYMENT_TARGET 10.6
    setenv PATH "/Developer/Platforms/iPhoneSimulator.platform/Developer/usr/bin:/Developer/usr/bin:/usr/bin:/bin:/usr/sbin:/sbin"
    /Developer/Platforms/iPhoneSimulator.platform/Developer/usr/bin/gcc-4.2 -arch i386 -isysroot /Developer/Platforms/iPhoneSimulator.platform/Developer/SDKs/iPhoneSimulator4.3.sdk -L/Users/ocampos/Library/Developer/Xcode/DerivedData/SueldoCalc-erlcpmxwibxgvoewahrcnyaigkot/Build/Products/Debug-iphonesimulator "-L/Developer/Platforms/iPhoneOS.platform/DeviceSupport/4.2.1 (8C148)/Symbols/usr/lib" -F/Users/ocampos/Library/Developer/Xcode/DerivedData/SueldoCalc-erlcpmxwibxgvoewahrcnyaigkot/Build/Products/Debug-iphonesimulator -filelist /Users/ocampos/Library/Developer/Xcode/DerivedData/SueldoCalc-erlcpmxwibxgvoewahrcnyaigkot/Build/Intermediates/SueldoCalc.build/Debug-iphonesimulator/SueldoCalc.build/Objects-normal/i386/SueldoCalc.LinkFileList -mmacosx-version-min=10.6 -Xlinker -objc_abi_version -Xlinker 2 -framework Foundation -framework UIKit -framework CoreGraphics -lsqlite3.0 -o /Users/ocampos/Library/Developer/Xcode/DerivedData/SueldoCalc-erlcpmxwibxgvoewahrcnyaigkot/Build/Products/Debug-iphonesimulator/SueldoCalc.app/SueldoCalc

ld: warning: ignoring file /Developer/Platforms/iPhoneOS.platform/DeviceSupport/4.2.1 (8C148)/Symbols/usr/lib/libsqlite3.0.dylib, missing required architecture i386 in file
ld: warning: ignoring file /Developer/Platforms/iPhoneOS.platform/DeviceSupport/4.2.1 (8C148)/Symbols/usr/lib/libSystem.dylib, missing required architecture i386 in file
ld: in /Developer/Platforms/iPhoneOS.platform/DeviceSupport/4.2.1 (8C148)/Symbols/usr/lib/libobjc.A.dylib, missing required architecture i386 in file for architecture i386
collect2: ld returned 1 exit status
Command /Developer/Platforms/iPhoneSimulator.platform/Developer/usr/bin/gcc-4.2 failed with exit code 1

I read in a tutorial that I need to add a reference to a file called libsqlite3.0.dylib, via de "Add Existing Frameworks" option, but the tutorial is old and I can't this option in Xcode 4. Can someone help me correct this? Any info will be greatly appreciated, as always.

 

HI,

A Google search showed me how to do it. You click on project name in the Project Explorer, then click on Build Phases, then the + button.

 

Please don't take it that way, but if you look at the responses I got, one was apparently for XCode 3, which was not what I was looking for, and the other reply was not very helpful, although I did not see you had posted a link below yours until now. This does not mean that I am not grateful for the responses. It was in fact the first response which gave me idea on how to look for it in Google.

Still, I see your point, dejo. From now on, I will try to be more thorough when in doubt, lest I not ask something and then find a solution elsewhere. I'm sorry, and I apologize, to you, and the other repliers.

I am not on my Mac right now, but I'll post a screenshot later showing where the option is.

 

Hi again, everyone.

As promised here's a screenshot of where the sqlite framework can be added to your project. As you can see, you first click on your project name on the Project Explorer (left side of the attached picture). This causes the middle pane switch to a tabbed interface with the labels, Summary, Info, Build Settings, Build Phases and Build Rules. You click on Build Phases and you are presented with a screen similar to the attached screenshot. Next click on the gray arrow besides "Link Binary with Libraries" to expand it. Listed, you should see the default frameworks, namely UIKit, Foundation and CoreGraphics. Next you click on the + sign below CoreGraphics (might be different on your system or project, I believe). This will bring down a list of frameworks and libraries you can add. On the top there is a spotlight icon, and a text field, type "libsqlite.0.dylib" there, and it should pop up on the list. Select it and press "Add". Now sqlite should appear on your list of frameworks, as well as the Project Explorer on the left. You should now be able to use the sqlite3 functions in your code.

One thing no one commented on was the errors and warnings I was getting. I still don't know what they were, but they started appearing after I attempted to add libsqlite as a resource (before figuring out the correct way to do it). I had to reinstall Xcode to make them go away. Anyway, I hope this info might of help to someone else