System.Data.SQLite
Check-in [acd17b1cf8]
Not logged in

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

Overview
Comment:1.0.41.0
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | sourceforge
Files: files | file ages | folders
SHA1: acd17b1cf8a8d42cc36be4e197d4b2bac8b9f5bf
User & Date: rmsimpson 2007-04-23 07:59:22
Context
2007-04-23
08:12
1.0.41.0 check-in: ee3c5d62f1 user: rmsimpson tags: sourceforge
07:59
1.0.41.0 check-in: acd17b1cf8 user: rmsimpson tags: sourceforge
2007-04-22
23:23
1.0.41.0 check-in: 06c93533ad user: rmsimpson tags: sourceforge
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/SQLite.NET.chm.

cannot compute difference between binary files

Changes to SQLite.Interop/FTS1/FTS1.vcproj.

    25     25   	</ToolFiles>
    26     26   	<Configurations>
    27     27   		<Configuration
    28     28   			Name="Debug|Win32"
    29     29   			OutputDirectory="$(ConfigurationName)"
    30     30   			IntermediateDirectory="$(ConfigurationName)"
    31     31   			ConfigurationType="4"
    32         -			CharacterSet="1"
           32  +			CharacterSet="2"
    33     33   			>
    34     34   			<Tool
    35     35   				Name="VCPreBuildEventTool"
    36     36   			/>
    37     37   			<Tool
    38     38   				Name="VCCustomBuildTool"
    39     39   			/>
................................................................................
    78     78   			/>
    79     79   			<Tool
    80     80   				Name="VCFxCopTool"
    81     81   			/>
    82     82   			<Tool
    83     83   				Name="VCPostBuildEventTool"
    84     84   			/>
    85         -		</Configuration>
    86         -		<Configuration
    87         -			Name="Release|Win32"
    88         -			OutputDirectory="$(ConfigurationName)"
    89         -			IntermediateDirectory="$(ConfigurationName)"
    90         -			ConfigurationType="4"
    91         -			CharacterSet="1"
    92         -			WholeProgramOptimization="1"
    93         -			>
    94         -			<Tool
    95         -				Name="VCPreBuildEventTool"
    96         -			/>
    97         -			<Tool
    98         -				Name="VCCustomBuildTool"
    99         -			/>
   100         -			<Tool
   101         -				Name="VCXMLDataGeneratorTool"
   102         -			/>
   103         -			<Tool
   104         -				Name="VCWebServiceProxyGeneratorTool"
   105         -			/>
   106         -			<Tool
   107         -				Name="VCMIDLTool"
   108         -			/>
   109         -			<Tool
   110         -				Name="VCCLCompilerTool"
   111         -				FavorSizeOrSpeed="1"
   112         -				PreprocessorDefinitions="WIN32;NDEBUG;_LIB;SQLITE_ENABLE_FTS1"
   113         -				StringPooling="true"
   114         -				ExceptionHandling="0"
   115         -				BufferSecurityCheck="false"
   116         -				EnableFunctionLevelLinking="true"
   117         -				RuntimeTypeInfo="false"
   118         -				UsePrecompiledHeader="0"
   119         -			/>
   120         -			<Tool
   121         -				Name="VCManagedResourceCompilerTool"
   122         -			/>
   123         -			<Tool
   124         -				Name="VCResourceCompilerTool"
   125         -			/>
   126         -			<Tool
   127         -				Name="VCPreLinkEventTool"
   128         -			/>
   129         -			<Tool
   130         -				Name="VCLibrarianTool"
   131         -			/>
   132         -			<Tool
   133         -				Name="VCALinkTool"
   134         -			/>
   135         -			<Tool
   136         -				Name="VCXDCMakeTool"
   137         -			/>
   138         -			<Tool
   139         -				Name="VCBscMakeTool"
   140         -			/>
   141         -			<Tool
   142         -				Name="VCFxCopTool"
   143         -			/>
   144         -			<Tool
   145         -				Name="VCPostBuildEventTool"
   146         -			/>
   147     85   		</Configuration>
   148     86   		<Configuration
   149     87   			Name="Debug|Pocket PC 2003 (ARMV4)"
   150     88   			OutputDirectory="$(PlatformName)\$(ConfigurationName)"
   151     89   			IntermediateDirectory="$(PlatformName)\$(ConfigurationName)"
   152     90   			ConfigurationType="4"
   153         -			CharacterSet="1"
           91  +			CharacterSet="2"
   154     92   			>
   155     93   			<Tool
   156     94   				Name="VCPreBuildEventTool"
   157     95   			/>
   158     96   			<Tool
   159     97   				Name="VCCustomBuildTool"
   160     98   			/>
