System.Data.SQLite
Check-in [0bebedcaf5]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:1.0.35.0
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | sourceforge
Files: files | file ages | folders
SHA1: 0bebedcaf5178462fb2a261d816ee7375261b342
User & Date: rmsimpson 2006-09-10 19:27:15
Context
2006-09-10
19:36
1.0.35.0 check-in: 1156e2bf74 user: rmsimpson tags: sourceforge
19:27
1.0.35.0 check-in: 0bebedcaf5 user: rmsimpson tags: sourceforge
2006-09-09
15:28
1.0.34.0 check-in: c57b635c6b user: rmsimpson tags: sourceforge
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to SQLite.Interop/SQLite.Interop.rc.

    49     49   
    50     50   /////////////////////////////////////////////////////////////////////////////
    51     51   //
    52     52   // Version
    53     53   //
    54     54   
    55     55   VS_VERSION_INFO VERSIONINFO
    56         - FILEVERSION 1,0,34,0
           56  + FILEVERSION 1,0,35,0
    57     57    PRODUCTVERSION 1,0,0,0
    58     58    FILEFLAGSMASK 0x17L
    59     59   #ifdef _DEBUG
    60     60    FILEFLAGS 0x1L
    61     61   #else
    62     62    FILEFLAGS 0x0L
    63     63   #endif
................................................................................
    67     67   BEGIN
    68     68       BLOCK "StringFileInfo"
    69     69       BEGIN
    70     70           BLOCK "040904b0"
    71     71           BEGIN
    72     72               VALUE "Comments", "http://sqlite.phxsoftware.com"
    73     73               VALUE "FileDescription", "System.Data.SQLite Interop Library"
    74         -            VALUE "FileVersion", "1.0.34.0"
           74  +            VALUE "FileVersion", "1.0.35.0"
    75     75               VALUE "InternalName", "SQLite.Interop.DLL"
    76     76               VALUE "LegalCopyright", "Released to the public domain"
    77     77               VALUE "OriginalFilename", "SQLite3.DLL 3.3.7"
    78     78               VALUE "ProductName", "System.Data.SQLite"
    79     79               VALUE "ProductVersion", "1.0"
    80     80           END
    81     81       END

Changes to SQLite.Interop/merge.h.

     1      1   // This code was automatically generated from assembly
     2      2   // C:\Src\SQLite.NET\System.Data.SQLite\bin\CompactFramework\System.Data.SQLite.dll
     3      3   
     4      4   #include <windef.h>
     5      5   
     6      6   #pragma data_seg(".clr")
     7      7   #pragma comment(linker, "/SECTION:.clr,ER")
     8         -  char __ph[117132] = {0}; // The number of bytes to reserve
            8  +  char __ph[118024] = {0}; // The number of bytes to reserve
     9      9   #pragma data_seg()
    10     10   
    11     11   typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID);
    12     12   typedef struct EXTRA_STUFF
    13     13   {
    14     14     DWORD dwNativeEntryPoint;
    15     15   } EXTRA_STUFF, *LPEXTRA_STUFF;

Changes to SQLite.Interop/merge_full.h.

     1      1   // This code was automatically generated from assembly
     2      2   // C:\Src\SQLite.NET\System.Data.SQLite\bin\System.Data.SQLite.dll
     3      3   
     4      4   #include <windef.h>
     5      5   
     6      6   #pragma data_seg(".clr")
     7      7   #pragma comment(linker, "/SECTION:.clr,ER")
     8         -  char __ph[126168] = {0}; // The number of bytes to reserve
            8  +  char __ph[127052] = {0}; // The number of bytes to reserve
     9      9   #pragma data_seg()
    10     10   
    11     11   typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID);
    12     12   typedef struct EXTRA_STUFF
    13     13   {
    14     14     DWORD dwNativeEntryPoint;
    15     15   } EXTRA_STUFF, *LPEXTRA_STUFF;

Changes to System.Data.SQLite/AssemblyInfo.cs.

    44     44   //      Major Version
    45     45   //      Minor Version 
    46     46   //      Build Number
    47     47   //      Revision
    48     48   //
    49     49   // You can specify all the values or you can default the Revision and Build Numbers 
    50     50   // by using the '*' as shown below:
    51         -[assembly: AssemblyVersion("1.0.34.0")]
           51  +[assembly: AssemblyVersion("1.0.35.0")]
    52     52   #if !PLATFORM_COMPACTFRAMEWORK
    53         -[assembly: AssemblyFileVersion("1.0.34.0")]
           53  +[assembly: AssemblyFileVersion("1.0.35.0")]
    54     54   #endif

