Why not change it to something along the lines of:
UPDATE QR3PARAMS
SET ED = 1
WHERE
ED is not 1
AND EXISTS (
SELECT 1
FROM CURRENT_MED
WHERE
ID = QR3PARAMS.ID
AND (
TERM_TEXT GLOB 'Sildenafil*'
OR
TERM_TEXT GLOB 'Tadalafil*'
OR
TERM_TEXT GLOB 'Vardenafil*'
)
);
which would leave ED alone if it didn't find anything,
or the following, which would always set it to true or false
UPDATE QR3PARAMS
SET ED = EXISTS (
SELECT 1
FROM CURRENT_MED
WHERE
ID = QR3PARAMS.ID
AND (
TERM_TEXT GLOB 'Sildenafil*'
OR
TERM_TEXT GLOB 'Tadalafil*'
OR
TERM_TEXT GLOB 'Vardenafil*'
)
)
WHERE
ED is not 1
;
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
