Hi all,

I'm not able to create a Blob from thaat table schema


CREATE TABLE "DataBlobs" ( `DataBlobGUID` GUID NOT NULL, `Data` BLOB NOT NULL, 
FOREIGN KEY(`DataBlobGUID`) REFERENCES `DataStream`(`DataStreamGUID`) )


This is my query:

("SELECT rowid, Data FROM DataBlobs WHERE DataBlobGuid = 'xxxxx'", 
CommandBehavior.KeyInfo)

and then SQLiteBlob.Create(reader, 2, true) is failing with "No RowId is 
available"

I downloaded the source code and saw that GetRowId is returning -1 and more 
worring GetDatabaseName(i) and GetTableName(i) are returning "DataBlobGUID".
It seems the KeyInfo calculation is doing something wrong.
Is there a workaround or is a known bug?
Version 1.0.105.1


Best regards,
Sergio Capozzi
sergiocapo...@outlook.com<mailto:sergio.capo...@tiscali.it>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to