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.

Hi Jeremie,

According to the help file you should be able to this;

Enable all characters to be used in an object or field, including diacritical signs.

USYS$MQL_PARAMS = identifiers : quoted | unquoted

USYS$MQL_PARAMS = ids:quoted | unquoted

Default value is unquoted.

HTH and good luck.

Knut

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.