Ali Dorri wrote:
> I encode the PKs to base64
> [...]
> The PK is a BLOB type, i.e.,
> sql = "CREATE TABLE BC(" \
> "PK BLOB ," \
Why do you store a text value in a blob field?
> "UPDATE BC set Signature = null and PK = null where PK = '%q' ;
That does not update the PK column.
UPDATE BC set Signature = null , PK = null where PK = '%q' ;
^^^^
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
