ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / New features
  • Overview
  • New WLanguage functions
  • Improved WLanguage functions
  • New WLanguage properties
  • Improved WLanguage properties
  • New advanced types of WLanguage
  • Improved advanced WLanguage types
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
In version 2024, new functions, properties and data types have been introduced and some have been improved.
New WLanguage functions
WEBDEV - Server codeWindows New WLanguage functions in server code:
AuthImportTokenCreates a web service access token from a token description in JSON format.
Belgium.CheckTaxNumberChecks the validity of a Belgian tax number.
BitcoinCoreBlockCountReturns the size of the blockchain known by the Bitcoin node (i.e. the number of blocks created since January 3, 2009). This makes it possible, for example, to calculate the approximate date of the next halving.
BitcoinCoreConfigureSpecifies the Bitcoin Core server connection parameters, in order to use BitcoinCoreXXXX functions.
BitcoinCoreDateTimeLatestBlockReturns the date and time when the latest block was created.
BitcoinCoreHashRateReturns the number of times per second the sha256 function had to be run to calculate the last block. This number corresponds to a proof of work.
Brazil.CheckTaxNumberChecks the validity of a Brazilian tax number.
Canada.CheckTaxNumberChecks the validity of a Canadian tax number.
CurrentDayReturns the number of the current day in the current month.
DateToDayOfYearReturns the day of the year corresponding to a given date.
DNSQuerySends a query to a DNS server.
dpDriveConnectCreates a connection to Dropbox.
DriveCopyDirectoryCopies a directory on a remote drive to another directory.
DriveCopyFileCopies a single file on a remote drive to another directory on same drive.
DriveCreateDirectoryCreates a directory on the remote drive.
DriveCreateFileCreates a file on the remote drive.
DriveDeleteDirectoryDeletes a directory and its files from a remote drive.
DriveDeleteFileDeletes a file from a remote drive.
DriveDownloadDirectoryDownloads a directory and its files from a remote drive to the user's computer.
DriveDownloadFileDownloads a file from a remote drive to the user's computer.
DriveDownloadGglFileDownloads a Google Docs Editors file from Google Drive in a given compatible format.
DriveListDirectoryLists drive directories.
DriveListFileLists the files in a cloud-based drive directory.
DriveListFileGglLists Google Docs Editors files (Docs, Sheets, etc.) present on Google Drive.
DriveMoveDirectoryMoves a directory and its contents to another directory within a remote drive.
DriveMoveFileMoves a file on a remote drive from one directory to another.
DriveRenameRenames a file or directory on a remote drive.
DriveUploadDirectoryUploads a directory and its contents to a remote drive.
DriveUploadFileUploads a local file to a remote drive.
France.CheckTaxNumberChecks the validity of a French tax number.
GeometryAreaCalculates the area of a given geometry.
GeometryContainDetermines if geometry A contains geometry B.
GeometryConvexHullCalculates the convex hull of the specified geometry.
GeometryCorrectReturns a corrected version of the specified geometry.
GeometryCoverDetermines if geometry A covers geometry B.
GeometryCoveredByDetermines if every point of geometry A lies inside or on the boundary of geometry B.
GeometryCrossCompares two geometries and determines if their intersection spatially crosses.
GeometryDeserializeWKT2DBuilds a 2D geometry from a Well-Known Text (WKT) representation.
GeometryDeserializeWKTGeoBuilds a geometry in geographic coordinates from a Well-Known Text (WKT) representation.
GeometryDifferenceReturns a geometry representing the difference between two geometries.
GeometryDisjointDetermines whether two geometries are disjoint, i.e. whether their intersection is empty.
GeometryDistanceCalculates the distance between two geometries.
GeometryEqualDetermines whether two geometries are spatially equal, i.e. whether the first geometry is included in the second, and vice versa.
GeometryIntersectChecks whether two geometries have a non-empty intersection.
GeometryIntersectionReturns a geometry representing the intersection of two geometries.
GeometryIsValidChecks whether the specified geometry is valid according to the OGC rules.
GeometryLengthCalculates the length of a given geometry.
GeometryOverlapDetermines whether two geometries overlap.
GeometryPerimeterCalculates the perimeter of a given geometry (polygon or multipolygon).
GeometrySerializeDSVSerializes a geometry using the specified DSV format.
GeometrySerializeWKTSerializes a geometry using the Well-Known Text (WKT) format.
GeometrySymmetricDifferenceCalculates the symmetric difference between two geometries.
GeometryTouchDetermines whether two geometries touch.
GeometryUnionReturns a geometry corresponding to the union of two geometries.
GeometryWithinDetermines whether geometry A is completely within geometry B (i.e., geometry B completely contains geometry A).
Germany.CheckTaxNumberChecks the validity of a German tax number.
GglDriveConnectCreates a connection to Google Drive.
gpwListUserGets the list of users in the User Groupware.
grColumnBarTypeDefines the type of bar used in a column chart.
grWaffleSizeDefines the number of rows and columns in a Waffle chart.
grWaffleTypeCellDefines the shape of cells in a Waffle chart.
HInfoItemRightsGets the rights granted to a user or group on an item.
HListSpatialKeysReturns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine.
HListWatchedFilesReturns the list of files watched by HWatch.
HModifyItemRightsModifies the rights granted to a user or group on an item of an HFSQL Client/Server data file.
HOpenComplementaryAnalysisOpens a new analysis, but keeps the main analysis of the application.
HQueryExecutedDetermines if a query has been executed.
HRSIgnoreErrorIgnores errors so that replication between HFSQL servers can continue to run.
InGuidedTourModeIndicates if there is a Guided Tour in progress.
Italy.CheckTaxNumberChecks the validity of an Italian tax number.
JSONToTablePopulates a Table or TreeView Table control with the contents of a JSON string or variable.
Linestring2DAddPointAdds a new point to a 2D linestring.
LinestringGeoAddPointAdds a new point to a geographic linestring.
MarkdownLinkAdds a clickable link in a Markdown string. This makes it possible to add a link in a control that supports Markdown format.
ModbusConnectRTUConnects a client to a Modbus slave via a serial port.
ModbusConnectTCPConnects a client to a Modbus server via transmission control protocol (TCP).
ModbusDisconnectCloses the Modbus session.
ModbusReadBitReads one or more bits from a Modbus slave, starting at a specific address.
ModbusReadFloatReads one or more single-precision floats from a Modbus slave, starting at a specific address.
ModbusReadRegisterReads one or more registers from a Modbus slave, starting at a specific address.
ModbusSendRawFrameSends a raw frame to a Modbus slave. This enables communication with devices that do not strictly comply with the Modbus standard.
ModbusWriteBitWrites one or multiple bits to a specific address in a Modbus slave.
ModbusWriteFloatWrites one or more single-precision floats to a Modbus slave, starting at a specific address.
ModbusWriteRegisterWrites one or more registers (16-bit values) to a Modbus slave, starting at a specific address.
NotifPushSendSubscriberSends a notification to Android devices that are subscribed to a topic.
oDriveConnectCreates a connection to OneDrive.
PageWriteCustomHTTPCodeSpecifies the custom HTTP code that will be returned to the client after the server code of the page is executed.
PageWriteHTTPCodeSpecifies the HTTP code that will be returned to the client after the server code of the page is executed.
RedisDisconnectCloses a connection to a Redis server (or cluster).
Spain.CheckTaxNumberChecks the validity of a Spanish tax number.
Switzerland.CheckTaxNumberChecks the validity of a Swiss tax number.
TableToJSONConverts the contents of a Table or TreeView Table control to a JSON string.
UnitedStates.CheckTaxNumberChecks the validity of a US tax number.
UTF8ValidChecks the validity of a UTF-8 string.
WBAdminDeleteApplicationDeletes an application from a WEBDEV Application Server.
WBAdminListApplicationReturns the list of applications on a WEBDEV Application Server, for a given account and a given type.
WLanguageCodeFormatApplies formatting to WLanguage code: syntax highlighting, style standardization, indentation, translation, etc.
WLanguageCodeGetCSSDeclarationsReturns a CSS style sheet corresponding to a WLanguage code theme.
xlsCoordinatesToNameRetrieves the name of a cell, XLS worksheet or Spreadsheet control according to its coordinates.
xlsNameToCoordinatesReturns the coordinates of a cell, XLS file or spreadsheet control according to its name.
XMLVerifySignatureVerifies the signature of an XML node.
New WLanguage functions (prefix syntax) in Server code:
<Buffer type>.UTF8ValidChecks the validity of a UTF-8 buffer.
<Chart>.ColumnBarTypeDefines the type of bar used in a column chart.
<Chart>.WaffleSizeDefines the number of rows and columns in a Waffle chart.
<Chart>.WaffleTypeCellDefines the shape of cells in a Waffle chart.
<Connection variable>.InfoItemRightsGets the rights granted to a user or group on an item.
<Connection variable>.ListWatchedFilesReturns the list of files watched by HWatch.
<Connection variable>.ModifyItemRightsSets the rights granted to a user or group on an item of an HFSQL Client/Server data file.
<Drive variable>.CopyDirectoryCopies a directory on a remote drive to another directory.
<Drive variable>.CopyFileCopies a single file on a remote drive to another directory on same drive.
<Drive variable>.CreateDirectoryCreates a directory on the remote drive.
<Drive variable>.CreateFileCreates a file on the remote drive.
<Drive variable>.DeleteDirectoryDeletes a directory and its files from a remote drive.
<Drive variable>.DeleteFileDeletes a file from a remote drive.
<Drive variable>.DownloadDirectoryDownloads a directory and its files from a remote drive to the user's computer.
<Drive variable>.DownloadFileDownloads a file from a remote drive to the user's computer.
<Drive variable>.ListDirectoryLists drive directories.
<Drive variable>.ListFileLists the files in a cloud-based drive directory.
<Drive variable>.MoveDirectoryMoves a directory and its contents to another directory within a remote drive.
<Drive variable>.MoveFileMoves a file on a remote drive from one directory to another.
<Drive variable>.RenameRenames a file or directory on a remote drive.
<Drive variable>.UploadDirectoryUploads a directory and its contents to a remote drive.
<Drive variable>.UploadFileUploads a local file to a remote drive.
<gglDrive variable>.CopyFileCopies a single file on a remote drive to another directory on same drive.
<gglDrive variable>.DeleteFileDeletes a Google Docs Editor file from Google Drive.
<gglDrive variable>.DownloadGglFileDownloads a Google Docs Editors file from Google Drive in a given compatible format.
<gglDrive variable>.ListFileGglLists Google Docs Editors files (Docs, Sheets, etc.) present on Google Drive.
<gglDrive variable>.MoveFileMoves a file on a remote drive from one directory to another.
<gglDrive variable>.RenameRenames a directory or Google Docs Editors file on Google Drive.
<HFSQL connection>.RSIgnoreErrorIgnores errors so that replication between HFSQL servers can continue to run.
<Linestring2D variable>.AddPointAdds a new point to a 2D linestring.
<LinestringGeo variable>.AddPointAdds a new point to a geographic linestring.
<modbusSession>.DisconnectCloses the Modbus session.
<modbusSession>.ReadBitReads one or more bits from a Modbus slave, starting at a specific address.
<modbusSession>.ReadFloatReads one or more single-precision floats from a Modbus slave, starting at a specific address.
<modbusSession>.ReadRegisterReads one or more registers from a Modbus slave, starting at a specific address.
<modbusSession>.SendRawFrameSends a raw frame to a Modbus slave. This enables communication with devices that do not strictly comply with the Modbus standard.
<modbusSession>.WriteBitWrites one or multiple bits to a specific address in a Modbus slave.
<modbusSession>.WriteFloatWrites one or more single-precision floats to a Modbus slave, starting at a specific address.
<modbusSession>.WriteRegisterWrites one or more registers (16-bit values) to a Modbus slave, starting at a specific address.
<Notification variable>.SendPushSends a push notification to a mobile device (iOS or Android).
<Notification variable>.SendPushSubscriberSends a notification to Android devices that are subscribed to a topic.
<pdfDocument variable>.ExtractPageExtracts a page from a PDF file in a variable of type Image.
<pdfDocument variable>.SignApplies an approval signature to an existing PDF.
<pdfDocument variable>.ToTextExtracts text from a PDF file.
<Polygon2D variable>.AreaCalculates the area of a polygon defined using 2D coordinates.
<Polygon2D variable>.ContainDetermines if geometry A (of type 2D polygon) contains geometry B.
<Polygon2D variable>.ConvexHullCalculates the convex hull of the specified 2D polygon.
<Polygon2D variable>.CorrectReturns a corrected version of the specified 2D polygon.
<Polygon2D variable>.CoverDetermines if geometry A (of type 2D polygon) covers geometry B.
<Polygon2D variable>.CoveredByDetermines if every point of geometry A (2D polygon) lies inside or on the boundary of geometry B.
<Polygon2D variable>.CrossDetermines if a 2D polygon crosses another geometry.
<Polygon2D variable>.DifferenceReturns a geometry representing the difference between a 2D polygon and another geometry.
<Polygon2D variable>.DisjointDetermines whether two geometries are disjoint, i.e. whether their intersection is empty.
<Polygon2D variable>.DistanceCalculates the distance between a 2D polygon and another geometry.
<Polygon2D variable>.EqualDetermines whether two geometries are spatially equal, i.e. whether the first geometry is included in the second, and vice versa.
<Polygon2D variable>.IntersectChecks whether the intersection of a 2D polygon and another geometry does not result in an empty set.
<Polygon2D variable>.IntersectionReturns a geometry representing the intersection between a 2D polygon and another geometry.
<Polygon2D variable>.IsValidChecks whether the specified 2D polygon is valid according to the OGC rules.
<Polygon2D variable>.OverlapDetermines if a 2D polygon overlaps another geometry.
<Polygon2D variable>.PerimeterCalculates the perimeter of a polygon defined using 2D coordinates.
<Polygon2D variable>.SerializeWKTSerializes a 2D polygon using the Well-Known Text (WKT) format.
<Polygon2D variable>.SymmetricDifferenceCalculates the symmetric difference between a 2D polygon and another geometry.
<Polygon2D variable>.TouchDetermines whether a 2D polygon touches another geometry.
<Polygon2D variable>.UnionReturns a geometry corresponding to the union between a 2D polygon and another geometry.
<Polygon2D variable>.WithinDetermines whether geometry A (2D polygon) is completely within geometry B (i.e., geometry B completely contains geometry A).
<PolygonGeo variable>.AreaCalculates the area of a polygon defined using geographic coordinates.
<PolygonGeo variable>.ContainDetermines if geometry A (of type geographic polygon) contains geometry B.
<PolygonGeo variable>.ConvexHullCalculates the convex hull of the specified geographic polygon.
<PolygonGeo variable>.CorrectReturns a corrected version of the specified geographic polygon.
<PolygonGeo variable>.CoverDetermines if geometry A (of type geographic polygon) covers geometry B.
<PolygonGeo variable>.CoveredByDetermines if every point of geometry A (geographic polygon) lies inside or on the boundary of geometry B.
<PolygonGeo variable>.CrossDetermines if a geographic polygon crosses another geometry.
<PolygonGeo variable>.DifferenceReturns a geometry representing the difference between a geographic polygon and another geometry.
<PolygonGeo variable>.DisjointDetermines whether two geometries are disjoint, i.e. whether their intersection is empty.
<PolygonGeo variable>.DistanceCalculates the distance between a geographic polygon and another geometry.
<PolygonGeo variable>.EqualDetermines whether two geometries are spatially equal, i.e. whether the first geometry is included in the second, and vice versa.
<PolygonGeo variable>.IntersectChecks whether the intersection of a geographic polygon and another geometry does not result in an empty set.
<PolygonGeo variable>.IntersectionReturns a geometry representing the intersection between a geographic polygon and another geometry.
<PolygonGeo variable>.IsValidChecks whether the specified geographic polygon is valid according to the OGC rules.
<PolygonGeo variable>.OverlapDetermines if a geographic polygon overlaps another geometry.
<PolygonGeo variable>.PerimeterCalculates the perimeter of a geographic polygon.
<PolygonGeo variable>.SerializeWKTSerializes a geographic polygon using the Well-Known Text (WKT) format.
<PolygonGeo variable>.SymmetricDifferenceCalculates the symmetric difference between a geographic polygon and another geometry.
<PolygonGeo variable>.TouchDetermines whether a geographic polygon touches another geometry.
<PolygonGeo variable>.UnionReturns a geometry corresponding to the union between a geographic polygon and another geometry.
<PolygonGeo variable>.WithinDetermines whether geometry A (geographic polygon) is completely within geometry B (i.e., geometry B completely contains geometry A).
<redisConnection variable>.DisconnectCloses a connection to a Redis server (or cluster).
<Source>.ListSpatialKeysReturns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine.
<Source>.QueryExecutedDetermines if a query has been executed.
<Table>.fromJSONPopulates a Table or TreeView Table control with the contents of a JSON string or variable.
<Table>.ToJSONConverts the contents of a Table or TreeView Table control to a JSON string.
<WBadminAuth variable>.DeleteApplicationDeletes an application from a WEBDEV Application Server.
<WBadminAuth variable>.ListApplicationReturns the list of applications on a WEBDEV Application Server, for a given account and a given type.
<WLanguageCodeFormatting>.FormatApplies formatting to WLanguage code: syntax highlighting, style standardization, indentation and translation.
WEBDEV - Server codeLinux New WLanguage functions for WEBDEV in Linux:
AuthImportTokenCreates a web service access token from a token description in JSON format.
Belgium.CheckTaxNumberChecks the validity of a Belgian tax number.
BitcoinCoreBlockCountReturns the size of the blockchain known by the Bitcoin node (i.e. the number of blocks created since January 3, 2009). This makes it possible, for example, to calculate the approximate date of the next halving.
BitcoinCoreConfigureSpecifies the Bitcoin Core server connection parameters, in order to use BitcoinCoreXXXX functions.
BitcoinCoreDateTimeLatestBlockReturns the date and time when the latest block was created.
BitcoinCoreHashRateReturns the number of times per second the sha256 function had to be run to calculate the last block. This number corresponds to a proof of work.
Brazil.CheckTaxNumberChecks the validity of a Brazilian tax number.
Canada.CheckTaxNumberChecks the validity of a Canadian tax number.
CurrentDayReturns the number of the current day in the current month.
DateToDayOfYearReturns the day of the year corresponding to a given date.
DNSQuerySends a query to a DNS server.
dpDriveConnectCreates a connection to Dropbox.
DriveCopyDirectoryCopies a directory on a remote drive to another directory.
DriveCopyFileCopies a single file on a remote drive to another directory on same drive.
DriveCreateDirectoryCreates a directory on the remote drive.
DriveCreateFileCreates a file on the remote drive.
DriveDeleteDirectoryDeletes a directory and its files from a remote drive.
DriveDeleteFileDeletes a file from a remote drive.
DriveDownloadDirectoryDownloads a directory and its files from a remote drive to the user's computer.
DriveDownloadFileDownloads a file from a remote drive to the user's computer.
DriveListDirectoryLists drive directories.
DriveListFileLists the files in a cloud-based drive directory.
DriveMoveDirectoryMoves a directory and its contents to another directory within a remote drive.
DriveMoveFileMoves a file on a remote drive from one directory to another.
DriveRenameRenames a file or directory on a remote drive.
DriveUploadDirectoryUploads a directory and its contents to a remote drive.
DriveUploadFileUploads a local file to a remote drive.
France.CheckTaxNumberChecks the validity of a French tax number.
GeometryAreaCalculates the area of a given geometry.
GeometryContainDetermines if geometry A contains geometry B.
GeometryConvexHullCalculates the convex hull of the specified geometry.
GeometryCorrectReturns a corrected version of the specified geometry.
GeometryCoverDetermines if geometry A covers geometry B.
GeometryCoveredByDetermines if every point of geometry A lies inside or on the boundary of geometry B.
GeometryCrossCompares two geometries and determines if their intersection spatially crosses.
GeometryDeserializeWKT2DBuilds a 2D geometry from a Well-Known Text (WKT) representation.
GeometryDeserializeWKTGeoBuilds a geometry in geographic coordinates from a Well-Known Text (WKT) representation.
GeometryDifferenceReturns a geometry representing the difference between two geometries.
GeometryDisjointDetermines whether two geometries are disjoint, i.e. whether their intersection is empty.
GeometryDistanceCalculates the distance between two geometries.
GeometryEqualDetermines whether two geometries are spatially equal, i.e. whether the first geometry is included in the second, and vice versa.
GeometryIntersectChecks whether two geometries have a non-empty intersection.
GeometryIntersectionReturns a geometry representing the intersection of two geometries.
GeometryIsValidChecks whether the specified geometry is valid according to the OGC rules.
GeometryLengthCalculates the length of a given geometry.
GeometryOverlapDetermines whether two geometries overlap.
GeometryPerimeterCalculates the perimeter of a given geometry (polygon or multipolygon).
GeometrySerializeDSVSerializes a geometry using the specified DSV format.
GeometrySerializeWKTSerializes a geometry using the Well-Known Text (WKT) format.
GeometryTouchDetermines whether two geometries touch.
GeometryUnionReturns a geometry corresponding to the union of two geometries.
GeometryWithinDetermines whether geometry A is completely within geometry B (i.e., geometry B completely contains geometry A).
Germany.CheckTaxNumberChecks the validity of a German tax number.
GglDriveConnectCreates a connection to Google Drive.
gpwListUserGets the list of users in the User Groupware.
grWaffleSizeDefines the number of rows and columns in a Waffle chart.
grWaffleTypeCellDefines the shape of cells in a Waffle chart.
hbCreateTableCreates an HBase table or modifies the description of an HBase table.
HInfoItemRightsGets the rights granted to a user or group on an item.
HListSpatialKeysReturns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine.
HListWatchedFilesReturns the list of files watched by HWatch.
HModifyItemRightsModifies the rights granted to a user or group on an item of an HFSQL Client/Server data file.
HOpenComplementaryAnalysisOpens a new analysis, but keeps the main analysis of the application.
HQueryExecutedDetermines if a query has been executed.
Italy.CheckTaxNumberChecks the validity of an Italian tax number.
JSONToTablePopulates a Table or TreeView Table control with the contents of a JSON string or variable.
Linestring2DAddPointAdds a new point to a 2D linestring.
LinestringGeoAddPointAdds a new point to a geographic linestring.
ModbusConnectRTUConnects a client to a Modbus slave via a serial port.
ModbusConnectTCPConnects a client to a Modbus server via transmission control protocol (TCP).
ModbusDisconnectCloses the Modbus session.
ModbusReadBitReads one or more bits from a Modbus slave, starting at a specific address.
ModbusReadFloatReads one or more single-precision floats from a Modbus slave, starting at a specific address.
ModbusReadRegisterReads one or more registers from a Modbus slave, starting at a specific address.
ModbusSendRawFrameSends a raw frame to a Modbus slave. This enables communication with devices that do not strictly comply with the Modbus standard.
ModbusWriteBitWrites one or multiple bits to a specific address in a Modbus slave.
ModbusWriteFloatWrites one or more single-precision floats to a Modbus slave, starting at a specific address.
ModbusWriteRegisterWrites one or more registers (16-bit values) to a Modbus slave, starting at a specific address.
oDriveConnectCreates a connection to OneDrive.
PageWriteCustomHTTPCodeSpecifies the custom HTTP code that will be returned to the client after the server code of the page is executed.
PageWriteHTTPCodeSpecifies the HTTP code that will be returned to the client after the server code of the page is executed.
RedisDisconnectCloses a connection to a Redis server (or cluster).
Spain.CheckTaxNumberChecks the validity of a Spanish tax number.
Switzerland.CheckTaxNumberChecks the validity of a Swiss tax number.
TableToJSONConverts the contents of a Table or TreeView Table control to a JSON string.
UnitedStates.CheckTaxNumberChecks the validity of a US tax number.
UTF8ValidChecks the validity of a UTF-8 string.
WBAdminDeleteApplicationDeletes an application from a WEBDEV Application Server.
WBAdminListApplicationReturns the list of applications on a WEBDEV Application Server, for a given account and a given type.
xlsCoordinatesToNameRetrieves the name of a cell, XLS worksheet or Spreadsheet control according to its coordinates.
xlsNameToCoordinatesReturns the coordinates of a cell, XLS file or spreadsheet control according to its name.
XMLVerifySignatureVerifies the signature of an XML node.
New WLanguage functions (prefix syntax) for WEBDEV in Linux:
<Buffer type>.UTF8ValidChecks the validity of a UTF-8 buffer.
<Chart>.WaffleSizeDefines the number of rows and columns in a Waffle chart.
<Chart>.WaffleTypeCellDefines the shape of cells in a Waffle chart.
<Connection variable>.InfoItemRightsGets the rights granted to a user or group on an item.
<Connection variable>.ListWatchedFilesReturns the list of files watched by HWatch.
<Connection variable>.ModifyItemRightsSets the rights granted to a user or group on an item of an HFSQL Client/Server data file.
<Drive variable>.CopyDirectoryCopies a directory on a remote drive to another directory.
<Drive variable>.CopyFileCopies a single file on a remote drive to another directory on same drive.
<Drive variable>.CreateDirectoryCreates a directory on the remote drive.
<Drive variable>.CreateFileCreates a file on the remote drive.
<Drive variable>.DeleteDirectoryDeletes a directory and its files from a remote drive.
<Drive variable>.DeleteFileDeletes a file from a remote drive.
<Drive variable>.DownloadDirectoryDownloads a directory and its files from a remote drive to the user's computer.
<Drive variable>.DownloadFileDownloads a file from a remote drive to the user's computer.
<Drive variable>.ListDirectoryLists drive directories.
<Drive variable>.ListFileLists the files in a cloud-based drive directory.
<Drive variable>.MoveDirectoryMoves a directory and its contents to another directory within a remote drive.
<Drive variable>.MoveFileMoves a file on a remote drive from one directory to another.
<Drive variable>.RenameRenames a file or directory on a remote drive.
<Drive variable>.UploadDirectoryUploads a directory and its contents to a remote drive.
<Drive variable>.UploadFileUploads a local file to a remote drive.
<gglDrive variable>.CopyFileCopies a single file on a remote drive to another directory on same drive.
<gglDrive variable>.DeleteFileDeletes a Google Docs Editor file from Google Drive.
<gglDrive variable>.DownloadGglFileDownloads a Google Docs Editors file from Google Drive in a given compatible format.
<gglDrive variable>.ListFileGglLists Google Docs Editors files (Docs, Sheets, etc.) present on Google Drive.
<gglDrive variable>.MoveFileMoves a file on a remote drive from one directory to another.
<gglDrive variable>.RenameRenames a directory or Google Docs Editors file on Google Drive.
<Linestring2D variable>.AddPointAdds a new point to a 2D linestring.
<LinestringGeo variable>.AddPointAdds a new point to a geographic linestring.
<modbusSession>.DisconnectCloses the Modbus session.
<modbusSession>.ReadBitReads one or more bits from a Modbus slave, starting at a specific address.
<modbusSession>.ReadFloatReads one or more single-precision floats from a Modbus slave, starting at a specific address.
<modbusSession>.ReadRegisterReads one or more registers from a Modbus slave, starting at a specific address.
<modbusSession>.SendRawFrameSends a raw frame to a Modbus slave. This enables communication with devices that do not strictly comply with the Modbus standard.
<modbusSession>.WriteBitWrites one or multiple bits to a specific address in a Modbus slave.
<modbusSession>.WriteFloatWrites one or more single-precision floats to a Modbus slave, starting at a specific address.
<modbusSession>.WriteRegisterWrites one or more registers (16-bit values) to a Modbus slave, starting at a specific address.
<pdfDocument variable>.ExtractPageExtracts a page from a PDF file in a variable of type Image.
<pdfDocument variable>.ToTextExtracts text from a PDF file.
<Polygon2D variable>.AreaCalculates the area of a polygon defined using 2D coordinates.
<Polygon2D variable>.ContainDetermines if geometry A (of type 2D polygon) contains geometry B.
<Polygon2D variable>.ConvexHullCalculates the convex hull of the specified 2D polygon.
<Polygon2D variable>.CorrectReturns a corrected version of the specified 2D polygon.
<Polygon2D variable>.CoverDetermines if geometry A (of type 2D polygon) covers geometry B.
<Polygon2D variable>.CoveredByDetermines if every point of geometry A (2D polygon) lies inside or on the boundary of geometry B.
<Polygon2D variable>.CrossDetermines if a 2D polygon crosses another geometry.
<Polygon2D variable>.DifferenceReturns a geometry representing the difference between a 2D polygon and another geometry.
<Polygon2D variable>.DisjointDetermines whether two geometries are disjoint, i.e. whether their intersection is empty.
<Polygon2D variable>.DistanceCalculates the distance between a 2D polygon and another geometry.
<Polygon2D variable>.EqualDetermines whether two geometries are spatially equal, i.e. whether the first geometry is included in the second, and vice versa.
<Polygon2D variable>.IntersectChecks whether the intersection of a 2D polygon and another geometry does not result in an empty set.
<Polygon2D variable>.IntersectionReturns a geometry representing the intersection between a 2D polygon and another geometry.
<Polygon2D variable>.IsValidChecks whether the specified 2D polygon is valid according to the OGC rules.
<Polygon2D variable>.OverlapDetermines if a 2D polygon overlaps another geometry.
<Polygon2D variable>.PerimeterCalculates the perimeter of a polygon defined using 2D coordinates.
<Polygon2D variable>.SerializeWKTSerializes a 2D polygon using the Well-Known Text (WKT) format.
<Polygon2D variable>.SymmetricDifferenceCalculates the symmetric difference between a 2D polygon and another geometry.
<Polygon2D variable>.TouchDetermines whether a 2D polygon touches another geometry.
<Polygon2D variable>.UnionReturns a geometry corresponding to the union between a 2D polygon and another geometry.
<Polygon2D variable>.WithinDetermines whether geometry A (2D polygon) is completely within geometry B (i.e., geometry B completely contains geometry A).
<PolygonGeo variable>.AreaCalculates the area of a polygon defined using geographic coordinates.
<PolygonGeo variable>.ContainDetermines if geometry A (of type geographic polygon) contains geometry B.
<PolygonGeo variable>.ConvexHullCalculates the convex hull of the specified geographic polygon.
<PolygonGeo variable>.CorrectReturns a corrected version of the specified geographic polygon.
<PolygonGeo variable>.CoverDetermines if geometry A (of type geographic polygon) covers geometry B.
<PolygonGeo variable>.CoveredByDetermines if every point of geometry A (geographic polygon) lies inside or on the boundary of geometry B.
<PolygonGeo variable>.CrossDetermines if a geographic polygon crosses another geometry.
<PolygonGeo variable>.DifferenceReturns a geometry representing the difference between a geographic polygon and another geometry.
<PolygonGeo variable>.DisjointDetermines whether two geometries are disjoint, i.e. whether their intersection is empty.
<PolygonGeo variable>.DistanceCalculates the distance between a geographic polygon and another geometry.
<PolygonGeo variable>.EqualDetermines whether two geometries are spatially equal, i.e. whether the first geometry is included in the second, and vice versa.
<PolygonGeo variable>.IntersectChecks whether the intersection of a geographic polygon and another geometry does not result in an empty set.
<PolygonGeo variable>.IntersectionReturns a geometry representing the intersection between a geographic polygon and another geometry.
<PolygonGeo variable>.IsValidChecks whether the specified geographic polygon is valid according to the OGC rules.
<PolygonGeo variable>.OverlapDetermines if a geographic polygon overlaps another geometry.
<PolygonGeo variable>.PerimeterCalculates the perimeter of a geographic polygon.
<PolygonGeo variable>.SerializeWKTSerializes a geographic polygon using the Well-Known Text (WKT) format.
<PolygonGeo variable>.SymmetricDifferenceCalculates the symmetric difference between a geographic polygon and another geometry.
<PolygonGeo variable>.TouchDetermines whether a geographic polygon touches another geometry.
<PolygonGeo variable>.UnionReturns a geometry corresponding to the union between a geographic polygon and another geometry.
<PolygonGeo variable>.WithinDetermines whether geometry A (geographic polygon) is completely within geometry B (i.e., geometry B completely contains geometry A).
<redisConnection variable>.DisconnectCloses a connection to a Redis server (or cluster).
<Source>.ListSpatialKeysReturns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine.
<Source>.QueryExecutedDetermines if a query has been executed.
<Table>.fromJSONPopulates a Table or TreeView Table control with the contents of a JSON string or variable.
<Table>.ToJSONConverts the contents of a Table or TreeView Table control to a JSON string.
<WBadminAuth variable>.DeleteApplicationDeletes an application from a WEBDEV Application Server.
<WBadminAuth variable>.ListApplicationReturns the list of applications on a WEBDEV Application Server, for a given account and a given type.
PHP New WLanguage functions for PHP:
ArrayDeleteDuplicateDeletes the duplicates from an array.
ArrayDistinctReturns an array without duplicates.
ArrayIntersectReturns an array corresponding to the intersection of two arrays.
ArrayShuffleShuffles the elements of a WLanguage array.
ArrayUnionReturns an array corresponding to the union of two arrays.
ArrayUnionAllReturns an array corresponding to the union of two arrays (without deleting duplicates).
grWaffleSizeDefines the number of rows and columns in a Waffle chart.
grWaffleTypeCellDefines the shape of cells in a Waffle chart.
WordToArrayFills an array with the words from a string.
New WLanguage functions (prefix syntax) for PHP:
<Array>.DeleteDuplicateDeletes the duplicates from an array.
<Array>.DistinctReturns an array without duplicates.
<Array>.IntersectReturns an array corresponding to the intersection of two arrays.
<Array>.ShuffleShuffles the elements of a WLanguage array.
<Array>.UnionReturns an array corresponding to the union of two arrays.
<Array>.UnionAllReturns an array corresponding to the union of two arrays (without deleting duplicates).
<Chart>.WaffleSizeDefines the number of rows and columns in a Waffle chart.
<Chart>.WaffleTypeCellDefines the shape of cells in a Waffle chart.
WEBDEV - Browser code New WLanguage functions for WEBDEV in browser code:
BrowserShareStarts the device's native share functionality.
GuidedTourChangeStepMoves to another step of the Guided Tour.
GuidedTourInfoReturns information about a Guided Tour.
GuidedTourStartStarts the Guided Tour and displays the first step.
GuidedTourStopStops the current Guided Tour or another specified Guided Tour.
InGuidedTourModeIndicates if there is a Guided Tour in progress.
SysThemeReturns the visual theme currently displayed on the current workstation.
New WLanguage functions (prefix syntax) for WEBDEV in browser code:
<GuidedTour>.ChangeStepMoves to another step of the Guided Tour.
<GuidedTour>.InfoReturns information about a Guided Tour.
<GuidedTour>.StartStarts the Guided Tour and displays the first step.
<GuidedTour>.StopStops the current Guided Tour or another specified Guided Tour.
<Notification variable>.AddAdds a notification to the system bar (Android) or notification center (iOS).
<Notification variable>.DeleteRemoves a notification from the system bar.
Improved WLanguage functions
WEBDEV - Server codeWindowsLinux The following functions have been improved in this version:
AIDetectModelOpen Neural Network Exchange (ONNX) support.
ApplyCan be used with arrays associations.
AuthIdentifyNew syntax for using the JWT protocol.
ChangeSourcePageThis function is now available in AJAX.
CompileNew parameter to define compiler options (authorized and non-authorized WLanguage functions, etc.).
CookieWriteNew constants to better manage the SameSite cookie attribute.
dArcNew syntax to draw an arc within an area defined with a variable of type Rectangle.
dChordNew syntax to draw a chord within an area defined with a variable of type Rectangle.
dCircleNew syntax to draw a circle within an area defined with a variable of type Rectangle.
dCopyNew syntax to copy an area defined with a variable of type Rectangle.
dCropNew syntax to crop an image within an area defined with a variable of type Rectangle.
dSliceNew syntax to draw a section within an area defined with a variable of type Rectangle.
EvaluateExpressionNew parameter to define compiler options (authorized and non-authorized WLanguage functions, etc.).
ExecuteCodeNew parameter to define compiler options (authorized and non-authorized WLanguage functions, etc.).
FilterCan be used with arrays associations.
fReadLineNew syntax to read a line using a WLanguage procedure.
grColumnSpacingNow lets you define the spacing between cells in a Waffle chart.
grCreateNew constant to manage Waffle charts.
grSeriesTypeNew constant to manage Waffle charts.
grTooltipNew constant to manage Waffle charts.
grTypeNew constant to manage Waffle charts.
HBackupSpatial indexes are taken into account when making backup copies.
HCopyFileSpatial indexes are taken into account when copying data files.
HDeleteFileSpatial indexes are taken into account when deleting data files.
HDuplicateDatabaseSpatial indexes are taken into account when duplicating databases.
HIndexNew constant for reindexing spatial indexes.
HInfoFileNew constant to manage spatial indexes.
HRestoreBackupSpatial indexes are taken into account when restoring backup copies.
HSetServerNew constant for backup directory settings.
NumToStringAbility to set the conversion format using a variable of type NumericFormat.
PDFExtractPageNew syntax to extract a page from a PDF document (pdfDocument variable) as an image.
PDFSignNew syntax to sign PDF documents (pdfDocument variable).
PDFToTextNew syntax to get the text of a page in a PDF document (pdfDocument variable).
ReduceCan be used with arrays associations.
SysWindowsVersionsysNativeProcessor, new constant to determine the processor of the current computer.
TransformeCan be used with arrays associations.
WBAdminCreateAccountNew constant to recreate an existing account.
XMLOpenNew parameter to specify the XML code analysis mode.
PHP The following functions have been improved in this version:
grColumnSpacingNow lets you define the spacing between cells in a Waffle chart.
grCreateNew constant to manage Waffle charts.
grSeriesTypeNew constant to manage Waffle charts.
grTooltipNew constant to manage Waffle charts.
grTypeNew constant to manage Waffle charts.
New WLanguage properties
WEBDEV - Server codeWindows New WLanguage properties:
MaskingRuleThe MaskingRule property gets the masking rule applied to a data file item.
WEBDEV - Server codeLinux New WLanguage properties:
MaskingRuleThe MaskingRule property gets the masking rule applied to a data file item.
Improved WLanguage properties
WEBDEV - Server code The following properties have been modified in this version:
TypeNew constants to manipulate items with spatial data.
WEBDEV - Browser code The following properties have been modified in this version:
ExtraThe Extra is now available for all types of controls in read-only mode.
New advanced types of WLanguage
WEBDEV - Server codeWindows New WLanguage types for WEBDEV applications:
docElémentInterrupteurType décrivant les checkbox utilisables pour la creation de formulaire
Le type docElémentInterrupteur permet de définir toutes les caractéristiques avancées d'un XXX. Les caractéristiques de ce XXX peuvent être définies et modifiées à l'aide de différentes propriétés WLangage.
DriveThe Drive type is used to handle online storage services. To use this type of variable, you need to connect to the desired service.
gglDriveThe gglDrive type is used to handle Google Drive. To use a gglDrive variable, you need to connect to Google Drive using GglDriveConnect.
GglFileThe GglFile type is used to get all the characteristics of a file used in one of the Google Docs Editors (Docs, Sheets, etc.).
Linestring2DThe Linestring2D type is used to define all the advanced characteristics of a linestring defined with 2D coordinates.
LinestringGeoThe LinestringGeo type is used to define all the advanced characteristics of a geographic linestring.
modbusSessionThe modbusSession type is used to identify a connection to a Modbus server.
MultiLinestring2DThe MultiLinestring2D type can be used to store a collection of linestrings defined with 2D coordinates.
MultiPoint2DThe MultiPoint2D type is used to store a set of points defined with 2D coordinates. It is a collection of points: unlike in a linestring, points are not connected.
MultiPointGeoThe MultiPointGeo type is used to store a set of points defined with geographic coordinates. It is a collection of points: in this case, points are not connected.
MultiPolygon2DThe MultiPolygon2D type can be used to store a collection of non-overlapping polygons defined with 2D coordinates.
MultiPolygonGeoThe MultiPolygonGeo type can be used to store a collection of non-overlapping polygons defined with geographic coordinates.
NumericFormatThe NumericFormat type allows you to define all the characteristics of the format to be used with the NumToString function.
Point2DThe Point2D type is used to define all the characteristics of a location represented on a Cartesian plane.
PointGeoThe PointGeo type is used to define all the advanced characteristics of a location represented on the spheroidal surface of the earth.
Polygon2DThe Polygon2D type is used to define all the advanced characteristics of a 2D polygon.
PolygonGeoThe PolygonGeo type is used to define all the advanced characteristics of a geographic polygon.
WBAdminApplicationThe WBAdminApplication type is used to define all the advanced characteristics of an application deployed on a WEBDEV Application Server.
WLanguageCodeCompilingThe WLanguageCodeCompiling type is used to define all the compiler options used by the Compile, ExecuteCode and EvaluateExpression functions, as well as by the Code Editor control (via the Compiler property).
WLanguageCodeFormattingThe WLanguageCodeFormatting type is used to define all the WLanguage code formatting options.
xmlSignatureVerificationThe xmlSignatureVerification type is used to define the information required to verify an XML signature.
WEBDEV - Server codeLinux New WLanguage types for WEBDEV applications on Linux:
docElémentInterrupteurType décrivant les checkbox utilisables pour la creation de formulaire
Le type docElémentInterrupteur permet de définir toutes les caractéristiques avancées d'un XXX. Les caractéristiques de ce XXX peuvent être définies et modifiées à l'aide de différentes propriétés WLangage.
DriveThe Drive type is used to handle online storage services. To use this type of variable, you need to connect to the desired service.
gglDriveThe gglDrive type is used to handle Google Drive. To use a gglDrive variable, you need to connect to Google Drive using GglDriveConnect.
GglFileThe GglFile type is used to get all the characteristics of a file used in one of the Google Docs Editors (Docs, Sheets, etc.).
Linestring2DThe Linestring2D type is used to define all the advanced characteristics of a linestring defined with 2D coordinates.
modbusSessionThe modbusSession type is used to identify a connection to a Modbus server.
MultiLinestring2DThe MultiLinestring2D type can be used to store a collection of linestrings defined with 2D coordinates.
MultiLinestringGeoThe MultiLinestring type can be used to store a collection of linestrings defined with geographic coordinates.
MultiPoint2DThe MultiPoint2D type is used to store a set of points defined with 2D coordinates. It is a collection of points: unlike in a linestring, points are not connected.
MultiPointGeoThe MultiPointGeo type is used to store a set of points defined with geographic coordinates. It is a collection of points: in this case, points are not connected.
MultiPolygon2DThe MultiPolygon2D type can be used to store a collection of non-overlapping polygons defined with 2D coordinates.
MultiPolygonGeoThe MultiPolygonGeo type can be used to store a collection of non-overlapping polygons defined with geographic coordinates.
NumericFormatThe NumericFormat type allows you to define all the characteristics of the format to be used with the NumToString function.
Point2DThe Point2D type is used to define all the characteristics of a location represented on a Cartesian plane.
PointGeoThe PointGeo type is used to define all the advanced characteristics of a location represented on the spheroidal surface of the earth.
Polygon2DThe Polygon2D type is used to define all the advanced characteristics of a 2D polygon.
WBAdminApplicationThe WBAdminApplication type is used to define all the advanced characteristics of an application deployed on a WEBDEV Application Server.
xmlSignatureVerificationThe xmlSignatureVerification type is used to define the information required to verify an XML signature.
WEBDEV - Browser code New WLanguage types for WEBDEV applications in browsers:
GuidedTourThe GuidedTour type is used to define the advanced characteristics of a Guided Tour and its steps.
GuidedTourStepThe GuidedTourStep is used to define all the advanced characteristics of a step of a Guided Tour.
Improved advanced WLanguage types
WEBDEV - Server codeWindowsLinux The following advanced types have been improved for WEBDEV applications:
docElementProperty control: Allows you to manage specific fields, in particular Check Box control fields..
docParagraph
  • RightToLeft property: Allows you to manage the direction of set (for languages written from right to left).
  • IndentBeforeText property: Set indentation before paragraph text (to the left of the paragraph).
  • IndentAfterText property: Set indentation after paragraph text (to the right of the paragraph).
hRSConfigPeerIdentifier property: In a bidirectional replication, gets the identifier of the replication that goes from the opposite peer server to the replicated server.
httpRequest
  • ProcedureTrace property: httpTraceInfo, new constant to get detailed information about the execution of the request (low-level cURL/OpenSSL error, step in progress, warnings, etc.).
  • Authentication property: Defines the authentication method required to access resources in a given server or website.
aiNeuralNetworkModelTransposeRequired property: Modifies the matrix representation of an image created by OpenCV.
mqttSessionIgnoreError property: Used to specify the errors to be ignored.
OAuth2ParametersOption property: Enables PKCE authentication.
restRequest
  • ProcedureTrace property: httpTraceInfo, new constant to get detailed information about the execution of the request (low-level cURL/OpenSSL error, step in progress, warnings, etc.).
  • Authentication property: Defines the authentication method required to access resources in a given server or website.
xlsDocumentYou can now specify the format of an Excel document (XLS or XLSX) when creating a variable of type xlsDocument.
xmlSignatureNew constants to use new elliptic curve signature algorithms.
Minimum version required
  • Version 28
Comments
Click [Add] to post a comment

Last update: 05/29/2024

Send a report | Local help