................................................................................
   209    147   				ForceDirty="-1"
   210    148   				RemoteDirectory=""
   211    149   				RegisterOutput="0"
   212    150   				AdditionalFiles=""
   213    151   			/>
   214    152   			<DebuggerTool
   215    153   			/>
          154  +		</Configuration>
          155  +		<Configuration
          156  +			Name="Debug|Itanium"
          157  +			OutputDirectory="$(PlatformName)\$(ConfigurationName)"
          158  +			IntermediateDirectory="$(PlatformName)\$(ConfigurationName)"
          159  +			ConfigurationType="4"
          160  +			CharacterSet="2"
          161  +			>
          162  +			<Tool
          163  +				Name="VCPreBuildEventTool"
          164  +			/>
          165  +			<Tool
          166  +				Name="VCCustomBuildTool"
          167  +			/>
          168  +			<Tool
          169  +				Name="VCXMLDataGeneratorTool"
          170  +			/>
          171  +			<Tool
          172  +				Name="VCWebServiceProxyGeneratorTool"
          173  +			/>
          174  +			<Tool
          175  +				Name="VCMIDLTool"
          176  +				TargetEnvironment="2"
          177  +			/>
          178  +			<Tool
          179  +				Name="VCCLCompilerTool"
          180  +				Optimization="0"
          181  +				PreprocessorDefinitions="WIN32;_DEBUG;_LIB;SQLITE_ENABLE_FTS1"
          182  +				RuntimeLibrary="3"
          183  +				RuntimeTypeInfo="false"
          184  +				UsePrecompiledHeader="0"
          185  +				DebugInformationFormat="3"
          186  +			/>
          187  +			<Tool
          188  +				Name="VCManagedResourceCompilerTool"
          189  +			/>
          190  +			<Tool
          191  +				Name="VCResourceCompilerTool"
          192  +			/>
          193  +			<Tool
          194  +				Name="VCPreLinkEventTool"
          195  +			/>
          196  +			<Tool
          197  +				Name="VCLibrarianTool"
          198  +			/>
          199  +			<Tool
          200  +				Name="VCALinkTool"
          201  +			/>
          202  +			<Tool
          203  +				Name="VCXDCMakeTool"
          204  +			/>
          205  +			<Tool
          206  +				Name="VCBscMakeTool"
          207  +			/>
          208  +			<Tool
          209  +				Name="VCFxCopTool"
          210  +			/>
          211  +			<Tool
          212  +				Name="VCPostBuildEventTool"
          213  +			/>
          214  +		</Configuration>
          215  +		<Configuration
          216  +			Name="Debug|x64"
          217  +			OutputDirectory="$(PlatformName)\$(ConfigurationName)"
          218  +			IntermediateDirectory="$(PlatformName)\$(ConfigurationName)"
          219  +			ConfigurationType="4"
          220  +			CharacterSet="2"
          221  +			>
          222  +			<Tool
          223  +				Name="VCPreBuildEventTool"
          224  +			/>
          225  +			<Tool
          226  +				Name="VCCustomBuildTool"
          227  +			/>
          228  +			<Tool
          229  +				Name="VCXMLDataGeneratorTool"
          230  +			/>
          231  +			<Tool
          232  +				Name="VCWebServiceProxyGeneratorTool"
          233  +			/>
          234  +			<Tool
          235  +				Name="VCMIDLTool"
          236  +				TargetEnvironment="3"
          237  +			/>
          238  +			<Tool
          239  +				Name="VCCLCompilerTool"
          240  +				Optimization="0"
          241  +				PreprocessorDefinitions="WIN32;_DEBUG;_LIB;SQLITE_ENABLE_FTS1"
          242  +				RuntimeLibrary="3"
          243  +				RuntimeTypeInfo="false"
          244  +				UsePrecompiledHeader="0"
          245  +				DebugInformationFormat="3"
          246  +			/>
          247  +			<Tool
          248  +				Name="VCManagedResourceCompilerTool"
          249  +			/>
          250  +			<Tool
          251  +				Name="VCResourceCompilerTool"
          252  +			/>
          253  +			<Tool
          254  +				Name="VCPreLinkEventTool"
          255  +			/>
          256  +			<Tool
          257  +				Name="VCLibrarianTool"
          258  +			/>
          259  +			<Tool
          260  +				Name="VCALinkTool"
          261  +			/>
          262  +			<Tool
          263  +				Name="VCXDCMakeTool"
          264  +			/>
          265  +			<Tool
          266  +				Name="VCBscMakeTool"
          267  +			/>
          268  +			<Tool
          269  +				Name="VCFxCopTool"
          270  +			/>
          271  +			<Tool
          272  +				Name="VCPostBuildEventTool"
          273  +			/>
          274  +		</Configuration>
          275  +		<Configuration
          276  +			Name="Release|Win32"
          277  +			OutputDirectory="$(ConfigurationName)"
          278  +			IntermediateDirectory="$(ConfigurationName)"
          279  +			ConfigurationType="4"
          280  +			CharacterSet="2"
          281  +			WholeProgramOptimization="1"
          282  +			>
          283  +			<Tool
          284  +				Name="VCPreBuildEventTool"
          285  +			/>
          286  +			<Tool
          287  +				Name="VCCustomBuildTool"
          288  +			/>
          289  +			<Tool
          290  +				Name="VCXMLDataGeneratorTool"
          291  +			/>
          292  +			<Tool
          293  +				Name="VCWebServiceProxyGeneratorTool"
          294  +			/>
          295  +			<Tool
          296  +				Name="VCMIDLTool"
          297  +			/>
          298  +			<Tool
          299  +				Name="VCCLCompilerTool"
          300  +				FavorSizeOrSpeed="1"
          301  +				PreprocessorDefinitions="WIN32;NDEBUG;_LIB;SQLITE_ENABLE_FTS1"
          302  +				StringPooling="true"
          303  +				ExceptionHandling="0"
          304  +				BufferSecurityCheck="false"
          305  +				EnableFunctionLevelLinking="true"
          306  +				RuntimeTypeInfo="false"
          307  +				UsePrecompiledHeader="0"
          308  +			/>
          309  +			<Tool
          310  +				Name="VCManagedResourceCompilerTool"
          311  +			/>
          312  +			<Tool
          313  +				Name="VCResourceCompilerTool"
          314  +			/>
          315  +			<Tool
          316  +				Name="VCPreLinkEventTool"
          317  +			/>
          318  +			<Tool
          319  +				Name="VCLibrarianTool"
          320  +			/>
          321  +			<Tool
          322  +				Name="VCALinkTool"
          323  +			/>
          324  +			<Tool
          325  +				Name="VCXDCMakeTool"
          326  +			/>
          327  +			<Tool
          328  +				Name="VCBscMakeTool"
          329  +			/>
          330  +			<Tool
          331  +				Name="VCFxCopTool"
          332  +			/>
          333  +			<Tool
          334  +				Name="VCPostBuildEventTool"
          335  +			/>
   216    336   		</Configuration>
   217    337   		<Configuration
   218    338   			Name="Release|Pocket PC 2003 (ARMV4)"
   219    339   			OutputDirectory="$(PlatformName)\$(ConfigurationName)"
   220    340   			IntermediateDirectory="$(PlatformName)\$(ConfigurationName)"
   221    341   			ConfigurationType="4"
   222         -			CharacterSet="1"
   223         -			WholeProgramOptimization="1"
          342  +			CharacterSet="2"
          343  +			WholeProgramOptimization="0"
   224    344   			>
   225    345   			<Tool
   226    346   				Name="VCPreBuildEventTool"
   227    347   			/>
   228    348   			<Tool
   229    349   				Name="VCCustomBuildTool"
   230    350   			/>
