Re: [sqlite] SQL Logic error or missing database

[ibrahim]

On 05.04.2013 17:01, Dan Kennedy wrote:
On 04/05/2013 09:08 PM, Rob Collie wrote:
Yeap, I'm on Visual Studio 2012. I've created a console app:

  sqlite3 *oDatabase;
  int returnValue;
  returnValue = sqlite3_open_v2("file://C:/Newfolder/testing.db",
&oDatabase, SQLITE_OPEN_CREATE, NULL);
  if (returnValue != SQLITE_OK )
  {
   //sqlite3_close(oDatabase);
   return returnValue ;
  }
  int anyKey;
  return 0;

It returns 21. Checking the other project, the open actually does 
return 21
too.

This one is returning SQLITE_MISUSE because the SQLITE_OPEN_READWRITE
flag is not being passed. It seems quite odd that the other code
would do the same though.





_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Thanks Dan I just copied and paste his code.

correction :

returnValue = sqlite3_open_v2 ("C:\\Newfolder\\testing.db", &oDatabase, 
SQLITE_OPEN_CREATE | SQLITE_OPEN_READWRITE, NULL) ;

and to make the test just more simple :

returnValue = sqlite3_open ("C:\\Newfolder\\testing.xyz", &oDatabase) ;

try the different file extension could be a problem on some systems.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users