Any SQLITE Guru's around?

[ChrisL]

I've got a query which doesn't work.

UPDATE PrintsCD SET p6x4 = p6x4 +1 Where (Select ID from IMAGETABLE WHERE isPrintable='True');

The items which "isPrintable" equals False in IMAGETABLE still get updated in PrintsCD, any ideas please?

[jvanegmond]

You're saying: Where {1,2,3,4,5,6}. A list of IDs is forced to evaluate to true/false. It should be more like:

UPDATE PrintsCD SET p6x4 = p6x4 +1 Where ID IN (Select ID from IMAGETABLE WHERE isPrintable='True');

[ChrisL]

Thanks Manadar perfect