Uniface User Forum

 View Only
  • 1.  Reserved Words in MySQL 8

    Posted 07-18-2024 08:15

    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.



    ------------------------------
    Jérémie CEDOLIN
    Proges Plus
    Willems FR
    ------------------------------


  • 2.  RE: Reserved Words in MySQL 8

    PARTNER
    Posted 07-18-2024 08:23
    I think you are looking at the setting identifiers or ids in your $MQL_PARAMS in the asn file. It needs to be set to ‘quoted’ to isolate the fieldnames.

    https://www3.rocketsoftware.com/rocketd3/support/documentation/Uniface/10/uniface/dbmsSupport/dbmsDrivers/_common/options/identifiers.htm



    Regards,

    Iain








    Iain Sharp | Head of Technical Services
    Jonas Metals Software
    iains@jonasmetals.com
    tel +44 (0) 114 201 2200
    <http: www.jonasmetals.com=""> www.jonasmetals.com <https: outlook.office.com/bookwithme/user/997d39a6e5de467e8d015be1a0380183@pcisystems.co.uk?anonymous&ep="pcard"> Book Time With Me




  • 3.  RE: Reserved Words in MySQL 8

    Posted 07-19-2024 11:03

    Thank you Iain,

    It works perfectly.

    Regards,

    Laurent.



    ------------------------------
    Jérémie CEDOLIN
    Proges Plus
    Willems FR
    ------------------------------