On 6/9/17, Sergio Capozzi <sergiocapo...@outlook.com> wrote: > 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"
That error message, "No RowId is available", is not coming from SQLite. It must be something generated by your wrapper layer. > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users