................................................................................
   281    401   				ForceDirty="-1"
   282    402   				RemoteDirectory=""
   283    403   				RegisterOutput="0"
   284    404   				AdditionalFiles=""
   285    405   			/>
   286    406   			<DebuggerTool
   287    407   			/>
   288         -		</Configuration>
   289         -		<Configuration
   290         -			Name="Debug|Itanium"
   291         -			OutputDirectory="$(PlatformName)\$(ConfigurationName)"
   292         -			IntermediateDirectory="$(PlatformName)\$(ConfigurationName)"
   293         -			ConfigurationType="4"
   294         -			CharacterSet="1"
   295         -			>
   296         -			<Tool
   297         -				Name="VCPreBuildEventTool"
   298         -			/>
   299         -			<Tool
   300         -				Name="VCCustomBuildTool"
   301         -			/>
   302         -			<Tool
   303         -				Name="VCXMLDataGeneratorTool"
   304         -			/>
   305         -			<Tool
   306         -				Name="VCWebServiceProxyGeneratorTool"
   307         -			/>
   308         -			<Tool
   309         -				Name="VCMIDLTool"
   310         -				TargetEnvironment="2"
   311         -			/>
   312         -			<Tool
   313         -				Name="VCCLCompilerTool"
   314         -				Optimization="0"
   315         -				PreprocessorDefinitions="WIN32;_DEBUG;_LIB;SQLITE_ENABLE_FTS1"
   316         -				RuntimeLibrary="3"
   317         -				RuntimeTypeInfo="false"
   318         -				UsePrecompiledHeader="0"
   319         -				DebugInformationFormat="3"
   320         -			/>
   321         -			<Tool
   322         -				Name="VCManagedResourceCompilerTool"
   323         -			/>
   324         -			<Tool
   325         -				Name="VCResourceCompilerTool"
   326         -			/>
   327         -			<Tool
   328         -				Name="VCPreLinkEventTool"
   329         -			/>
   330         -			<Tool
   331         -				Name="VCLibrarianTool"
   332         -			/>
   333         -			<Tool
   334         -				Name="VCALinkTool"
   335         -			/>
   336         -			<Tool
   337         -				Name="VCXDCMakeTool"
   338         -			/>
   339         -			<Tool
   340         -				Name="VCBscMakeTool"
   341         -			/>
   342         -			<Tool
   343         -				Name="VCFxCopTool"
   344         -			/>
   345         -			<Tool
   346         -				Name="VCPostBuildEventTool"
   347         -			/>
   348    408   		</Configuration>
   349    409   		<Configuration
   350    410   			Name="Release|Itanium"
   351    411   			OutputDirectory="$(PlatformName)\$(ConfigurationName)"
   352    412   			IntermediateDirectory="$(PlatformName)\$(ConfigurationName)"
   353    413   			ConfigurationType="4"
   354         -			CharacterSet="1"
          414  +			CharacterSet="2"
   355    415   			WholeProgramOptimization="1"
   356    416   			>
   357    417   			<Tool
   358    418   				Name="VCPreBuildEventTool"
   359    419   			/>
   360    420   			<Tool
   361    421   				Name="VCCustomBuildTool"
