Uniface User Forum

Hello,

We are now using Uniface 10.4 with MySQL 5.7. These version of MySQL is no longer supported so wre are working to migrate in 8 version.

We have plently of entities that are using the field OF (it means Prodcut Order in french = Order de Fabrication). With version 5.6 and 5.7 of MySQL, this word was not reserved but in 8, it is. So when we Clear/Retrieve en entity with fielf OF, we get an error message : 

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 'OF from V_FABRICATION  where 1=0' at line 1

We thought that Uniface transactions with MySQL "protected" the name of fields and entities by sending :

SELECT `OF`.`V_FABRICATION` from `V_FABRICATION`; 

instead of

SELECT OF.V_FABRICATION from V_FABRICATION; 

Do you know if there is a way to set up Uniface so that all fields and entities to be border by ` (Alt+Gr+7) ?

Regards,

Jérémie.

Hello,

We are now using Uniface 10.4 with MySQL 5.7. These version of MySQL is no longer supported so wre are working to migrate in 8 version.

We have plently of entities that are using the field OF (it means Prodcut Order in french = Order de Fabrication). With version 5.6 and 5.7 of MySQL, this word was not reserved but in 8, it is. So when we Clear/Retrieve en entity with fielf OF, we get an error message : 

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 'OF from V_FABRICATION  where 1=0' at line 1

We thought that Uniface transactions with MySQL "protected" the name of fields and entities by sending :

SELECT `OF`.`V_FABRICATION` from `V_FABRICATION`; 

instead of

SELECT OF.V_FABRICATION from V_FABRICATION; 

Do you know if there is a way to set up Uniface so that all fields and entities to be border by ` (Alt+Gr+7) ?

Regards,

Jérémie.