It's a very odd problem. At first I was worried about character
translations between fortran and C, but the following also fails:
returnValue = sqlite3_open_v2("testing.db", &oDatabase,
SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
I guess this rules out encoding too?
Perhaps it's something to do with how the library is being created? I'm
pretty much just including sqlite3.h, sqlite3ext.h, sqlite3.c in a C++
project and compiling it as a static lib.
Rob.
On Fri, Apr 5, 2013 at 3:03 PM, Richard Hipp <d...@sqlite.org> wrote:
> On Fri, Apr 5, 2013 at 9:02 AM, Richard Hipp <d...@sqlite.org> wrote:
>
> >
> >
> > On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie <rob.col...@gmail.com> wrote:
> >
> >> Hello there,
> >>
> >> For my sins, I'm trying to create a library allowing our legacy fortran
> >> code to work with SQL.
> >>
> >> Calling this from fortran...
> >>
> >> CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue)
> >> ...runs the following code, and yet the error returned is 'SQL Logic
> error
> >> or missing database'. No file is ever created. Is there something dumb
> I'm
> >> missing here?
> >>
> >>
> >> extern "C"
> >> {
> >>
> >> void EXECUTESQL(char *dataBase, char *query, int returnValue)
> >> {
> >>
> >> // Checking the incoming data from FORTRAN
> >> CStringW wName(dataBase);
> >> MessageBoxW( NULL, wName, L"Name: ", MB_OK );
> >>
> >> // Create the object
> >> sqlite3 *oDatabase;
> >>
> >> // Create the error objects
> >> char *sErrorMessage;
> >> // Open/create the table, if required
> >> returnValue = sqlite3_open_v2(dataBase, &oDatabase,
> >>
> >
> > I think you want just "oDatabase", without the "&" prefix operator.
> >
>
> No. Scratch that. I misread the code. Ignore what I said. I'm going to
> get coffee now.....
>
>
> >
> >
> >> SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
> >> if (returnValue != SQLITE_OK )
> >> {
> >> sqlite3_close(oDatabase);
> >> MessageBoxA(NULL, sqlite3_errstr(returnValue), "SQL Open Error",
> >> MB_OK);
> >> return;
> >> }
> >>
> >>
> >> Rob.
> >> _______________________________________________
> >> sqlite-users mailing list
> >> sqlite-users@sqlite.org
> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >>
> >
> >
> >
> > --
> > D. Richard Hipp
> > d...@sqlite.org
>
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
