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
