929 new features in WINDEV, WEBDEV and WINDEV Mobile 2024

HFSQL DATABASE 138 N e w f e a t u r e W D W B WM HFSQL SERVER LANGUAGE The HFSQL server can display messages visible to the end user. In version 2024, these messages are displayed in the language of the end user whenever possible: English, Spanish, French. Benefit of this new feature in version 2024 : Voilà! 139 N e w f e a t u r e W D W B WM HFSQL SERVER REPLICATION To handle special cases of physical corruption of replication files (.HYL), the new WLanguage RSIIgnoreError function, as well as a new option in the HFSQL Control Center allow you to ignore the corrupted part of the file. With this option, you can make available services in production phase. Note it must be used carefully. Benefit of this new feature in version 2024 : Useful the production phase 140 N e w f e a t u r e W D W B WM HFSQL DOCKER The Docker image of the HFSQL server is now available in Debian 12, in multiple languages. Benefit of this new feature in version 2024 : More possibilities N e w f e a t u r e W D W B WM 141 to 145 MISCELLANEOUS • H Q u e r y E x e c u t e d , new function used to determine if a query has already been executed. • The automatic data file modification mechanism now al- lows you to convert items of type Password to type String (passwords are not retrieved). • Server backup: Ability to set the default directory. • You can retrieve the list of files monitored by the WLanguage HlistTrackedFiles function. • Stored procedure: Ability to pass arrays as parameters. Benefit of this new feature in version 2024 : Always more SQL FUNCTIONS 146 N e w f e a t u r e W D W B WM COMPLEX QUERIES: BETTER PERFORMANCE The execution of complex queries is significatly faster in version 2024. Benefit of this new feature in version 2024 : The faster, the better 147 N e w f e a t u r e W D W B WM RETURNING CLAUSE The Returning SQL clause that returns values for insertion,modifi- cation and deletion requests is supported in version 2024. Useful, for example, to retrieve automatic identifiers for rows inserted by the query. Benefit of this new feature in version 2024 : Sharp programming 148 N e w f e a t u r e W D W B WM RENAME TABLES WITH “ALTER TABLE RENAME” Now, you can rename tables using the Alter Table Rename statement. Benefit of this new feature in version 2024 : Rename tables programmatically 149 N e w f e a t u r e W D W B WM SUBDATE, DATE_SUB, ADDDATE... The DATE_SUB, ADDDATE,SUBDATE and DATE_ADD functions are now supported to improve compatibility with certain databases. Benefit of this new feature in version 2024 : Compatibility Continued from page 30 N e w f e a t u r e s i n W I ND E V 2 0 2 4 WE B D E V 2 0 2 4 W I ND E V Mo b i l e 2 0 2 4 32

RkJQdWJsaXNoZXIy NDQ0OA==