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.
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
