Index: SQLite.Interop/SQLite.Interop.rc ================================================================== --- SQLite.Interop/SQLite.Interop.rc +++ SQLite.Interop/SQLite.Interop.rc @@ -51,11 +51,11 @@ // // Version // VS_VERSION_INFO VERSIONINFO - FILEVERSION 1,0,34,0 + FILEVERSION 1,0,35,0 PRODUCTVERSION 1,0,0,0 FILEFLAGSMASK 0x17L #ifdef _DEBUG FILEFLAGS 0x1L #else @@ -69,11 +69,11 @@ BEGIN BLOCK "040904b0" BEGIN VALUE "Comments", "http://sqlite.phxsoftware.com" VALUE "FileDescription", "System.Data.SQLite Interop Library" - VALUE "FileVersion", "1.0.34.0" + VALUE "FileVersion", "1.0.35.0" VALUE "InternalName", "SQLite.Interop.DLL" VALUE "LegalCopyright", "Released to the public domain" VALUE "OriginalFilename", "SQLite3.DLL 3.3.7" VALUE "ProductName", "System.Data.SQLite" VALUE "ProductVersion", "1.0" Index: SQLite.Interop/merge.h ================================================================== --- SQLite.Interop/merge.h +++ SQLite.Interop/merge.h @@ -3,11 +3,11 @@ #include #pragma data_seg(".clr") #pragma comment(linker, "/SECTION:.clr,ER") - char __ph[117132] = {0}; // The number of bytes to reserve + char __ph[118024] = {0}; // The number of bytes to reserve #pragma data_seg() typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID); typedef struct EXTRA_STUFF { Index: SQLite.Interop/merge_full.h ================================================================== --- SQLite.Interop/merge_full.h +++ SQLite.Interop/merge_full.h @@ -3,11 +3,11 @@ #include #pragma data_seg(".clr") #pragma comment(linker, "/SECTION:.clr,ER") - char __ph[126168] = {0}; // The number of bytes to reserve + char __ph[127052] = {0}; // The number of bytes to reserve #pragma data_seg() typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID); typedef struct EXTRA_STUFF { Index: System.Data.SQLite/AssemblyInfo.cs ================================================================== --- System.Data.SQLite/AssemblyInfo.cs +++ System.Data.SQLite/AssemblyInfo.cs @@ -46,9 +46,9 @@ // Build Number // Revision // // You can specify all the values or you can default the Revision and Build Numbers // by using the '*' as shown below: -[assembly: AssemblyVersion("1.0.34.0")] +[assembly: AssemblyVersion("1.0.35.0")] #if !PLATFORM_COMPACTFRAMEWORK -[assembly: AssemblyFileVersion("1.0.34.0")] +[assembly: AssemblyFileVersion("1.0.35.0")] #endif Index: System.Data.SQLite/SQLiteCommand.cs ================================================================== --- System.Data.SQLite/SQLiteCommand.cs +++ System.Data.SQLite/SQLiteCommand.cs @@ -181,11 +181,11 @@ /// /// Builds an array of prepared statements for each complete SQL statement in the command text /// internal SQLiteStatement BuildNextCommand() { - SQLiteStatement stmt; + SQLiteStatement stmt = null; try { if (_statementList == null) _remainingText = _commandText; @@ -196,18 +196,26 @@ stmt._command = this; if (_statementList == null) _statementList = new List(); _statementList.Add(stmt); + _parameterCollection.MapParameters(stmt); stmt.BindParameters(); } return stmt; } catch (Exception) { - ClearCommands(); + if (stmt != null) + { + if (_statementList.Contains(stmt)) + _statementList.Remove(stmt); + + stmt.Dispose(); + } + throw; } } internal SQLiteStatement GetStatement(int index) Index: bin/CompactFramework/System.Data.SQLite.DLL ================================================================== --- bin/CompactFramework/System.Data.SQLite.DLL +++ bin/CompactFramework/System.Data.SQLite.DLL cannot compute difference between binary files Index: bin/CompactFramework/testce.exe ================================================================== --- bin/CompactFramework/testce.exe +++ bin/CompactFramework/testce.exe cannot compute difference between binary files Index: bin/Designer/SQLite.Designer.dll ================================================================== --- bin/Designer/SQLite.Designer.dll +++ bin/Designer/SQLite.Designer.dll cannot compute difference between binary files Index: bin/Designer/install.exe ================================================================== --- bin/Designer/install.exe +++ bin/Designer/install.exe cannot compute difference between binary files Index: bin/System.Data.SQLite.XML ================================================================== --- bin/System.Data.SQLite.XML +++ bin/System.Data.SQLite.XML @@ -2215,10 +2215,16 @@ DateTimeFormat Ticks - Use DateTime.Ticks
ISO8601 - Use ISO8601 DateTime format
N ISO8601 + + BinaryGUID + True - Store GUID columns in binary form
False - Store GUID columns as text
+ N + True +
Cache Size {size in bytes} N 2000 @@ -2676,10 +2682,16 @@ DateTimeFormat Ticks - Use DateTime.Ticks
ISO8601 - Use ISO8601 DateTime format
N ISO8601
+ + BinaryGUID + Yes/On/1 - Store GUID columns in binary form
No/Off/0 - Store GUID columns as text
+ N + On +
Cache Size {size in bytes} N 2000 Index: bin/System.Data.SQLite.dll ================================================================== --- bin/System.Data.SQLite.dll +++ bin/System.Data.SQLite.dll cannot compute difference between binary files Index: bin/itanium/System.Data.SQLite.DLL ================================================================== --- bin/itanium/System.Data.SQLite.DLL +++ bin/itanium/System.Data.SQLite.DLL cannot compute difference between binary files Index: bin/test.exe ================================================================== --- bin/test.exe +++ bin/test.exe cannot compute difference between binary files Index: bin/x64/System.Data.SQLite.DLL ================================================================== --- bin/x64/System.Data.SQLite.DLL +++ bin/x64/System.Data.SQLite.DLL cannot compute difference between binary files Index: readme.htm ================================================================== --- readme.htm +++ readme.htm @@ -3,14 +3,15 @@ ADO.NET 2.0 SQLite Data Provider
- Version 1.0.34.0 September 4, 2006
+ Version 1.0.35.0 September 10, 2006
Using SQLite 3.3.7
Written by Robert Simpson (robert@blackcastlesoft.com)
Released to the public domain, use at your own risk!
+ Official provider website:  http://sqlite.phxsoftware.com

