Re: [sqlite] SQLiteBlob.Create failing "No RowId is available"

Another note: The GUID column will need to be marked as UNIQUE or PRIMARY KEY in the CREATE TABLE statement in order for the BLOB lookup to work properly. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@maili

Re: [sqlite] SQLiteBlob.Create failing "No RowId is available"

Sergio Capozzi wrote: > > It seems the KeyInfo calculation is doing something wrong. > Is there a workaround or is a known bug? > Version 1.0.105.1 > Thanks for the report. This should now be fixed on trunk. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___

Re: [sqlite] SQLiteBlob.Create failing "No RowId is available"

On 6/9/17, Sergio Capozzi 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: > > ("SELE

[sqlite] SQLiteBlob.Create failing "No RowId is available"

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 = 'xx