in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » type (RSS)

Browse by Tags

  • 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

  • SQLite error near "Reine": syntax error

    I would like to read from a XP/visual basic 2008 a db3 database using: BaseMPCommand.CommandText = "SELECT tblPrograms.idProgram, tblPrograms.strTitle, tblPrograms.strDescription FROM tblPrograms WHERE idProgram=" + iteration1.ToString table: tblPrograms cell: strDescription, type:text, data...
    Posted to Bugs (Forum) by ernie74 on 12-29-2008

  • Invalid Cast from String to String.....

    I am using a Table with a String entry. When Inserting, I use a parameterised INSERT of the type DB.String. The value I write to this parameter is also a String, so pretty straightforward there. When I try to read it (Again Parameterised as String) I get an Invalid Cast error! The problem seems to lie...
    Posted to Bugs (Forum) by diddleydoo on 04-24-2008

  • BOOLEAN type support

    The _typeNames in SQLiteConvert doesn't include support for "BOOLEAN". Also, there seem to be some incompatibilities in the formats of some things like DATETIME fields with the product SQLite Expert. (This may really be more of a feature request, but any help would be greatly appreciated...
    Posted to Bugs (Forum) by BondsBW on 12-07-2007
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems