Dear experts, I create a link table linkmove to access Mysql's .move table Here is part of the move table definition.
CREATE TABLE `move` ( `Id` int(11) NOT NULL, `Position` int(11) DEFAULT NULL, ) I get following error with select * from linkmove where Id > 200 Column "ID" not found; SQL statement:<http://192.168.0.6:8082/query.do?jsessionid=25cf5e1c297b0824e11d4087cd022c05#> If I add ' to column name Id select * from linkmove where 'id '> 122660; Data conversion error converting "id "; SQL statement:<http://192.168.0.6:8082/query.do?jsessionid=25cf5e1c297b0824e11d4087cd022c05#> Is there workaround for integer type column? Thanks! Chiiwen -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/D8BRAwL-qCoJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
