926 new features of WINDEV 26, WEBDEV 26 and WINDEV Mobile 26

145 N e w f e a t u r e W D W B WM START THE SEARCH FOR OPTIMIZATION: ON/OFF You can also start the optimization of queries that are exe- cuted from one given moment ( HSuggestKeyStart ) to an- other ( HSuggestKeyEnd ). This can be useful for optimizing the different queries exe- cuted during a particular process. Benefit provided by this new feature of version 26: Even more precision 146 N e w f e a t u r e W D W B WM TRIGGER: ACCESS THE VALUE OF ITEMS BEFORE MODIFICATION It may be necessary to know the value of the items in the modified record before it is modified or deleted. This is now possible with the HTriggerRecordBefore func- tion. Benefit provided by this new feature of version 26: Extremely useful feature 147 N e w f e a t u r e W D W B WM AUTOMATIC CLEANUP OF "INTER- NAL" WORKING DIRECTORY The HFSQL engine uses a working directory named INTERNAL. In version 26, this directory is regularly emptied, so you won't have to do it anymore. Benefit provided by this new feature of version 26: Automatic cleanup! 148 N e w f e a t u r e W D W B WM DETERMINE IF A TRANSACTION IS IN PROGRESS In version 26, you can determine if a transaction is in progress with the HTransactionInProgress WLanguage function. Benefit provided by this new feature of version 26: Very useful. 149 N e w f e a t u r e W D W B WM ASSISTED UNIVERSAL REPLICATION EDITOR: SIMPLIFIED UI In version 26, the universal assisted replication benefits from clearer and more intuitive help : • File addition plan • Explanation of the different options • Addition of connections from the replication editor • ... Benefit provided by this new feature of version 26: Assisted replication creation is now easier 150 N e w f e a t u r e W D W B WM BACKUPWEBHOOK: CAPTION A Webhook can be used to trigger the execution of a process at the end of the backup. If an error occurs, the caption of the error is returned in addi- tion to the error number. Benefit provided by this new feature of version 26: Additional automation 151 N e w f e a t u r e W D W B WM MISCELLANEOUS The HErrorInfo function supports the hErrCode constant. Benefit provided by this new feature of version 26: Useful without a doubt SQL FUNCTIONS N e w f e a t u r e W D W B WM 152 to 154 3 NEW SQL FUNCTIONS 3 new SQL functions are introduced in version 26. The SQL Intersect clause returns the records found in the 2 specified queries (Intersection). INTERSECT Returns the records found in the 2 specified queries (intersec- tion). YEAR For compatibility with SQL code in MySQL. MONTH For compatibility with SQL code in MySQL. Benefit provided by this new feature of version 26: Enriched SQL WINDEV 26 WEBDEV 26 WINDEV Mobile 26 New features 34

RkJQdWJsaXNoZXIy NDQ0OA==