Quantcast

Sql.Data.Sqlite BLOB Type Mismatch

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Sql.Data.Sqlite BLOB Type Mismatch

Steven M. McNeese-2
I have a table called Media with an Media column of type BLOB and a
Annotation column of type BLOB.  The Annotation column can be null.  In my
Winform application, I have a dataset for this table and the Media and
Annotation columns are defined as System.Byte[].  When I fill the dataset, I
am getting an error if the first record has a null Annotation but I don't
get the error if the first record has non-null Annotation value.  When it is
null, the Sql.Data.Sqlite Fill method returns a SourceColumn type of Object
instead of System.Byte[] and therefore gets a type mismatch.  If I make that
nullable Annotation column a System.Object in the dataset, it works unless
the first record read has a non-null Annotation value and then I get a type
mismatch between the SourceColumn and the DataColumn.

 

Is there a way to force a System.Byte[] for the SourceColumn even if the
value of the first record is Null?

 

Steve

 

 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...