On 6/9/17, Sergio Capozzi <[email protected]> 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 > [email protected]<mailto:[email protected]> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
