Hi,
I am new to the world of SQLite3. I am using C++ on Windows XP. For a
development IDE I am using MinGW Developer Studio 2.05. After
downloading SQLite3 I began working with the sample program set and had
no difficulty properly assigning the correct include path to the MingW
compiler; to whit, I get no error message.
Unfortunately, linking is not nearly as easy or as self evident. The
program source is very simple:
#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>
#include <string>
#include "Database.h"
#include "Query.h"
int main()
{
Database db( "database_file.db" );
Query q(db);
q.execute("delete from user");
q.execute("insert into user values(1,'First Person')");
q.execute("insert into user values(2,'Another Person')");
q.get_result("select num,name from user");
while (q.fetch_row())
{
long num = q.getval();
std::string name = q.getstr();
printf("User#%ld: %s\n", num, name.c_str() );
}
q.free_result();
}
The output generated by the linker is as follows:
Linking...
C:\slTest\Debug\ltst..o(.text+0x185): In function `main':
C:\slTest\ltst.cpp:11: undefined reference to
`Database::Database(std::string const&, IError*)'
C:\slTest\Debug\ltst.o(.text+0x21e):C:\slTest\ltst.cpp:12: undefined
reference to `Query::Query(Database&)'
C:\slTest\Debug\ltst.o(.text+0x26c):C:\slTest\ltst.cpp:14: undefined
reference to `Query::execute(std::string const&)'
C:\slTest\Debug\ltst.o(.text+0x321):C:\slTest\ltst.cpp:15: undefined
reference to `Query::execute(std::string const&)'
C:\slTest\Debug\ltst.o(.text+0x3d6):C:\slTest\ltst.cpp:16: undefined
reference to `Query::execute(std::string const&)'
C:\slTest\Debug\ltst.o(.text+0x48b):C:\slTest\ltst.cpp:18: undefined
reference to `Query::get_result(std::string const&)'
C:\slTest\Debug\ltst.o(.text+0x50a):C:\slTest\ltst.cpp:19: undefined
reference to `Query::fetch_row()'
C:\slTest\Debug\ltst.o(.text+0x52b):C:\slTest\ltst..cpp:21: undefined
reference to `Query::getval()'
C:\slTest\Debug\ltst.o(.text+0x55d):C:\slTest\ltst.cpp:22: undefined
reference to `Query::getstr()'
C:\slTest\Debug\ltst.o(.text+0x6ec):C:\slTest\ltst.cpp:26: undefined
reference to `Query::free_result()'
C:\slTest\Debug\ltst.o(.text+0x712):C:\slTest\ltst.cpp:26: undefined
reference to `Query::~Query()'
C:\slTest\Debug\ltst.o(.text+0x738):C:\slTest\ltst.cpp:26: undefined
reference to `Query::~Query()'
C:\slTest\Debug\ltst.o(.text+0x75b):C:\slTest\ltst.cpp:26: undefined
reference to `Database::~Database()'
C:\slTest\Debug\ltst.o(.text+0x794):C:\slTest\ltst.cpp:26: undefined
reference to `Database::~Database()'
slTest.exe - 14 error(s), 0 warning(s)
What libraries should I be including that I am not and what relative
library paths should I be specifying. Any other tidbits of information
you might like to pass on will be most appreciated.
Thank you for your assistance.
Robert L. Berman
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
