#17 BLOB not Handled Correctly

closed-fixed
nobody
None
5
2004-10-26
2004-10-26
FZelle
No

When there is a blob field in a Version 3 db,
the SchemaTable-Info isn't correct, resulting
in not being able to use DataAdapter/CommandBuilder
for Updateing the DB.

I have changed SQLiteDataReader.EnhanceSchemaTable
the following way.

After ->
row["IsAutoIncrement"] = primaryKey && string.Compare
(type,"INTEGER",true) == 0;

Insert ->
if (type.ToLower() == "blob")
row["ProviderType"] = Convert.ToInt32(DbType.Binary);

Otherwise keep up the good work ;-)

Discussion

  • Alexander Gavrilov

    • status: open --> closed-fixed
     
  • Alexander Gavrilov

    Logged In: YES
    user_id=1000441

    Corrected in CVS

     

Log in to post a comment.