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

Reply via email to