927 new features of WINDEV 27, WEBDEV 27 and WINDEV Mobile 27

HFSQL DATABASE 138 N e w f e a t u r e W D W B WM FASTER AND MORE MEMORY- EFFICIENT QUERIES HFSQL 27 improves the performance of different types of queries. "Full scan" queries containing dates are 30% faster. Queries with SQL "TOP", "BOTTOM" or "TOP/BOTTOM" clauses use much less memory. Benefit provided by this new feature of version 27: Faster SQL 139 N e w f e a t u r e W D W B WM TRANSACTIONS BY STEPS: SAVEPOINTS TO DIVIDE TRANSACTIONS INTO PARTS Need to nest transactions? You can use savepoints to roll back to an intermediate point of the transaction. It will be then divided into smaller parts. During the transaction, the HTransactionSavepoint WLan- guage function allows you to define and name a savepoint. To undo the part of the transaction after this point, simply use HTransactionRollbackToSavepoint . You can set multiple savepoints in the same transaction. Benefit provided by this new feature of version 27: Flexibility to resume transactions 140 N e w f e a t u r e W D W B WM NEW "FILE ALIAS" TYPE TO SIMPLIFY PROGRAMMING Aliases have always been available in HFSQL. An alias allows you to perform one or more iterations on a file already in use without affecting the current iteration(s). The use of aliases is simplified in version 27. Simply write: Customers2 is alias of Customers and that's all there is to it! Benefit provided by this new feature of version 27: No more HAlias, HChangeName, HChangeConnection, HChange- Dir, HPass 141 N e w f e a t u r e W D W B WM HEXPORTJSON In version 27, HExportJSON can also be used to export the data file or query to a JSON type in WLanguage, no longer only to a file on disk. Benefit provided by this new feature of version 27: Useful option 142 N e w f e a t u r e W D W B WM STORED PROCEDURES: RETURN RECORDS OR ARRAYS OF RECORDS A stored procedure can return records or an array of records. Programming becomes much more structured. Benefit provided by this new feature of version 27: Faster processing directly on the server 143 N e w f e a t u r e W D W B WM SERVER REPLICATION: LIMIT REPETITIVE NOTIFICATIONS When the connection to the server cannot be established, a message is generated. The number of server connection error notifications is limited so as not clutter up your inbox with the same message. Benefit provided by this new feature of version 27: No spam 144 N e w f e a t u r e W D W B WM INSTALL ASSISTED UNIVERSAL REPLICATION ON YOUR OWN APPLICATION SERVER, IN WINDOWS AND LINUX Universal Assisted Replication can now also be installed on a WEBDEV Application Server. This server can run on Windows or Linux. See new feature 941 Benefit provided by this new feature of version 27: More possibilities Continues page 34... WINDEV 27 WEBDEV 27 WINDEV Mobile 27 New features 32

RkJQdWJsaXNoZXIy NDQ0OA==