Browse by Tags

CREATE TABLE AS not keeping data types starting from v1.0.62

Hi, I have a problem with the CREATE TABLE AS functionality, starting from the v1.0.62. Consider the following code: using (var connexion = new SQLiteConnection("Data Source=:memory:;DateTimeFormat=JulianDay")) { connexion.Open(); using (SQLiteTransaction transaction = connexion.BeginTransaction...

Posted to Bugs (Forum) by OmaR_ShaRif on 01-24-2011
Char is inserted into table as an Integer

SQLite inserts a Character as an Integer interpreted as the decimal ASCII value. This happens if you do not specify the DBtype of a parameter used in a SQLiteCommand. You can verify the problem with the code below. All the SQLiteCommands insert a Character/String as asumed. But the last one inserts a...

Posted to Bugs (Forum) by kws on 08-25-2009
Data type not inherited when creating tables by CREATE TABLE x AS SELECT * FROM y WHERE ...

I've found this BUG with1.0.65, later I checked with 1.0.63, but it performs the same. When creating tables using CREATE TABLE x AS SELECT * FROM y WHERE ... the created table does not inherit the data types of the original table! for example: The original 'BinaryAttachment' is: CREATE TABLE...

Posted to Bugs (Forum) by BilikTamas on 07-30-2009
SQLiteConnection.GetSchema("DataTypes") throws System.Resources.MissingManifestResourceException

Hello! I am using SQLite.NET for over three years now and first of all I would like to say: Thank you for your great work with this data provider! But today I stumbled over a new little bug: when trying to call SQLiteConnection.GetSchema("DataTypes") I get a System.Resources.MissingManifestResourceException...

Posted to Bugs (Forum) by Wintermute on 07-04-2009

Page 1 of 1 (4 items)

System.Data.SQLite

Browse by Tags

CREATE TABLE AS not keeping data types starting from v1.0.62

Char is inserted into table as an Integer

Data type not inherited when creating tables by CREATE TABLE x AS SELECT * FROM y WHERE ...

SQLiteConnection.GetSchema("DataTypes") throws System.Resources.MissingManifestResourceException