Compilation issues when the SQLITE_OMIT_MEMORYDB symbol is defined

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Add the SQLITE_OMIT_MEMORYDB compilation constant
2. Recompile

What is the expected output? What do you see instead?

I get the following compilation errors:

Error   1   'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_prepare'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  993 21  csharp-sqlite-shell
Error   2   'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_prepare'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1073    23  csharp-sqlite-shell
Error   3   The type name 'dxCallback' does not exist in the type
'CS_SQLite3.csSQLite'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  7   40  csharp-sqlite-shell
Error   4   'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_open'  C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1211    18  csharp-sqlite-shell
Error   5   'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_errcode'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1213    37  csharp-sqlite-shell
Error   6   The type name 'dxFunc' does not exist in the type
'CS_SQLite3.csSQLite'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1216    21  csharp-sqlite-shell
Error   7   'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_errcode'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1218    59  csharp-sqlite-shell
Error   9   'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_open'  C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1370    23  csharp-sqlite-shell
Error   10  The best overloaded method match for
'CS_SQLite3.csSQLite.sqlite3_exec(CS_SQLite3.csSQLite.sqlite3, string, int,
int, int)' has some invalid arguments   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1433    15  csharp-sqlite-shell
Error   11  Argument '3': cannot convert from '<null>' to 'int' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1433    73
csharp-sqlite-shell
Error   12  Argument '4': cannot convert from '<null>' to 'int' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1433    79
csharp-sqlite-shell
Error   13  Argument '5': cannot convert from 'ref string' to 'int'
C:\Documents and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1433
89  csharp-sqlite-shell
Error   14  'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_prepare'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1578    41  csharp-sqlite-shell
Error   15  'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_prepare'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1603    41  csharp-sqlite-shell
Error   16  The best overloaded method match for
'CS_SQLite3.csSQLite.sqlite3_exec(CS_SQLite3.csSQLite.sqlite3, string, int,
int, int)' has some invalid arguments   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1674    27  csharp-sqlite-shell
Error   17  Argument '3': cannot convert from '<null>' to 'int' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1674    76
csharp-sqlite-shell
Error   18  Argument '4': cannot convert from '<null>' to 'int' C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1674    82
csharp-sqlite-shell
Error   19  Argument '5': cannot convert from 'ref string' to 'int'
C:\Documents and Settings\Philippe\csharp-sqlite\shell\src\shell.cs 1674
92  csharp-sqlite-shell
Error   20  'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_open'  C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1891    59  csharp-sqlite-shell
Error   21  'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_sleep' C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  1912    58  csharp-sqlite-shell
Error   23  'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_complete'  C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  2213    21  csharp-sqlite-shell
Error   24  'CS_SQLite3.csSQLite' does not contain a definition for
'sqlite3_complete'  C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  2306    23  csharp-sqlite-shell
Error   25  Cannot implicitly convert type 'int' to 'string'    C:\Documents
and Settings\Philippe\csharp-sqlite\shell\src\shell.cs  2584    20
csharp-sqlite-shell
Error   26  Operator '==' cannot be applied to operands of type 'string' and
'int'   C:\Documents and
Settings\Philippe\csharp-sqlite\shell\src\shell.cs  2594    5   csharp-sqlite-shell


What version of the product are you using? On what operating system?

XP 
.NET 3.5 
VS 2008 Express

Please provide any additional information below.

Looking at the main function it looked like the default is to use an
in-memory database unless the SQLITE_OMIT_MEMORYDB symbol is defined in
which case it should use the database name passed on the command line, then
open the database.

Twitter alias: #techarch

Original issue reported on code.google.com by pfmon...@gmail.com on 8 Aug 2009 at 9:31

[GoogleCodeExporter]

Committed some minor changes to allow running with SQLITE_OMIT_MEMORYDB (not 
sure why
you would want to do that since ":memory:" is an illegal filename under windows)
See http://sqlite.org/compile.html#omit_memorydb

Most of the Compilation errors show are not from the SQLITE_OMIT_MEMORYDB 
option; 
Either there are other missing defines, or the source tree is not loaded

See HowToCompile

Original comment by noah.hart@gmail.com on 9 Aug 2009 at 1:15

• Changed state: Fixed