Error: Unknown Column (Resolved)

I have this problem when trying to execute an sql query
it returns an error

Code:

---

Error -2147217900 ([MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Unknown column 'CELEPN0200' in 'where clause') in procedure SavePins of Form frmmain        16          Error

---

the query is

Code:

---

update pins set scratchcard_value =100 where svalue= CELEPN0200

---

My other query is how can i display a message with quotes eg

msgbox ""Hallo""

This is because i think the error occurs because i need to enclose the value CELEPN0200 inside quotes

Thanks

if CELEPN0200 is a static value then it should be enclosed in quotes i.e:

update pins set scratchcard_value =100 where svalue= 'CELEPN0200'

otherwise the value is considered as a database column name! :thumb:

yeah your second question can be solved as:
msgbox chr(34) & "Hello" & chr(34)

Thanks badbee solved it