Changes to System.Data.SQLite/SQLiteCommand.cs.

   179    179       }
   180    180   
   181    181       /// <summary>
   182    182       /// Builds an array of prepared statements for each complete SQL statement in the command text
   183    183       /// </summary>
   184    184       internal SQLiteStatement BuildNextCommand()
   185    185       {
   186         -      SQLiteStatement stmt;
          186  +      SQLiteStatement stmt = null;
   187    187   
   188    188         try
   189    189         {
   190    190           if (_statementList == null)
   191    191             _remainingText = _commandText;
   192    192   
   193    193           stmt = _cnn._sql.Prepare(_remainingText, (_statementList == null) ? null : _statementList[_statementList.Count - 1], out _remainingText);
................................................................................
   194    194           if (stmt != null)
   195    195           {
   196    196             stmt._command = this;
   197    197             if (_statementList == null)
   198    198               _statementList = new List<SQLiteStatement>();
   199    199   
   200    200             _statementList.Add(stmt);
          201  +
   201    202             _parameterCollection.MapParameters(stmt);
   202    203             stmt.BindParameters();
   203    204           }        
   204    205           return stmt;
   205    206         }
   206    207         catch (Exception)
   207    208         {
   208         -        ClearCommands();
          209  +        if (stmt != null)
          210  +        {
          211  +          if (_statementList.Contains(stmt))
          212  +            _statementList.Remove(stmt);
          213  +
          214  +          stmt.Dispose();
          215  +        }
          216  +
   209    217           throw;
   210    218         }
   211    219       }
   212    220   
   213    221       internal SQLiteStatement GetStatement(int index)
   214    222       {
   215    223         // Haven't built any statements yet

Changes to bin/CompactFramework/System.Data.SQLite.DLL.

cannot compute difference between binary files

Changes to bin/CompactFramework/testce.exe.

cannot compute difference between binary files

Changes to bin/Designer/SQLite.Designer.dll.

cannot compute difference between binary files

Changes to bin/Designer/install.exe.

cannot compute difference between binary files

Changes to bin/System.Data.SQLite.XML.

  2213   2213               </item>
  2214   2214               <item>
  2215   2215               <description>DateTimeFormat</description>
  2216   2216               <description><b>Ticks</b> - Use DateTime.Ticks<br/><b>ISO8601</b> - Use ISO8601 DateTime format</description>
  2217   2217               <description>N</description>
  2218   2218               <description>ISO8601</description>
  2219   2219               </item>
         2220  +            <item>
         2221  +            <description>BinaryGUID</description>
         2222  +            <description><b>True</b> - Store GUID columns in binary form<br/><b>False</b> - Store GUID columns as text</description>
         2223  +            <description>N</description>
         2224  +            <description>True</description>
         2225  +            </item>
  2220   2226               <item>
  2221   2227               <description>Cache Size</description>
  2222   2228               <description>{size in bytes}</description>
  2223   2229               <description>N</description>
  2224   2230               <description>2000</description>
  2225   2231               </item>
  2226   2232               <item>
................................................................................
  2674   2680               </item>
  2675   2681               <item>
  2676   2682               <description>DateTimeFormat</description>
  2677   2683               <description><b>Ticks</b> - Use DateTime.Ticks<br/><b>ISO8601</b> - Use ISO8601 DateTime format</description>
  2678   2684               <description>N</description>
  2679   2685               <description>ISO8601</description>
  2680   2686               </item>
         2687  +            <item>
         2688  +            <description>BinaryGUID</description>
         2689  +            <description><b>Yes/On/1</b> - Store GUID columns in binary form<br/><b>No/Off/0</b> - Store GUID columns as text</description>
         2690  +            <description>N</description>
         2691  +            <description>On</description>
         2692  +            </item>
  2681   2693               <item>
  2682   2694               <description>Cache Size</description>
  2683   2695               <description>{size in bytes}</description>
  2684   2696               <description>N</description>
  2685   2697               <description>2000</description>
  2686   2698               </item>
  2687   2699               <item>

Changes to bin/System.Data.SQLite.dll.

cannot compute difference between binary files

Changes to bin/itanium/System.Data.SQLite.DLL.

cannot compute difference between binary files

Changes to bin/test.exe.

cannot compute difference between binary files

Changes to bin/x64/System.Data.SQLite.DLL.

cannot compute difference between binary files

Changes to readme.htm.

     1      1   <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
     2      2   <html>
     3      3     <head>
     4      4       <title></title>
     5      5     </head>
     6      6     <body>
     7      7       ADO.NET 2.0 SQLite Data Provider<br>
     8         -    Version 1.0.34.0 September 4, 2006<br>
            8  +    Version 1.0.35.0 September 10, 2006<br>
     9      9       Using SQLite 3.3.7<br>
    10     10       Written by Robert Simpson (<a href="mailto:robert@blackcastlesoft.com">robert@blackcastlesoft.com</a>)<br>
    11     11       Released to the public domain, use at your own risk!<br>
           12  +    Official provider website:&nbsp; <a href="http://sqlite.phxsoftware.com">http://sqlite.phxsoftware.com</a><br />
    12     13       <br>
    13     14       The latest version can be downloaded <a href="http://sourceforge.net/projects/sqlite-dotnet2">
    14     15         here</a>
    15     16       <br>
    16     17       <br>
    17     18       <b></b>
    18     19       <h2>
................................................................................
   115    116         The SQLite3 source code is compiled directly from the SQLite.org release
   116    117         sources.&nbsp; All builds of sqlite after 3.2.8 have included support for Windows CE.&nbsp; Additionally,
   117    118         just one minor modification is made to pager.c, that modification is made automatically by the fixsource.vbs file
   118    119         when the VS2005 solution is compiled.</p>
   119    120       <p></p>
   120    121       <p>
   121    122         <b>Version History</b></p>
          123  +    <p><b>1.0.35.0 - September 10, 2006</b></p>
          124  +    <ul>
          125  +    <li>Fixed an infinite loop bug in SQLiteCommand caused when multiple semi-colon separated
          126  +      statements in a single command are executed via datareader and one of the statements
          127  +      contains a syntax error preventing it from being prepared.&nbsp;</li><li>Added the TYPES preparser keyword to be placed before a SELECT statement to
          128  +    aid the wrapper in converting expressions in a subsequent select clause into more
          129  +    robust types.&nbsp; Documentation yet to be integrated, but available on the forums.</li>
          130  +      <li>Added a new connectionstring parameter "BinaryGUID=true/false" (default is "true").&nbsp;
          131  +        When true, guid types are stored in the database as binary blobs to save space.&nbsp;
          132  +        Binary has been the default format since 1.0.32.0 but this parameter eases backward
          133  +        compatibility.</li>
          134  +    </ul>
   122    135       <p><b>1.0.34.0 - September 4, 2006</b></p>
   123    136       <ul>
   124    137       <li>Fixed a bug in SQLiteParameterCollection.RemoveAt(namedparam)</li>
   125    138       <li>Fixed a bug in SQLiteDataReader introduced in 1.0.30 that broke DateTimes using the Ticks option in the connection string.</li>
   126    139         <li>Fixed a bug in the recent changes to guid behavior wherein using a datareader's
   127    140           indexer to fetch a guid from a column containing both binary and text guids would
   128    141           sometimes return a byte array instead of a guid.</li>

Changes to tools/setup/sqlite_setup.vdproj.

   567    567               "IsDependency" = "11:TRUE"
   568    568               "IsolateTo" = "8:"
   569    569               }
   570    570               "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_20F33E95A6904A798F8E0CC6138010F1"
   571    571               {
   572    572               "AssemblyRegister" = "3:1"
   573    573               "AssemblyIsInGAC" = "11:FALSE"
   574         -            "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"
          574  +            "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"
   575    575                   "ScatterAssemblies"
   576    576                   {
   577    577                       "_20F33E95A6904A798F8E0CC6138010F1"
   578    578                       {
   579    579                       "Name" = "8:System.Data.SQLite.DLL"
   580    580                       "Attributes" = "3:512"
   581    581                       }
................................................................................
   762    762               "IsDependency" = "11:FALSE"
   763    763               "IsolateTo" = "8:"
   764    764               }
   765    765               "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_40DFF08BA903482D807E715A041CA8B1"
   766    766               {
   767    767               "AssemblyRegister" = "3:1"
   768    768               "AssemblyIsInGAC" = "11:FALSE"
   769         -            "AssemblyAsmDisplayName" = "8:install, Version=1.0.0.20106, Culture=neutral, processorArchitecture=x86"
          769  +            "AssemblyAsmDisplayName" = "8:install, Version=1.0.0.22237, Culture=neutral, processorArchitecture=x86"
   770    770                   "ScatterAssemblies"
   771    771                   {
   772    772                       "_40DFF08BA903482D807E715A041CA8B1"
   773    773                       {
   774    774                       "Name" = "8:install.exe"
   775    775                       "Attributes" = "3:512"
   776    776                       }
................................................................................
   926    926               "IsDependency" = "11:TRUE"
   927    927               "IsolateTo" = "8:"
   928    928               }
   929    929               "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_A18DBDB7776215EAD9A52C96F8CA1E91"
   930    930               {
   931    931               "AssemblyRegister" = "3:1"
   932    932               "AssemblyIsInGAC" = "11:FALSE"
   933         -            "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86"
          933  +            "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86"
   934    934                   "ScatterAssemblies"
   935    935                   {
   936    936                       "_A18DBDB7776215EAD9A52C96F8CA1E91"
   937    937                       {
   938    938                       "Name" = "8:System.Data.SQLite.DLL"
   939    939                       "Attributes" = "3:512"
   940    940                       }
................................................................................
  1172   1172               "IsDependency" = "11:TRUE"
  1173   1173               "IsolateTo" = "8:"
  1174   1174               }
  1175   1175               "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_DAEF610AAD7F4FCAB978C1A47E2DA166"
  1176   1176               {
  1177   1177               "AssemblyRegister" = "3:1"
  1178   1178               "AssemblyIsInGAC" = "11:FALSE"
  1179         -            "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86"
         1179  +            "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=x86"
  1180   1180                   "ScatterAssemblies"
  1181   1181                   {
  1182   1182                       "_DAEF610AAD7F4FCAB978C1A47E2DA166"
  1183   1183                       {
  1184   1184                       "Name" = "8:System.Data.SQLite.DLL"
  1185   1185                       "Attributes" = "3:512"
  1186   1186                       }
................................................................................
  1234   1234               "IsDependency" = "11:TRUE"
  1235   1235               "IsolateTo" = "8:"
  1236   1236               }
  1237   1237               "{9F6F8455-1EF1-4B85-886A-4223BCC8E7F7}:_F320FBAE871DA320178BEEA242900CC7"
  1238   1238               {
  1239   1239               "AssemblyRegister" = "3:1"
  1240   1240               "AssemblyIsInGAC" = "11:FALSE"
  1241         -            "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.34.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"
         1241  +            "AssemblyAsmDisplayName" = "8:System.Data.SQLite, Version=1.0.35.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86"
  1242   1242                   "ScatterAssemblies"
  1243   1243                   {
  1244   1244                       "_F320FBAE871DA320178BEEA242900CC7"
  1245   1245                       {
  1246   1246                       "Name" = "8:System.Data.SQLite.DLL"
  1247   1247                       "Attributes" = "3:512"
  1248   1248                       }
................................................................................
  1393   1393           {
  1394   1394           "LangId" = "3:1033"
  1395   1395           }
  1396   1396           "Product"
  1397   1397           {
  1398   1398           "Name" = "8:Microsoft Visual Studio"
  1399   1399           "ProductName" = "8:SQLite ADO.NET 2.0 Provider"
  1400         -        "ProductCode" = "8:{7266FD0D-13B9-4070-99CC-0B208E89F907}"
  1401         -        "PackageCode" = "8:{8769703C-F419-4C3C-9379-F99A312541B1}"
         1400  +        "ProductCode" = "8:{85ED2C8A-EFF0-4458-A12E-2B2E49C6F29D}"
         1401  +        "PackageCode" = "8:{5CFE443E-FD12-4F01-90DC-5D729A69FEF6}"
  1402   1402           "UpgradeCode" = "8:{78329A82-AFB1-453B-AF00-D46AC911DA89}"
  1403   1403           "RestartWWWService" = "11:FALSE"
  1404   1404           "RemovePreviousVersions" = "11:TRUE"
  1405   1405           "DetectNewerInstalledVersion" = "11:TRUE"
  1406   1406           "InstallAllUsers" = "11:TRUE"
  1407         -        "ProductVersion" = "8:1.34.1"
         1407  +        "ProductVersion" = "8:1.35.0"
  1408   1408           "Manufacturer" = "8:Phoenix Software Solutions, LLC"
  1409   1409           "ARPHELPTELEPHONE" = "8:"
  1410   1410           "ARPHELPLINK" = "8:http://sqlite.phxsoftware.com"
  1411   1411           "Title" = "8:SQLite ADO.NET 2.0 Provider"
  1412   1412           "Subject" = "8:"
  1413   1413           "ARPCONTACT" = "8:Phoenix Software Solutions, LLC"
  1414   1414           "Keywords" = "8:"