[EMAIL PROTECTED] wrote:
>
> I don't know where I must crash my head :-(
>
It looks like the database is fine.
Are you certain that you are using the same database file from the
command line and in your program? Your program uses the file test.db in
the current directory when it runs (unless it changes the current
directory). Is that the same path used from the command line? One way to
be sure is to use an absolute path name in your program.
Can you try simplifying your test?
int main(int argc ,char *argv[])
{
expander expio;
expio.open_db("/complete/path/to/the/file/test.db");
if (expio.sqlraw("UPDATE inputai SET Value=12.3 WHERE Address=7 and
Port=1") == 0)
printf("success\n");
else
printf("failure\n");
return 0;
}
One other remote possibility that comes to mind is that your program is
running as a different user than the command line shell program, and
that user doesn't have write permission to the file or directory which
are needed to create the journal file and to modify the database file. I
would have expected an error message return from sqlite3_exec() if that
were the case though.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
