Error: Unknown Column (Resolved)

[Paradox]

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

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

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

[badbee]

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!

[badbee]

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

[Paradox]

Thanks badbee solved it