Build #50, 10/JAN/2007

NOTES

Compact Framework DLL was missing a manifest reference in Build 49 this has been fixed. 

We are also trying to get the NUnitLite framework running under Compact Framework for us to perform NUnit tests here as well.

Minor DDA API Corrections:

The IVistaDBTable had a TemporaryIndexes ability without loading the table schema, but you could not do the same for normal indexes. 

We added a RegularIndexes property now so you can also check for the existence of a regular index without having to load the table schema object

. PutFromFile had some corrections to it for datatypes.  The only valid datatypes are NChar and VarBinary base types (Image is a varbinary internally), other types throw an exception.
GetToFile is new for writing a blob (IMAGE/VARBINARY) field to a file directly on disk rather than getting the array in memory.

ISSUES AND FIXES

#364: Cannot create primary key index after creating table (in encrypted DB) - Fixed

#358: DDA API for get file fails silent with no error message - Fixed

#365: NULLIF sql support added

#370: ISNUMERIC sql support added

#355: Begin-End problem maybe - Fixed

#371: Setting variables using SELECT - Fixed

#368: UDF from View exception - Fixed

OTHER NON TICKETED ITEMS

VistaDB.Web.DLL was not including the resources for the assembly info and was not having a version specified in the build. Automated build script was not correctly updating the Compact Framework DLL for the setup script. Data Builder was not being updated to current version through automated build script. ConnectionString.Pooled property was not exposed. 

You can set pooled=true; in the connection string, or set the VistaDBConnection objects Pooled property to true or false.  See pooling in documentation for more help.  A new section has been added to the help about using Connection Pooling as well.

The Visual Studio 2005/2008 designer is still marked at 3.2 in the manifest due to a PLK problem from Microsoft.  We are working to get this resolved.