[sqlite] WITH () AS (SELECT ) help

[jose isaias cabrera]

Greetings, perhaps this is not even possible...

But I am trying to do something like this,

WITH EmailData (name,contact,dstamp) AS
(
  SELECT
 'last, first',
 'first.last at xerox.com',
 '2015-08-25 11:11:11'
)
UPDATE LSOpenProjects SET XtraB = EmailData.dstamp, pmuk = EmailData.contact 
WHERE pmuk = EmailData.name;

But, it's not working.  Is this possible?  Thanks.

jos?