#32 concerning closed bug 1036755 (no Int32 possible)

closed-rejected
nobody
None
5
2005-03-26
2005-03-21
Anonymous
No

It seems that now SQLite.NET returns only Int16(when
declared smallint) and Int64(when declared int or bigint)
but there's no way to return Int32 however when creating
table was declared type integer (not smallint or bigint).
This makes me to use long(s) instead of int(s) in my
program.

Is that correct or I'm just using incorect version of
SQLite.NET?

Thanks XuanYe

Discussion

  • Robert Foster
    Robert Foster
    2005-03-26

    • status: open --> closed-rejected
     
  • Robert Foster
    Robert Foster
    2005-03-26

    Logged In: YES
    user_id=526041

    It is indeed possible, long can be cast into int, the change
    was made so that when a user inserted long values, they
    wouldn't get truncated to int, losing data.

    If you are using a datareader, then try the GetInt32() method.

     
  • Logged In: NO

    But if you are using DataAdapter you always get Int64
    although in database is declared type INTEGER. This I
    consider a bug. It's not always efficient to use DataReader.
    But anyway thanks for answer.