The latest version can be downloaded here

@@ -117,10 +118,22 @@ just one minor modification is made to pager.c, that modification is made automatically by the fixsource.vbs file when the VS2005 solution is compiled.

Version History

+

1.0.35.0 - September 10, 2006

+
    +
  • Fixed an infinite loop bug in SQLiteCommand caused when multiple semi-colon separated + statements in a single command are executed via datareader and one of the statements + contains a syntax error preventing it from being prepared. 
  • Added the TYPES preparser keyword to be placed before a SELECT statement to + aid the wrapper in converting expressions in a subsequent select clause into more + robust types.  Documentation yet to be integrated, but available on the forums.
  • +
  • Added a new connectionstring parameter "BinaryGUID=true/false" (default is "true").  + When true, guid types are stored in the database as binary blobs to save space.  + Binary has been the default format since 1.0.32.0 but this parameter eases backward + compatibility.
  • +

1.0.34.0 - September 4, 2006

  • Fixed a bug in SQLiteParameterCollection.RemoveAt(namedparam)
  • Fixed a bug in SQLiteDataReader introduced in 1.0.30 that broke DateTimes using the Ticks option in the connection string.
  • Fixed a bug in the recent changes to guid behavior wherein using a datareader's Index: tools/setup/sqlite_setup.vdproj ================================================================== --- tools/setup/sqlite_setup.vdproj +++ tools/setup/sqlite_setup.vdproj @@ -569,11 +569,11 @@ } "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_20F33E95A6904A798F8E0CC6138010F1" { "AssemblyRegister" = "3:1" "AssemblyIsInGAC" = "11:FALSE" - "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86" + "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86" "ScatterAssemblies" { "_20F33E95A6904A798F8E0CC6138010F1" { "Name" = "8:System.Data.SQLite.DLL" @@ -764,11 +764,11 @@ } "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_40DFF08BA903482D807E715A041CA8B1" { "AssemblyRegister" = "3:1" "AssemblyIsInGAC" = "11:FALSE" - "AssemblyAsmDisplayName" = "8:install, Version=1.0.0.20106, Culture=neutral, processorArchitecture=x86" + "AssemblyAsmDisplayName" = "8:install, Version=1.0.0.22237, Culture=neutral, processorArchitecture=x86" "ScatterAssemblies" { "_40DFF08BA903482D807E715A041CA8B1" { "Name" = "8:install.exe" @@ -928,11 +928,11 @@ } "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_A18DBDB7776215EAD9A52C96F8CA1E91" { "AssemblyRegister" = "3:1" "AssemblyIsInGAC" = "11:FALSE" - "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86" + "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86" "ScatterAssemblies" { "_A18DBDB7776215EAD9A52C96F8CA1E91" { "Name" = "8:System.Data.SQLite.DLL" @@ -1174,11 +1174,11 @@ } "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_DAEF610AAD7F4FCAB978C1A47E2DA166" { "AssemblyRegister" = "3:1" "AssemblyIsInGAC" = "11:FALSE" - "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86" + "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86" "ScatterAssemblies" { "_DAEF610AAD7F4FCAB978C1A47E2DA166" { "Name" = "8:System.Data.SQLite.DLL" @@ -1236,11 +1236,11 @@ } "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_F320FBAE871DA320178BEEA242900CC7" { "AssemblyRegister" = "3:1" "AssemblyIsInGAC" = "11:FALSE" - "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86" + "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86" "ScatterAssemblies" { "_F320FBAE871DA320178BEEA242900CC7" { "Name" = "8:System.Data.SQLite.DLL" @@ -1395,18 +1395,18 @@ } "Product" { "Name" = "8:Microsoft Visual Studio" "ProductName" = "8:SQLite ADO.NET 2.0 Provider" - "ProductCode" = "8:{7266FD0D-13B9-4070-99CC-0B208E89F907}" - "PackageCode" = "8:{8769703C-F419-4C3C-9379-F99A312541B1}" + "ProductCode" = "8:{85ED2C8A-EFF0-4458-A12E-2B2E49C6F29D}" + "PackageCode" = "8:{5CFE443E-FD12-4F01-90DC-5D729A69FEF6}" "UpgradeCode" = "8:{78329A82-AFB1-453B-AF00-D46AC911DA89}" "RestartWWWService" = "11:FALSE" "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" - "ProductVersion" = "8:1.34.1" + "ProductVersion" = "8:1.35.0" "Manufacturer" = "8:Phoenix Software Solutions, LLC" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://sqlite.phxsoftware.com" "Title" = "8:SQLite ADO.NET 2.0 Provider" "Subject" = "8:"