PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version: 19.0

  • Overview
  • New WLanguage functions
  • Improved functions of WLanguage
  • New WLanguage properties
  • Improved WLanguage properties
  • New advanced types of WLanguage
  • Improved advanced types of WLanguage
WinDevWebDev - Server codeWebDev - Browser codeWinDev MobileReports and QueriesWindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPadJavaPHPAjaxUser code (UMC)External languageHFSQLHFSQL Client/ServerStored proceduresHyper File 5.5OLE DBODBCNative Accesses

WebDev 19: New features of WLanguage

Overview
In version 19, new functions, new properties and new data types have been introduced and some of them have been improved.

New WLanguage functions
WebDev - Server codeWindows The new WLanguage functions in server code are as follows:
CertificateLoadLoads a certificate from a file or a buffer.
StringIncrementIncrements a number found at the beginning or at the end of a character string.
ControlTypeInfoReturns the icon corresponding to the specified type of control.
CombinationFromNameReturns a combination of one or more options known by their names.
CombinationFromValueReturns a combination of one or more options known by their associated values.
CombinationCheckNameChecks whether a combination of one of more options known by their names is valid.
DateTimeTimeZoneToLocalConverts a date and a time expressed in a time zone into local date and time.
DateTimeLocalToTimeZoneConverts a local date and time into the date and time of a time zone.
DateTimeValidChecks the validity of a date/time included between January 01 0001 at 0 hour 0 minute 0 second 0 hundredth of a second and December 31 9999 at 23 hours 59 minutes 59 seconds 99 hundredths of a second.
dbgOnErrorDefines the WLanguage procedure that will be called whenever an error is detected by a function from the dbgCheckXXX family.
dSaveImageICOSaves an image in icon format either in a file, or in memory.
dSaveImageTIFFSaves an image in TIFF format in a file or in memory.
EnumerationFromNameReturns an enumeration value known by its name.
EnumerationFromValueReturns an enumeration value known by its associated value.
EnumerationCheckNameChecks whether an enumeration value known by its name is valid.
EnumerationCheckValueChecks whether an enumeration value known by its associated value is valid.
fBuildPathBuilds a complete file path from the directory and short name of a file. This function allows you, among other things, to get a valid file name without worrying whether separators are present in the path ('/' or '\') or their direction depending on the platform.
fSplitSplits a file into several files.
fMergeMerges several files into a single one.
FTPDateTimeReturns the different dates and times (creation, modification or access) associated with a file found on an FTP server (File Transfer Protocol).
FTPFileExistChecks the existence of a file on an FTP server.
FTPParameterModifies the behavior of standard FTP functions.
gpwActivateUserValidates the creation of a new user in the database of user groupware by activating the user.
gpwAddUserAdds a user into the database of user groupware.
gpwConnectUserConnects a user to the user groupware.
gpwDisconnectUserDisconnects the current user from the user groupware.
gpwEnumControlEnumerates the window or page controls whose status (invisible, grayed, inactive) can be modified by the user groupware.
gpwModeReturns the runtime mode of the user groupware.
gpwModifyUserModifies a user in the database of user groupware.
gpwForgottenPasswordRuns an action to retrieve or change the password of a user.
gpwOpenSiteAllows you to start the site when using the user groupware.
gpwFindUserRetrieves the characteristics of a user of the user groupware.
gpwGetRightsAllows you to get the rights granted to a control, a window, a page or a report.
gpwCheckUserChecks the existence and validity of the password for a user of the user groupware.
grAxisVisibleEnables or disables the display of axes in a Line or Column chart.
grCategoryColorInitializes the color of a category for a pie or column chart.
grDestinationImageDefines an Image variable as destination of a chart.
grWaterfallColorIndicates the color for a type of category in a Waterfall chart.
grWaterfallCategoryTypeIndicates the type of category in a Waterfall chart.
HTransactionIsolationConfigures the isolation mode of transactions for a connection to a HFSQL server.
iPrintingNationModifies the current language for the next print (programmed print or report print).
NationRightToLeftUsed to find out whether the current language is written from right to left.
NotifPushSendSends a push notification to a mobile device (iOS or Android).
NotifPushListInvalidIdentifiersReturns the list of invalid identifiers on the APN service of Apple.
RTFToTextReturns the text without the formatting characteristics specific to the RTF format.
AssistedInputAddAdds a row into the list of values available for the assisted input of an edit control.
AssistedInputConfigureUsed to configure the filter and the opening of the assisted input.
AssistedInputDeleteAllClears the list of values proposed for the assisted input of an edit control.
SQLConnectWSConnects the current application to a database that must be interrogated by SQL by using a WebService proxy (SOAP).
ArrayMixMixes the elements of a WLanguage array.
TableFilteredColumnReturns the list of columns filtered by the user in a Table or Treeview Table control.
TableMoveColumnMoves a column in a Table or Treeview Table control.
TableColumnSubscriptReturns the subscript of a column found in a Table or Treeview Table control.
TableSelectToFilePositions on the data file record corresponding to the row selected in the multi-selection browsing Table control.
ThreadEndEnds the execution of the current thread.
URLExtractPathReturns the different elements of a URL: protocol, user, password, domain, port, resource path, resource name, resource extension, request and fragment.

WebDev - Server codeLinux The new WLanguage functions for WebDev in Linux are as follows:
StringIncrementIncrements a number found at the beginning or at the end of a character string.
CombinationFromNameReturns a combination of one or more options known by their names.
CombinationFromValueReturns a combination of one or more options known by their associated values.
CombinationCheckNameChecks whether a combination of one of more options known by their names is valid.
DateTimeTimeZoneToLocalConverts a date and a time expressed in a time zone into local date and time.
DateTimeLocalToTimeZoneConverts a local date and time into the date and time of a time zone.
DateTimeValidChecks the validity of a date/time included between January 01 0001 at 0 hour 0 minute 0 second 0 hundredth of a second and December 31 9999 at 23 hours 59 minutes 59 seconds 99 hundredths of a second.
dbgOnErrorDefines the WLanguage procedure that will be called whenever an error is detected by a function from the dbgCheckXXX family.
EnumerationFromNameReturns an enumeration value known by its name.
EnumerationFromValueReturns an enumeration value known by its associated value.
EnumerationCheckNameChecks whether an enumeration value known by its name is valid.
EnumerationCheckValueChecks whether an enumeration value known by its associated value is valid.
ExecuteMainThreadTriggers the execution of the procedure specified in the main thread of the application.
fBuildPathBuilds a complete file path from the directory and short name of a file. This function allows you, among other things, to get a valid file name without worrying whether separators are present in the path ('/' or '\') or their direction depending on the platform.
fSplitSplits a file into several files.
fMergeMerges several files into a single one.
FTPDateTimeReturns the different dates and times (creation, modification or access) associated with a file found on an FTP server (File Transfer Protocol).
FTPFileExistChecks the existence of a file on an FTP server.
grAxisVisibleEnables or disables the display of axes in a Line or Column chart.
grCategoryColorInitializes the color of a category for a pie or column chart.
grDestinationImageDefines an Image variable as destination of a chart.
grWaterfallColorIndicates the color for a type of category in a Waterfall chart.
grWaterfallCategoryTypeIndicates the type of category in a Waterfall chart.
HTMLToRTFConverts an HTML string or an HTML buffer into a string in RTF format.
HTMLToTextConverts an HTML string or an HTML buffer into text string.
HTransactionIsolationConfigures the isolation mode of transactions for a connection to a HFSQL server.
iPrintingNationModifies the current language for the next print (programmed print or report print).
NationRightToLeftUsed to find out whether the current language is written from right to left.
RTFToHTMLReturns the HTML string corresponding to the specified RTF string.
RTFToTextReturns the text without the formatting characteristics specific to the RTF format.
AssistedInputAddAdds a row into the list of values available for the assisted input of an edit control.
AssistedInputConfigureUsed to configure the filter and the opening of the assisted input.
AssistedInputDeleteAllClears the list of values proposed for the assisted input of an edit control.
CriticalSectionStartMarks the start of a critical section: no other thread will be able to run the code as long as the current thread does not exit from the critical section.
CriticalSectionEndMarks the end of a critical section: the code will be run by another thread.
SemaphoreCreateCreates a semaphore.
SemaphoreStartLocks the current thread until the semaphore is opened (which means until a "free" spot becomes available in the protected section).
SemaphoreDestroyExplicitly destroys a semaphore.
SemaphoreEndAllows one or more threads to exit from the area protected by the semaphore.
EventWaitLocks the current thread while waiting for the specified signal to be opened.
EventCreateCreates a signal.
EventDestroyExplicitly destroys a signal.
EventChangeModifies the status of a signal.
SocketAcceptRun on the server, this function accepts a request for connecting to an existing socket found on the server.
SocketWaitForConnectionRun on the server, this function is used to wait for a connection request coming from the client sockets.
SQLConnectWSConnects the current application to a database that must be interrogated by SQL by using a WebService proxy (SOAP).
ArrayMixMixes the elements of a WLanguage array.
TableFilteredColumnReturns the list of columns filtered by the user in a Table or Treeview Table control.
TableMoveColumnMoves a column in a Table or Treeview Table control.
TableColumnSubscriptReturns the subscript of a column found in a Table or Treeview Table control.
TableSelectToFilePositions on the data file record corresponding to the row selected in the multi-selection browsing Table control.
TextToHTMLConverts a text string into an HTML string (the CR characters are replaced by <BR>, the accented characters are replaced by their equivalent in HTML, ...).
TextToRTFConverts an external string into RTF format.
ThreadStopStops a secondary thread.
ThreadWaitWaits for the end of execution of the specified thread.
ThreadWaitSignalLocks the current thread until it receives a signal from another thread.
ThreadCurrentReturns the name of the thread currently run.
ThreadSendSignalThe current thread sends a signal to the specified thread in order to unlock it.
ThreadStateReturns the current status of a thread.
ThreadExecuteStarts the execution of a secondary thread.
ThreadEndEnds the execution of the current thread.
ThreadModeChanges the management mode of the threads.
URLExtractPathReturns the different elements of a URL: protocol, user, password, domain, port, resource path, resource name, resource extension, request and fragment.

WebDev - Browser code The new WLanguage functions for WebDev in Browser code are as follows:
SensorDetectChangeAccelerationAllows you to be notified when accelerations occur on the device on any one of its 3 axes.
SensorDetectChangeOrientationAllows you to be notified when the orientation of the device changes on any one of its 3 axes.
SensorDetectBeginningBumpsAllows you to be notified when bumps occur on the device on any one of its 3 axes.
SensorDetectEndBumpsAllows you to be notified when bumps occur on the device on any one of its 3 axes.
SensorGetOrientationRetrieves the current orientation of the device on one of its 3 axes.
SensorEndIndicates the end of the use of the sensor functions.
ContainsEnables you to find out whether a sub-string is included in a string.
ExceptionThrowArtificially triggers the security mechanism of WLanguage by throwing an exception.
ExceptionInfoRetrieves information about the current exception.
ExceptionPropagatePropagates an exception.
GestureNbPointerReturns the number of pointers in contact with the screen.
GestureCurrentPointerReturns the subscript of the pointer (finger or stylus) that triggered the call to a process specific to the multi-touch in an Image control.
GesturePosXReturns the horizontal position of the pointer (finger or stylus).
GesturePosYReturns the vertical position of the pointer (finger or stylus).
jQueryRuns a Javascript method (or several chained methods) of the jQuery library on a page element.
jQueryExecuteRuns a Javascript method of the jQuery library on a page element.
NotificationDisplayDisplays a message outside browser.
PageVisibleIndicates whether the page is visible to the user.
FullScreenEnableSwitches the browser to "Full screen" mode. The browser occupies the entire screen.
FullScreenDisableDisables the "Full screen" mode of the browser.
AssistedInputAddAdds a row into the list of values available for the assisted input of an edit control.
AssistedInputCloseCloses the list of values proposed by the assisted input for an edit control.
AssistedInputOpenOpens the list of values proposed by the assisted input for an edit control.
AssistedInputConfigureUsed to configure the filter and the opening of the assisted input.
AssistedInputDeleteAllClears the list of values proposed for the assisted input of an edit control.
TableEnableFilterImplements a user filter on a column found in a Table or TreeView Table control.
TableAddAdds a row into:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo box control.
TableAddLineAdds a row into:
  • a Table control,
  • a TreeView Table control.
TableSeekPerforms a search in:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo box control.
TableMoveColumnMoves a column in a Table or Treeview Table control.
TableMoveLineMoves a row or swaps two rows in a Table control.
TableDisableFilterDisables a user filter on a column or on all the columns found in a Table or Treeview Table control.
TableSwapLineSwaps:
  • two rows in a memory Table control.
  • two branches in a memory Treeview Table control.
TableColumnSubscriptReturns the subscript of a column found in a Table or Treeview Table control.
TableInsertInserts a row into:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
TableInsertLineInserts a row into:
  • a Table control,
  • a TreeView Table control.
TableModifyModifies a row in:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo Box control.
TableModifyLineModifies a row in:
  • a Table control,
  • a TreeView Table control.
TableCountReturns:
  • the number of columns found in a Table or Treeview Table control.
  • the number of rows found in a Table or Treeview Table control.
TableInputInProgressIndicates whether a Table or Treeview Table control is currently in edit.
TableInputSearchSwitches to input mode the search area found in the column title of the Table or Treeview Table control .
TableSelectReturns the subscript of the element selected in the Table or Treeview Table control.
TableSelectMinusDeselects a row in a Table or Treeview Table control.
TableSelectCountReturns the number of elements selected in a Table or Treeview Table control (notably in the case of a multi-selection control).
TableSelectPlusSelects a row in a Table or Treeview Table control.
TableDeleteDeletes a row from:
  • a Table control,
  • a TreeView Table control,
  • a table displayed in a Combo box control.
TableDeleteSelectDeletes the selected rows from a Table or Treeview Table control.
TableDeleteAllDeletes all the rows from:
  • a memory Table control,
  • a memory TreeView Table control,
  • a table displayed in a Combo box control.
TableSortSorts a Table or Treeview Table control on one or more columns (lexicographical sort).
WiFiStatusReturns the current activation status of Wi-Fi on the device or asks to be notified when the activation status of Wi-Fi changes.

PHP The new WLanguage functions for WebDev for the PHP sites are as follows:
StringIncrementIncrements a number found at the beginning or at the end of a character string.
StringDeleteDeletes:
  • all the occurrences of a sub-string inside another string-.
  • part of a string inside a string. The part of string to remove is identified by its position and length.
dbgStandardOutputWrites an information into the standard output stream "stdout" (also called "console").
fCreateLinkCreates a link on a file at the specified location.
fSeparatorReturns a file path with normalized separators.
AssistedInputAddAdds a row into the list of values available for the assisted input of an edit control.
AssistedInputConfigureUsed to configure the filter and the opening of the assisted input.
AssistedInputDeleteAllClears the list of values proposed for the assisted input of an edit control.
SiteAddressReturns the Internet address for connecting to a dynamic WebDev site found on the same server.

Improved functions of WLanguage
WebDev - Server codeWindowsLinux The following functions have been modified in this version:
StringDeleteNew syntax used to delete a section of string (identified by its position and by its length).
CompileNew syntaxes allowing you to use the Procedure type.
dbgInfoNew constant used to find out whether the debugger is active.
DeserializeNew constant used to deserialize in JSON format.
fCopyFileNew syntax used to handle each copied file.
fCreateLinkNew parameters used to manage the command line and the working directory.
fOpenNew constant to optimize the management of the caches.
fCopyDirNew syntax used to handle each copied file.
grCreateNew constant used to handle the Waterfall charts.
grTypeNew constant used to handle the Waterfall charts.
HAddNew syntax allowing you to use the Record type.
HLinkMemoNew syntax allowing you to use the Record type.
HConnectManagement of the OLE DB provider for Access 2010.
HCopyRecordNew syntax allowing you to use the Record type.
HDeclareExternalManagement of the OLE DB provider for Access 2010.
HExtractMemoNew syntax allowing you to use the Record type.
HSetServerNew constant used to manage the Windows cache.
HInfoMemoNew syntax allowing you to use the Record type.
HInfoServerNew constant used to find out the size of the index cache that was actually used.
HListFileManagement of the OLE DB provider for Access 2010.
HListItemNew syntax allowing you to use the Record type.
HOpenConnectionManagement of the OLE DB provider for Access 2010.
HRetrieveRecordNew syntax allowing you to use the Record type.
HOnServerCallNew parameter used to run the procedure in a secondary thread.
HTransactionCancelNew syntax allowing you to specify the connection used.
HTransactionStartNew syntax allowing you to specify the connection used.
HTransactionEndNew syntax allowing you to specify the connection used.
HTTPSendFormNew constants used to manage the HEAD, PATCH and COPY methods.
NowNew syntax used to initialize the Date, Time or DateTime variables, items and controls.
ReplicSynchronizeNew constant used to avoid displaying a progress bar during the synchronization.
SerializeNew constant used to serialize in JSON format.
SocketConnectSSLNew parameter used to manage the client certificate.
SysDirAddition of new constants to manage the system directories.
ArraySortNew syntaxes used to sort the associative arrays.
TableSelectThe third parameter is now available.
TableSelectCountThe second parameter is now available.
SortNew syntaxes used to sort the associative arrays.
zipExtractFileListNew parameter used to manage the errors regarding file extraction.
zipExtractAllNew parameter used to manage the errors regarding file extraction.

WebDev - Browser code The following functions have been modified in this version:
JSEventNew constant used to manage the "Before unloading the page" event.

PHP The following functions have been modified in this version:
DeserializeNew constant used to deserialize in JSON format.
SerializeNew constant used to serialize in JSON format.

New WLanguage properties
WebDev - Server codeWindowsLinux The new properties are as follows:
After..After replaces or inserts a procedure after the other procedures in:
  • a Procedure variable.
  • a process associated with a control.
Before..Before replaces or inserts a procedure before the other procedures in:
  • a Procedure variable.
  • a process associated with a control.
KeepVisibleHierarchy..KeepVisibleHierarchy is used to:
  • Find out which elements of the treeview table will be printed: printing the entire hierarchy or the printing the hierarchy that is visible in the control.
  • Modify the print mode of the hierarchy: printing the entire hierarchy or the printing the hierarchy that is visible in the control.
CaptionHTML..CaptionHTML is used to handle the caption of a control in HTML format.
Member..Member on the Variant variables is used to get the array of named elements.
MagnifierMode..MagnifierMode is used to find out and modify the management mode of the magnifier in the title of the table columns.
TotalNbChildren..TotalNbChildren returns the total number of children in a branch:
  • of a Treeview control,
  • of a Treeview Table control.
HierarchicalDepth..HierarchicalDepth is used to:
  • Find out the depth of a TreeView Item control found in a report.
  • Modify the depth of a TreeView Item control found in a report (only if the report is using a data source by programming).
RepeatableReadSupported..RepeatableReadSupported is used to:
  • Find out whether the data file (file defined in the data model editor or by programming) can be used in HFSQL Client/Server in a transaction that includes a "Repeatable Read" isolation mode.
  • Allow the use of a transaction that includes a "Repeatable Read" isolation mode for a data file (when the file is described by programming only).
Process..Process is used to modify the processes that must be run by the events available on a control, a window, a page, a report, ...

Improved WLanguage properties
WebDev - Server codeWindowsLinux The following properties have been improved:
AnchorThis property is now available for the report controls. It is used to find out the type of anchor for a report control.
FicCryptMethodNew constant used to manage the automatic encryption (encryption if a password is specified).
MmoCryptMethodNew constant used to manage the automatic encryption (encryption if a password is specified).
NdxCryptMethodNew constant used to manage the automatic encryption (encryption if a password is specified).
CtOLEDBProviderManagement of the OLE DB provider for Access 2010.
CtDescribedOLEDBProviderManagement of the OLE DB provider for Access 2010.
ExpandedImageThis property is now available in the TreeView Table reports.
CollapsedImageThis property is now available in the TreeView Table reports.
PlaneThis property is now available for the reports.
AnchorRateRightThis property is now available for the report controls. It is used to find out the anchor rate of a report control.
AnchorRateWidthThis property is now available for the report controls. It is used to find out the anchor rate of a report control.

WebDev - Browser code The following properties have been improved:
ColorThis property is now available in browser code for:
  • The browser table rows.
  • The browser table columns.
  • The browser table cells.
BrushColorThis property is now available in browser code for:
  • The browser table rows.
  • The browser table columns.
  • The browser table cells.

New advanced types of WLanguage
WebDev - Server code The new WLanguage types for the WebDev sites are as follows:
EmailHeaderThe EmailHeader type is used to retrieve or fix the additional headers of the email.
RecordThe Record type is used to save the values of a record.
gpwUserThe gpwUser type is used to describe and modify the characteristics of a user of the WebDev user groupware.
IconThe Icon type is used to define the advanced characteristics of an icon.
TiffThe Tiff type is used to define the advanced characteristics of a TIFF image.

Improved advanced types of WLanguage
WebDev - Server code The following WLanguage types have been improved for the WebDev sites:
EmailCreation of a new ..Header property to mange the email headers.
hSchedulingCreation of a new ..TimeUTC property used to indicate whether the specified time is a UTC time or a local time.
hScheduledTaskCreation of a new ..TimeUTC property used to indicate whether the specified time is a UTC time or a local time.
Minimum required version
  • Version 18
Comments
Click [Add] to post a comment