................................................................................
   404    464   			/>
   405    465   			<Tool
   406    466   				Name="VCFxCopTool"
   407    467   			/>
   408    468   			<Tool
   409    469   				Name="VCPostBuildEventTool"
   410    470   			/>
   411         -		</Configuration>
   412         -		<Configuration
   413         -			Name="Debug|x64"
   414         -			OutputDirectory="$(PlatformName)\$(ConfigurationName)"
   415         -			IntermediateDirectory="$(PlatformName)\$(ConfigurationName)"
   416         -			ConfigurationType="4"
   417         -			CharacterSet="1"
   418         -			>
   419         -			<Tool
   420         -				Name="VCPreBuildEventTool"
   421         -			/>
   422         -			<Tool
   423         -				Name="VCCustomBuildTool"
   424         -			/>
   425         -			<Tool
   426         -				Name="VCXMLDataGeneratorTool"
   427         -			/>
   428         -			<Tool
   429         -				Name="VCWebServiceProxyGeneratorTool"
   430         -			/>
   431         -			<Tool
   432         -				Name="VCMIDLTool"
   433         -				TargetEnvironment="3"
   434         -			/>
   435         -			<Tool
   436         -				Name="VCCLCompilerTool"
   437         -				Optimization="0"
   438         -				PreprocessorDefinitions="WIN32;_DEBUG;_LIB;SQLITE_ENABLE_FTS1"
   439         -				RuntimeLibrary="3"
   440         -				RuntimeTypeInfo="false"
   441         -				UsePrecompiledHeader="0"
   442         -				DebugInformationFormat="3"
   443         -			/>
   444         -			<Tool
   445         -				Name="VCManagedResourceCompilerTool"
   446         -			/>
   447         -			<Tool
   448         -				Name="VCResourceCompilerTool"
   449         -			/>
   450         -			<Tool
   451         -				Name="VCPreLinkEventTool"
   452         -			/>
   453         -			<Tool
   454         -				Name="VCLibrarianTool"
   455         -			/>
   456         -			<Tool
   457         -				Name="VCALinkTool"
   458         -			/>
   459         -			<Tool
   460         -				Name="VCXDCMakeTool"
   461         -			/>
   462         -			<Tool
   463         -				Name="VCBscMakeTool"
   464         -			/>
   465         -			<Tool
   466         -				Name="VCFxCopTool"
   467         -			/>
   468         -			<Tool
   469         -				Name="VCPostBuildEventTool"
   470         -			/>
   471    471   		</Configuration>
   472    472   		<Configuration
   473    473   			Name="Release|x64"
   474    474   			OutputDirectory="$(PlatformName)\$(ConfigurationName)"
   475    475   			IntermediateDirectory="$(PlatformName)\$(ConfigurationName)"
   476    476   			ConfigurationType="4"
   477         -			CharacterSet="1"
          477  +			CharacterSet="2"
   478    478   			WholeProgramOptimization="1"
   479    479   			>
   480    480   			<Tool
   481    481   				Name="VCPreBuildEventTool"
   482    482   			/>
   483    483   			<Tool
   484    484   				Name="VCCustomBuildTool"

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[130148] = {0}; // The number of bytes to reserve
            8  +  char __ph[130896] = {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[138916] = {0}; // The number of bytes to reserve
            8  +  char __ph[139676] = {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.NET.suo.

cannot compute difference between binary files

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

  1220   1220                 foreach (DataRow schemaRow in tblSchema.Rows)
  1221   1221                 {
  1222   1222                   if (String.Compare(schemaRow[SchemaTableColumn.ColumnName].ToString(), strColumn, true, CultureInfo.InvariantCulture) == 0
  1223   1223                     || strColumn == null)
  1224   1224                   {
  1225   1225                     row = tbl.NewRow();
  1226   1226   
         1227  +                  row["NUMERIC_PRECISION"] = schemaRow[SchemaTableColumn.NumericPrecision];
         1228  +                  row["NUMERIC_SCALE"] = schemaRow[SchemaTableColumn.NumericScale];
  1227   1229                     row["TABLE_NAME"] = rdTables.GetString(2);
  1228   1230                     row["COLUMN_NAME"] = schemaRow[SchemaTableColumn.ColumnName];
  1229   1231                     row["TABLE_CATALOG"] = strCatalog;
  1230   1232                     row["ORDINAL_POSITION"] = schemaRow[SchemaTableColumn.ColumnOrdinal];
  1231   1233                     row["COLUMN_HASDEFAULT"] = (schemaRow[SchemaTableOptionalColumn.DefaultValue] != DBNull.Value);
  1232   1234                     row["COLUMN_DEFAULT"] = schemaRow[SchemaTableOptionalColumn.DefaultValue];
  1233   1235                     row["IS_NULLABLE"] = schemaRow[SchemaTableColumn.AllowDBNull];
................................................................................
  1651   1653                     primaryKeys.Add(new KeyValuePair<int, string>(rdTable.GetInt32(0), rdTable.GetString(1)));
  1652   1654                     // Is an integer -- could be a rowid if no other primary keys exist in the table
  1653   1655                     if (String.Compare(rdTable.GetString(2), "INTEGER", true, CultureInfo.InvariantCulture) == 0)
  1654   1656                       maybeRowId = true;
  1655   1657                   }
  1656   1658                 }
  1657   1659               }
         1660  +            // This is a rowid row
  1658   1661               if (primaryKeys.Count == 1 && maybeRowId == true)
  1659   1662               {
  1660   1663                 row = tbl.NewRow();
  1661   1664                 row["CONSTRAINT_CATALOG"] = strCatalog;
  1662   1665                 row["CONSTRAINT_NAME"] = String.Format(CultureInfo.InvariantCulture, "sqlite_master_PK_{0}", rdTables.GetString(2));
  1663   1666                 row["TABLE_CATALOG"] = strCatalog;
  1664   1667                 row["TABLE_NAME"] = rdTables.GetString(2);
  1665   1668                 row["COLUMN_NAME"] = primaryKeys[0].Value;
  1666   1669                 row["INDEX_NAME"] = row["CONSTRAINT_NAME"];
  1667         -              row["ORDINAL_POSITION"] = primaryKeys[0].Key;
         1670  +              row["ORDINAL_POSITION"] = 0; // primaryKeys[0].Key;
  1668   1671   
  1669   1672                 if (String.IsNullOrEmpty(strIndex) || String.Compare(strIndex, (string)row["INDEX_NAME"], true, CultureInfo.InvariantCulture) == 0)
  1670   1673                   tbl.Rows.Add(row);
  1671   1674               }
  1672   1675   
  1673   1676               using (SQLiteCommand cmdIndexes = new SQLiteCommand(String.Format(CultureInfo.InvariantCulture, "SELECT * FROM [{0}].[sqlite_master] WHERE [type] LIKE 'index' AND [tbl_name] LIKE '{1}'", strCatalog, rdTables.GetString(2).Replace("'", "''")), this))
  1674   1677               using (SQLiteDataReader rdIndexes = cmdIndexes.ExecuteReader())
  1675   1678               {
  1676   1679                 while (rdIndexes.Read())
  1677   1680                 {
         1681  +                int ordinal = 0;
  1678   1682                   if (String.IsNullOrEmpty(strIndex) || String.Compare(strIndex, rdIndexes.GetString(1), true, CultureInfo.InvariantCulture) == 0)
  1679   1683                   {
  1680   1684                     using (SQLiteCommand cmdIndex = new SQLiteCommand(String.Format(CultureInfo.InvariantCulture, "PRAGMA [{0}].index_info([{1}])", strCatalog, rdIndexes.GetString(1)), this))
  1681   1685                     using (SQLiteDataReader rdIndex = cmdIndex.ExecuteReader())
  1682   1686                     {
  1683   1687                       while (rdIndex.Read())
  1684   1688                       {
................................................................................
  1685   1689                         row = tbl.NewRow();
  1686   1690                         row["CONSTRAINT_CATALOG"] = strCatalog;
  1687   1691                         row["CONSTRAINT_NAME"] = rdIndexes.GetString(1);
  1688   1692                         row["TABLE_CATALOG"] = strCatalog;
  1689   1693                         row["TABLE_NAME"] = rdIndexes.GetString(2);
  1690   1694                         row["COLUMN_NAME"] = rdIndex.GetString(2);
  1691   1695                         row["INDEX_NAME"] = rdIndexes.GetString(1);
  1692         -                      row["ORDINAL_POSITION"] = rdIndex.GetInt32(1);
         1696  +                      row["ORDINAL_POSITION"] = ordinal; // rdIndex.GetInt32(1);
         1697  +
         1698  +                      ordinal++;
  1693   1699   
  1694   1700                         if (String.IsNullOrEmpty(strColumn) || String.Compare(strColumn, row["COLUMN_NAME"].ToString(), true, CultureInfo.InvariantCulture) == 0)
  1695   1701                           tbl.Rows.Add(row);
  1696   1702                       }
  1697   1703                     }
  1698   1704                   }
  1699   1705                 }

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

   453    453         8,
   454    454         8,
   455    455         2147483647,
   456    456         2147483647,
   457    457         2147483647,
   458    458         2147483647,   // 25 (Xml)
   459    459       };
          460  +
          461  +    internal static object DbTypeToNumericPrecision(DbType typ)
          462  +    {
          463  +      return _dbtypetonumericprecision[(int)typ];
          464  +    }
          465  +
          466  +    private static object[] _dbtypetonumericprecision = {
          467  +      DBNull.Value, // 0
          468  +      DBNull.Value, // 1
          469  +      3,
          470  +      DBNull.Value,
          471  +      19,
          472  +      DBNull.Value, // 5
          473  +      DBNull.Value, // 6
          474  +      53,
          475  +      53,
          476  +      DBNull.Value,
          477  +      5,
          478  +      10,
          479  +      19,
          480  +      DBNull.Value,
          481  +      3,
          482  +      24,
          483  +      DBNull.Value,
          484  +      DBNull.Value,
          485  +      5,
          486  +      10,
          487  +      19,
          488  +      53,
          489  +      DBNull.Value,
          490  +      DBNull.Value,
          491  +      DBNull.Value
          492  +    };
          493  +
          494  +    internal static object DbTypeToNumericScale(DbType typ)
          495  +    {
          496  +      return _dbtypetonumericscale[(int)typ];
          497  +    }
          498  +
          499  +    private static object[] _dbtypetonumericscale = {
          500  +      DBNull.Value, // 0
          501  +      DBNull.Value, // 1
          502  +      0,
          503  +      DBNull.Value,
          504  +      4,
          505  +      DBNull.Value, // 5
          506  +      DBNull.Value, // 6
          507  +      DBNull.Value,
          508  +      DBNull.Value,
          509  +      DBNull.Value,
          510  +      0,
          511  +      0,
          512  +      0,
          513  +      DBNull.Value,
          514  +      0,
          515  +      DBNull.Value,
          516  +      DBNull.Value,
          517  +      DBNull.Value,
          518  +      0,
          519  +      0,
          520  +      0,
          521  +      0,
          522  +      DBNull.Value,
          523  +      DBNull.Value,
          524  +      DBNull.Value
          525  +    };
   460    526   
   461    527       /// <summary>
   462    528       /// Convert a DbType to a Type
   463    529       /// </summary>
   464    530       /// <param name="typ">The DbType to convert from</param>
   465    531       /// <returns>The closest-match .NET type</returns>
   466    532       internal static Type DbTypeToType(DbType typ)

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

   565    565   
   566    566         tbl.BeginLoadData();
   567    567   
   568    568         for (int n = 0; n < _fieldCount; n++)
   569    569         {
   570    570           row = tbl.NewRow();
   571    571   
          572  +        DbType typ = GetSQLiteType(n).Type;
          573  +
   572    574           // Default settings for the column
   573    575           row[SchemaTableColumn.ColumnName] = GetName(n);
   574    576           row[SchemaTableColumn.ColumnOrdinal] = n;
   575         -        row[SchemaTableColumn.ColumnSize] = SQLiteConvert.DbTypeToColumnSize(GetSQLiteType(n).Type);
   576         -        row[SchemaTableColumn.NumericPrecision] = 255;
   577         -        row[SchemaTableColumn.NumericScale] = 255;
          577  +        row[SchemaTableColumn.ColumnSize] = SQLiteConvert.DbTypeToColumnSize(typ);
          578  +        row[SchemaTableColumn.NumericPrecision] = SQLiteConvert.DbTypeToNumericPrecision(typ);
          579  +        row[SchemaTableColumn.NumericScale] = SQLiteConvert.DbTypeToNumericScale(typ);
   578    580           row[SchemaTableColumn.ProviderType] = GetSQLiteType(n).Type;
   579    581           row[SchemaTableColumn.IsLong] = (GetSQLiteType(n).Type == DbType.Binary);
   580    582           row[SchemaTableColumn.AllowDBNull] = true;
   581    583           row[SchemaTableOptionalColumn.IsReadOnly] = false;
   582    584           row[SchemaTableOptionalColumn.IsRowVersion] = false;
   583    585           row[SchemaTableColumn.IsUnique] = false;
   584    586           row[SchemaTableColumn.IsKey] = false;

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

   138    138       /// </summary>
   139    139       /// <param name="parameter">The parameter to add</param>
   140    140       /// <returns>A zero-based index of where the parameter is located in the array</returns>
   141    141       public int Add(SQLiteParameter parameter)
   142    142       {
   143    143         int n = -1;
   144    144   
   145         -      if (parameter.ParameterName != null)
          145  +      if (String.IsNullOrEmpty(parameter.ParameterName) == false)
   146    146         {
   147    147           n = IndexOf(parameter.ParameterName);
   148    148         }
   149    149   
   150    150         if (n == -1)
   151    151         {
   152    152           n = _parameterList.Count;

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

cannot compute difference between binary files

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

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.

   761    761           <member name="M:System.Data.SQLite.SQLiteDataReader.Close">
   762    762               <summary>
   763    763               Closes the datareader, potentially closing the connection as well if CommandBehavior.CloseConnection was specified.
   764    764               </summary>
   765    765           </member>
   766    766           <member name="M:System.Data.SQLite.SQLiteDataReader.Dispose(System.Boolean)">
   767    767               <summary>
   768         -            Disposes the datareader.  Calls Close() to ensure everything is cleaned up.
          768  +            Disposes the datareader.  Base class calls Close() to ensure everything is cleaned up.
   769    769               </summary>
   770    770           </member>
   771    771           <member name="M:System.Data.SQLite.SQLiteDataReader.CheckClosed">
   772    772               <summary>
   773    773               Throw an error if the datareader is closed
   774    774               </summary>
   775    775           </member>
................................................................................
  1604   1604           <member name="M:System.Data.SQLite.SQLiteBase.Step(System.Data.SQLite.SQLiteStatement)">
  1605   1605               <summary>
  1606   1606               Steps through a prepared statement.
  1607   1607               </summary>
  1608   1608               <param name="stmt">The SQLiteStatement to step through</param>
  1609   1609               <returns>True if a row was returned, False if not.</returns>
  1610   1610           </member>
  1611         -        <member name="M:System.Data.SQLite.SQLiteBase.FinalizeStatement(System.Data.SQLite.SQLiteStatement)">
  1612         -            <summary>
  1613         -            Finalizes a prepared statement.
  1614         -            </summary>
  1615         -            <param name="stmt">The statement to finalize</param>
  1616         -        </member>
  1617   1611           <member name="M:System.Data.SQLite.SQLiteBase.Reset(System.Data.SQLite.SQLiteStatement)">
  1618   1612               <summary>
  1619   1613               Resets a prepared statement so it can be executed again.  If the error returned is SQLITE_SCHEMA, 
  1620   1614               transparently attempt to rebuild the SQL statement and throw an error if that was not possible.
  1621   1615               </summary>
  1622   1616               <param name="stmt">The statement to reset</param>
  1623   1617               <returns>Returns -1 if the schema changed while resetting, 0 if the reset was sucessful or 6 (SQLITE_LOCKED) if the reset failed due to a lock</returns>
................................................................................
  2930   2924               </summary>
  2931   2925           </member>
  2932   2926           <member name="F:System.Data.SQLite.SQLiteStatement._command">
  2933   2927               <summary>
  2934   2928               Command this statement belongs to (if any)
  2935   2929               </summary>
  2936   2930           </member>
  2937         -        <member name="M:System.Data.SQLite.SQLiteStatement.#ctor(System.Data.SQLite.SQLiteBase,System.IntPtr,System.String,System.Data.SQLite.SQLiteStatement)">
         2931  +        <member name="M:System.Data.SQLite.SQLiteStatement.#ctor(System.Data.SQLite.SQLiteBase,System.Data.SQLite.SQLiteStatementHandle,System.String,System.Data.SQLite.SQLiteStatement)">
  2938   2932               <summary>
  2939   2933               Initializes the statement and attempts to get all information about parameters in the statement
  2940   2934               </summary>
  2941   2935               <param name="sqlbase">The base SQLite object</param>
  2942   2936               <param name="stmt">The statement</param>
  2943   2937               <param name="strCommand">The command text for this statement</param>
  2944   2938               <param name="previous">The previous command in a multi-statement command</param>

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

cannot compute difference between binary files

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

cannot compute difference between binary files

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

cannot compute difference between binary files

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

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 bin/x64/System.Data.SQLite.lib.

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.39.1 January 11, 2007<br>
     9         -    Using SQLite 3.3.10<br>
            8  +    Version 1.0.41.0 Beta April 23, 2007<br>
            9  +    Using SQLite 3.3.16<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     12       Official provider website:&nbsp; <a href="http://sqlite.phxsoftware.com">http://sqlite.phxsoftware.com</a><br />
    13     13       <br>
    14     14       The latest version can be downloaded <a href="http://sourceforge.net/projects/sqlite-dotnet2">
    15     15         here</a>
    16     16       <br>
................................................................................
   115    115       <p>
   116    116         The core sqlite engine is compiled directly from the unmodified source code available
   117    117         at the sqlite.org website.&nbsp; Several additional pieces are compiled on top of
   118    118         it to extend its functionality, but the core engine's source is not changed.</p>
   119    119       <p></p>
   120    120       <p>
   121    121         <b>Version History</b></p>
          122  +    <p><b>1.0.41.0 - April 23, 2007</b></p>
          123  +    <ul>
          124  +    <li>Code merge with SQLite 3.3.16</li>
          125  +      <li>Second go at implementing proper finalizers to cleanup after folks who've forgotten to Dispose() of the SQLite objects</li>
          126  +      <li>Enhanced GetSchema(IndexColumns) to provide numeric scale and precision values</li>
          127  +      <li>Fixed the column ordinals in GetSchema(IndexColumns) to report the ordinal of the column in the index, not the table</li>
          128  +      <li>Fixed a bug whereby parameters named with an empty string (such as String.Empty) were treated like a named parameter instead of an unnamed parameter</li>
          129  +    </ul>
          130  +    <p><b>1.0.40.0 - January 31, 2007</b></p>
          131  +    <ul>
          132  +    <li>Code merge with SQLite 3.3.12</li>
          133  +      <li>Lots of new code to handle misuse of the library.&nbsp; Implemented finalizers
          134  +        where it made sense, fixed numerous garbage collector issues when objects are not
          135  +        disposed properly, &nbsp;fixed some object lifetime issues, etc.</li>
          136  +      <li>A failed Commit() on a transaction no longer leaves the transaction in an unusable
          137  +        state.</li>
          138  +    </ul>
   122    139       <p><b>1.0.39.1 - January 11, 2007</b></p>
   123    140       <ul>
   124    141       <li>Fixed a really dumb mistake that for some reason didn't trigger any errors in
   125    142         the testcases, whereby commands when associated with a connection were not adding
   126    143         or removing themselves from an internal list of commands for that connection --
   127    144         causing a "database is locked" error when trying to close the connection.</li>
   128    145       </ul>