Hi
I am having problems importing a solution into Servoy 8 server due to persistent errors being reported about MySQL Syntax
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'connection_name = 'fm' and tablename = 'test' and columnname = 'created'' at line 1
I have tried the same solution in Servoy 7 and the errors are not being flagged. Is there a difference between the way Servoy 7 and 8 handle database checks on import ?
Its not practical to change to Postgres and the database in question is super simple, it has one table with a Servoy generated id. The whole structure of the database i.e. table and column were created in Servoy with a servoy sequence
Any ideas would be gratefully received.
Best
Gordon