So I have a Sqlite table [Customers] and a column [CustomerId] which is a Guid but as there is no Guid type in sqlite I have saved it as binary so I thought I could use the statement:
delete from [Customers] where [CustomerId] ='|����8B�����\�'
where |����8B�����\� is my binary representation in my Sqlite explorer, but this returns
(0) Rows Affected
How can I delete a row based on my Id column which is effectively a Guid
Aucun commentaire:
Enregistrer un commentaire