I am setting up the page used to update records, and when I am creating my custom query, I am getting this error message: My database connection is verified. So I'm not sure where I'm going wrong. Server error: Unable to retrieve schema information from the query:
UPDATE ALL Tests SET VIEWED= 'UPDATETOVIEWED' WHERE COC="'COC'"
*****************************************
The only other thing I can think of is that UPDATETOVIEWED is going to update a true-false (checkbox) field. Is there some other text that I should be using?
Thanks in advance for your help!