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
Re: Error: Unknown Column
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:
Re: Error: Unknown Column
yeah your second question can be solved as:
msgbox chr(34) & "Hello" & chr(34)
Re: Error: Unknown Column