PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • New WLanguage functions
  • Improved functions of WLanguage
  • New WLanguage properties
  • Improved WLanguage properties
  • New advanced types of WLanguage
  • Improved advanced types of WLanguage
Products
WinDevWebDev - Server codeWebDev - Browser codeWinDev MobileReports and Queries
Platforms
WindowsLinuxWindows MobileUniversal Windows 10 AppAndroidAndroid Widget iPhone/iPadApple Watch
Languages
JavaPHPAjaxUser code (UMC)External language
Databases
HFSQLHFSQL Client/ServerStored proceduresOLE DBODBCNative Accesses
Overview
In version 21, new functions, new properties and new types of data have been introduced and some of them have been improved.
New WLanguage functions
Windows Mobile The new WLanguage functions for Windows Mobile are as follows:
BufferToHexaConverts a buffer into a displayable hexadecimal string (for example: "4A 5B 00").
dRoundedRectangleDraws a rounded rectangle:
  • in an Image control,
  • in an Image variable.
fDirExistChecks the existence of a directory.
FirstDayOfYearReturns the date of the first day of the year.
fTempDirReturns the name of the directory used to store the temporary files.
GetCountryListReturns the list of countries according to the ISO 3166-1 standard.
InAppleWatchEmulatorModeIndicates whether the code is run in the Apple Watch emulator.
InAppleWatchModeIndicates whether the code currently run is in Apple Watch mode.
InAppleWatchSimulatorModeIndicates whether the code is run in the Apple Watch simulator.
InUniversalWindowsAppModeIndicates whether the code is run in Universal Windows 10 App mode.
InUniversalWindowsAppSimulatorModeIndicates whether the code is run in the simulator for the applications in Universal Windows 10 App mode.
LooperRestorePositionAndSelectionRestores the position of the scrollbar in a looper and/or the selected element(s).
LooperSavePositionAndSelectionSaves:
  • the position of the scrollbar in a Looper control,
  • the selected element(s).
These elements can be restored by LooperRestorePositionAndSelection.
LooperSeekAnywhereSeeks a value in all the attributes of a Looper control.
TableListChildLists the "children" of a node and the "child" elements of these "children" in a TreeView Table control.
TraceBuildDisplays a customizable message in the trace window opened in parallel of the current window.
Android The new WLanguage functions for Android are as follows:
ActionBarDeleteSearchHistoryDeletes the history from the search control found in the action bar of a window.
ActionBarSearchVisibleUsed to find out and modify the visibility status of the search control associated with the Action Bar found in the current window.
AppointmentToiCalendarExports an appointment or a list of appointments in iCalendar format.
BTLECharacteristicChangeOfValueEnables or disables the detection regarding the change of value for a Bluetooth Low Energy characteristic.
BTLECharacteristicReadValueReads the value of a characteristic on a Bluetooth Low Energy device.
BTLECharacteristicWriteValueWrites a value in a characteristic on a Bluetooth Low Energy device.
BTLEConnectUsed to connect to a Bluetooth Low Energy device.
BTLEConnectionStatusReturns the current status of the connection to a Bluetooth Low Energy device or asks to be notified when the status of the connection changes.
BTLEDescriptorReadValueReads the value of a descriptor on a Bluetooth Low Energy device.
BTLEDescriptorWriteValueWrites the value of a descriptor on a Bluetooth Low Energy device.
BTLEDisconnectUsed to disconnect from a Bluetooth Low Energy device.
BTLEGetACharacteristicRetrieves the characteristic of a Bluetooth Low Energy service corresponding to the specified identifier (UUID).
BTLEGetADescriptorRetrieves the descriptor of a Bluetooth Low Energy characteristic corresponding to the specified identifier (UUID).
BTLEGetAllCharacteristicsRetrieves all the characteristics with the same identifier associated with a Bluetooth Low Energy service.
BTLEGetAllServicesRetrieves all the services corresponding to a UUID.
BTLEGetAServiceRetrieves the service of a Bluetooth Low Energy device corresponding to the specified identifier (UUID).
BTLEInitializeInitializes Bluetooth Low Energy (required in iOS only).
BTLEListDeviceReturns the list of accessible Bluetooth Low Energy devices.
BTLEStatusReturns the current activation status of Bluetooth on the device or asks to be notified when the activation status changes.
CheckBoxAddAdds a new option into a Check Box control.
CheckBoxCountReturns the number of options found in a Check Box control.
CheckBoxDeleteDeletes an option from a Check Box control.
CheckBoxInsertInserts a new option into a Check Box control.
CurrentColumnReturns:
  • the subscript of the current subscripted column in a memory Table or in a browsing Table control.
  • the number of the column currently in edit in the specified browsing Table or memory Table control.
DequeueDequeues an element from a queue.
EnqueueEnqueues an element into a queue.
FBGetUserInformationRetrieves the Facebook information of the connected user.
FBRequestPerforms a communication request (HTTP request) to the Graph API of Facebook.
FBSessionStatusChecks the status of a Facebook session.
FBStartSessionUsed to authentificate and to connect to Facebook.
FBStopSessionStops the Facebook session started by FBStartSession.
fCacheDirReturns the path of the directory that will be used to store the data in cache on the internal storage space of the application.
fDirExistChecks the existence of a directory.
fMergeMerges several files into a single one.
fSplitSplits a file into several files.
gBackgroundDescribes the display color:
  • for the background of the text displayed in an element of a List Box or Combo Box control,
  • for the inside section of a shape (rectangle or circle) displayed in an element of a List Box or Combo Box control.
geoTrackingDisableDisables the tracking of user positions for a WINDEV Mobile application.
geoTrackingEnableEnables the management of position tracking in a WINDEV Mobile application.
geoTrackingProcedureDefines the WLanguage procedure that will be called when the user position changes.
geoTrackingStatusRetrieves the status of the system for position tracking.
gFontDescribes the font used to display a text in a graphic List Box or Combo Box control.
gFontBoldIndicates whether the text that follows the call to this function is displayed in bold.
gFontItalicIndicates whether the text that follows the call to this function is displayed in italic or not.
gFontSizeIndicates the size of the font used to display a text in a graphic string.
gFontUnderlinedIndicates whether the text that follows the call to this function must be underlined or not.
gImageInserts an image into an element of a List Box or Combo Box control.
gPenDescribes the display color for the text and/or for the outline of a shape (rectangle or circle) in an element of a List Box or Combo Box control.
gToTextDeletes the graphic elements from a character string that uses gLink, gImage, ...
iCalendarToAppointmentLists the appointments described in a character string in iCalendar format.
iCalendarToSchedulerImports data in iCalendar format into a Calendar control.
InAppleWatchEmulatorModeIndicates whether the code is run in the Apple Watch emulator.
InAppleWatchModeIndicates whether the code currently run is in Apple Watch mode.
InAppleWatchSimulatorModeIndicates whether the code is run in the Apple Watch simulator.
InUniversalWindowsAppModeIndicates whether the code is run in Universal Windows 10 App mode.
InUniversalWindowsAppSimulatorModeIndicates whether the code is run in the simulator for the applications in Universal Windows 10 App mode.
ListInfoRetrieves the characteristics of a list: types of elements and number of elements.
LooperAddInProgressModifies or returns the visibility status of the internal wait window when adding additional elements into an infinite Looper control.
LooperSeekAnywhereSeeks a value in all the attributes of a Looper control.
OpenPopupMenuAutomatically opens a popup menu for the current control or window.
PopPops an element from a stack.
PushPushes an element into a stack.
QueueInfoRetrieves the characteristics of a queue: types of elements and number of elements.
RadioButtonAddAdds a new option into a Radio Button control.
RadioButtonCountReturns the number of options found in a Radio Button control.
RadioButtonDeleteDeletes an option from a Radio Button control.
RadioButtonInsertInserts a new option into a Radio Button control.
SchedulerAddAppointmentAdds a new appointment into a Scheduler control.
SchedulerAddResourceAdds a new resource into a Scheduler control.
SchedulerChangeModeModifies the period (which means the number of days) displayed by a Scheduler control.
SchedulerDeleteAllDeletes all the appointments and all the resources from a Scheduler control.
SchedulerDeleteAppointmentDeletes an appointment from a Scheduler control.
SchedulerDeleteResourceDeletes a resource from a Scheduler control.
SchedulerDisplayNextPeriodMoves the time area displayed on the next area (next weeks for example) in a Scheduler control.
SchedulerDisplayPreviousPeriodMoves the time area displayed on the previous area (previous weeks for example) in a Scheduler control.
SchedulerInfoXYReturns the appointment, the resource or the date found at a given position in a Scheduler control.
SchedulerListAppointmentReturns:
  • the list of appointments found between two dates in a Scheduler control,
  • all the appointments found in a Scheduler control,
  • a specific appointment (selected or hovered).
SchedulerModeReturns the display mode of a Scheduler control: day, week, month, ...
SchedulerPositionDateTimeDisplays a Scheduler control from a specified date or returns the date of the first day (or last day) displayed in a Scheduler control.
SchedulerPositionResourceDisplays a given resource in a Scheduler control or returns the position of the first resource visible in a Scheduler control.
SchedulerSelectMinusDeselects an appointment from a Scheduler control.
SchedulerSelectPlusSelects an appointment in a Scheduler control.
SchedulerTimeDisplayedDefines the time range displayed by the Scheduler control in Day mode or in Week mode.
SchedulerToiCalendarExports the appointments from a Scheduler control in iCalendar format.
StackInfoRetrieves the characteristics of a stack: types of elements and number of elements.
SysCacheExternalStorageReturns the path of the directory that will be used to store the data in cache on the external storage space of the application.
SysDirExternalStorageReturns the path of the directory that will be used to store files in the external storage space of an Android device.
SysMemoryExternalStorageReturns the amount of available memory on the external storage area of the device.
SysNationReturns the nation currently used by the system.
SysNbExternalStorageReturns the number of external storage spaces found on an Android device.
SysRemovableExternalStorageUsed to find out whether the external storage space corresponds to the moveable memory (SD Card).
SysStatusExternalStorageReturns the availability status of the external storage space of the device.
TableAddInProgressModifies or returns the visibility status of the internal wait window when adding additional elements into an infinite Table control.
Android Widget The new WLanguage functions for Android Widget are as follows:
AppointmentToiCalendarExports an appointment or a list of appointments in iCalendar format.
DequeueDequeues an element from a queue.
EnqueueEnqueues an element into a queue.
fCacheDirReturns the path of the directory that will be used to store the data in cache on the internal storage space of the application.
fDirExistChecks the existence of a directory.
fMergeMerges several files into a single one.
fSplitSplits a file into several files.
iCalendarToAppointmentLists the appointments described in a character string in iCalendar format.
InAppleWatchEmulatorModeIndicates whether the code is run in the Apple Watch emulator.
InAppleWatchModeIndicates whether the code currently run is in Apple Watch mode.
InAppleWatchSimulatorModeIndicates whether the code is run in the Apple Watch simulator.
InUniversalWindowsAppModeIndicates whether the code is run in Universal Windows 10 App mode.
InUniversalWindowsAppSimulatorModeIndicates whether the code is run in the simulator for the applications in Universal Windows 10 App mode.
ListInfoRetrieves the characteristics of a list: types of elements and number of elements.
LooperSeekAnywhereSeeks a value in all the attributes of a Looper control.
PopPops an element from a stack.
PushPushes an element into a stack.
QueueInfoRetrieves the characteristics of a queue: types of elements and number of elements.
StackInfoRetrieves the characteristics of a stack: types of elements and number of elements.
SysCacheExternalStorageReturns the path of the directory that will be used to store the data in cache on the external storage space of the application.
SysDirExternalStorageReturns the path of the directory that will be used to store files in the external storage space of an Android device.
SysMemoryExternalStorageReturns the amount of available memory on the external storage area of the device.
SysNationReturns the nation currently used by the system.
SysNbExternalStorageReturns the number of external storage spaces found on an Android device.
SysRemovableExternalStorageUsed to find out whether the external storage space corresponds to the moveable memory (SD Card).
SysStatusExternalStorageReturns the availability status of the external storage space of the device.
iPhone/iPad The new WLanguage functions for iPhone/iPad are as follows:
ActionBarDeleteSearchHistoryDeletes the history from the search control found in the action bar of a window.
ActionBarSearchVisibleUsed to find out and modify the visibility status of the search control associated with the Action Bar found in the current window.
AppointmentAddAdds an appointment
  • into the calendar of a Lotus Notes or Outlook messaging
  • into the calendar found on a mobile device (Android or iOS)
AppointmentDeleteDeletes:
  • the current appointment from the calendar of a Lotus Notes or Outlook messaging.
  • an appointment from the calendar found on a mobile device (Android/iOS).
AppointmentDisplayDisplays an appointment in the native application for managing appointments found on the mobile device (Android or iOS).
AppointmentListLists the appointments found on the mobile device (Android/iOS) and corresponding to the specified criteria.
AppointmentModifyModifies the current appointment:
  • in the calendar of a Lotus Notes or Outlook messaging.
  • in the calendar found on a mobile device (Android/iOS).
AppointmentToiCalendarExports an appointment or a list of appointments in iCalendar format.
BTLECharacteristicChangeOfValueEnables or disables the detection regarding the change of value for a Bluetooth Low Energy characteristic.
BTLECharacteristicReadValueReads the value of a characteristic on a Bluetooth Low Energy device.
BTLECharacteristicWriteValueWrites a value in a characteristic on a Bluetooth Low Energy device.
BTLEConnectUsed to connect to a Bluetooth Low Energy device.
BTLEConnectionStatusReturns the current status of the connection to a Bluetooth Low Energy device or asks to be notified when the status of the connection changes.
BTLEDescriptorReadValueReads the value of a descriptor on a Bluetooth Low Energy device.
BTLEDescriptorWriteValueWrites the value of a descriptor on a Bluetooth Low Energy device.
BTLEDisconnectUsed to disconnect from a Bluetooth Low Energy device.
BTLEGetACharacteristicRetrieves the characteristic of a Bluetooth Low Energy service corresponding to the specified identifier (UUID).
BTLEGetADescriptorRetrieves the descriptor of a Bluetooth Low Energy characteristic corresponding to the specified identifier (UUID).
BTLEGetAllCharacteristicsRetrieves all the characteristics with the same identifier associated with a Bluetooth Low Energy service.
BTLEGetAllServicesRetrieves all the services corresponding to a UUID.
BTLEGetAServiceRetrieves the service of a Bluetooth Low Energy device corresponding to the specified identifier (UUID).
BTLEInitializeInitializes Bluetooth Low Energy (required in iOS only).
BTLEListDeviceReturns the list of accessible Bluetooth Low Energy devices.
BTLEStatusReturns the current activation status of Bluetooth on the device or asks to be notified when the activation status changes.
CurrentColumnReturns:
  • the subscript of the current subscripted column in a memory Table or in a browsing Table control.
  • the number of the column currently in edit in the specified browsing Table or memory Table control.
dBorderDraws a border.
dRoundedRectangleDraws a rounded rectangle:
  • in an Image control,
  • in an Image variable.
FBGetUserInformationRetrieves the Facebook information of the connected user.
FBRequestPerforms a communication request (HTTP request) to the Graph API of Facebook.
FBSessionStatusChecks the status of a Facebook session.
FBStartSessionUsed to authentificate and to connect to Facebook.
FBStopSessionStops the Facebook session started by FBStartSession.
fDirExistChecks the existence of a directory.
FirstDayOfYearReturns the date of the first day of the year.
fTempDirReturns the name of the directory used to store the temporary files.
gBackgroundDescribes the display color:
  • for the background of the text displayed in an element of a List Box or Combo Box control,
  • for the inside section of a shape (rectangle or circle) displayed in an element of a List Box or Combo Box control.
geoTrackingDisableDisables the tracking of user positions for a WINDEV Mobile application.
geoTrackingEnableEnables the management of position tracking in a WINDEV Mobile application.
geoTrackingProcedureDefines the WLanguage procedure that will be called when the user position changes.
geoTrackingStatusRetrieves the status of the system for position tracking.
GetCountryListReturns the list of countries according to the ISO 3166-1 standard.
gFontDescribes the font used to display a text in a graphic List Box or Combo Box control.
gFontBoldIndicates whether the text that follows the call to this function is displayed in bold.
gFontItalicIndicates whether the text that follows the call to this function is displayed in italic or not.
gFontSizeIndicates the size of the font used to display a text in a graphic string.
gFontUnderlinedIndicates whether the text that follows the call to this function must be underlined or not.
gImageInserts an image into an element of a List Box or Combo Box control.
gPenDescribes the display color for the text and/or for the outline of a shape (rectangle or circle) in an element of a List Box or Combo Box control.
grHMAddDataAdds a data into a Heatmap chart.
grHMCaptionXModifies the caption of a category on the X axis of a Heatmap chart.
grHMCaptionYModifies the caption of a category on the Y axis of a Heatmap chart.
grHMColorSpecifies the colors of the different values in a Heatmap chart.
grHMDeleteColorDeletes the colors specified by grHMColor from a Heatmap chart.
grHMGetDataRetrieves a data from a Heatmap 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.
iCalendarToAppointmentLists the appointments described in a character string in iCalendar format.
iCalendarToSchedulerImports data in iCalendar format into a Calendar control.
iCurrentFileReturns the name of the file currently generated.
InAppleWatchEmulatorModeIndicates whether the code is run in the Apple Watch emulator.
InAppleWatchModeIndicates whether the code currently run is in Apple Watch mode.
InAppleWatchSimulatorModeIndicates whether the code is run in the Apple Watch simulator.
InUniversalWindowsAppModeIndicates whether the code is run in Universal Windows 10 App mode.
InUniversalWindowsAppSimulatorModeIndicates whether the code is run in the simulator for the applications in Universal Windows 10 App mode.
iOSExcludeFileFromiCloudExcludes a file from the backup in the Apple cloud
LooperAddInProgressModifies or returns the visibility status of the internal wait window when adding additional elements into an infinite Looper control.
LooperSeekAnywhereSeeks a value in all the attributes of a Looper control.
SchedulerAddAppointmentAdds a new appointment into a Scheduler control.
SchedulerAddResourceAdds a new resource into a Scheduler control.
SchedulerChangeModeModifies the period (which means the number of days) displayed by a Scheduler control.
SchedulerDeleteAllDeletes all the appointments and all the resources from a Scheduler control.
SchedulerDeleteAppointmentDeletes an appointment from a Scheduler control.
SchedulerDeleteResourceDeletes a resource from a Scheduler control.
SchedulerDisplayNextPeriodMoves the time area displayed on the next area (next weeks for example) in a Scheduler control.
SchedulerDisplayPreviousPeriodMoves the time area displayed on the previous area (previous weeks for example) in a Scheduler control.
SchedulerInfoXYReturns the appointment, the resource or the date found at a given position in a Scheduler control.
SchedulerListAppointmentReturns:
  • the list of appointments found between two dates in a Scheduler control,
  • all the appointments found in a Scheduler control,
  • a specific appointment (selected or hovered).
SchedulerModeReturns the display mode of a Scheduler control: day, week, month, ...
SchedulerPositionDateTimeDisplays a Scheduler control from a specified date or returns the date of the first day (or last day) displayed in a Scheduler control.
SchedulerPositionResourceDisplays a given resource in a Scheduler control or returns the position of the first resource visible in a Scheduler control.
SchedulerSelectMinusDeselects an appointment from a Scheduler control.
SchedulerSelectPlusSelects an appointment in a Scheduler control.
SchedulerTimeDisplayedDefines the time range displayed by the Scheduler control in Day mode or in Week mode.
SchedulerToiCalendarExports the appointments from a Scheduler control in iCalendar format.
SpeechSynthesisInitializeInitializes the parameters of the speech synthesis for the current application.
SpeechSynthesisInProgressUsed to find out whether a read operation is in progress on the engine for speech synthesis.
SpeechSynthesisReadFileReads the content of the specified file by using the engine for speech synthesis found on the device.
SpeechSynthesisReadTextReads the specified text by using the engine for speech synthesis found on the device.
SpeechSynthesisStopStops all the current read operations on the engine for speech synthesis.
StartShareOpens a popup allowing you to select the application that will be used to share a resource (text or document).
SysNationReturns the nation currently used by the system.
TableAddInProgressModifies or returns the visibility status of the internal wait window when adding additional elements into an infinite 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.
TraceBuildDisplays a customizable message in the trace window opened in parallel of the current window.
VideoCaptureSaves the video currently broadcasted by a "camera" as an image or a video sequence.
VideoDisplayDisplays in a "Camera" control the video sequence currently broadcasted by a "web camera" or by the camera of the mobile device.
VideoListParameterLists the values supported by the camera of the device for a given parameter.
VideoParameterReturns or modifies the value of a parameter for the device camera.
VideoStatusReturns the status of a Camera control.
VideoStopStops displaying or recording a video sequence in a Camera control.
WinInitializedAllows you to find out whether the "end of initialization" code was run for a window.
Apple Watch The new WLanguage functions for Apple Watch are as follows:
AddAdds an element in last position:
  • of a one-dimensional WLanguage array.
  • of an advanced array property (array of events of gglCalendar, ...).
  • of a WLanguage list.
AddColumnAdds a column at the end of a two-dimensional array property (xlsDocument variable for example).
AddLineAdds a row at the end:
  • of a one- or two-dimensional WLanguage array.
  • of a two-dimensional array property of a variable type (xlsDocument variable for example).
AnsiToUnicodeConverts:
  • a character string in ANSI format (Windows) into a character string in UNICODE format.
  • a buffer containing a character string in ANSI format (Windows) into a buffer containing a character string in UNICODE format.
ArrayAddAdds an element in last position:
  • of a one-dimensional WLanguage array.
  • of an advanced array property (array of events of gglCalendar, ...).
  • of a WLanguage list.
ArrayAddLineAdds a row at the end:
  • of a one-dimensional or two-dimensional array.
  • of an advanced two-dimensional array property (xlsDocument, …).
ArrayAddSortedAdds an element into a one-dimensional array while taking into account the sort criterion defined by ArraySort.
ArrayCopyCopies the content of an array into another array.
ArrayCountReturns:
  • the number of elements found in a one-dimensional array.
  • the number of rows found in a two-dimensional array.
  • the number of elements found in the first dimension of a three-dimensional or n-dimensional array.
ArrayDeleteDeletes an element at a given position:
  • from a one-dimensional WLanguage array.
  • from an advanced array property (array of gglCalendar events, ...).
  • from an associative array.
  • from a WLanguage list.
ArrayDeleteAllDeletes all the elements:
  • from a one-dimensional or two-dimensional WLanguage array.
  • from an associative array.
  • from an advanced array property (array of gglCalendar events, ...).
  • from a WLanguage queue.
  • from a WLanguage stack
  • from a WLanguage list.
ArrayDeleteDuplicateDeletes the duplicates from an array.
ArrayDeleteLineDeletes a row at a given position:
  • from a two-dimensional array.
  • from the advanced array property (array of gglCalendar events, …)
The size of the array is automatically reduced.
ArrayInfoReturns the characteristics of an array: type of the elements, number of dimensions, dimensions, ...
ArrayInsertInserts an element at a given position:
  • into a one-dimensional array.
  • into an associative array.
  • into an advanced array property (array of gglCalendar events, ...).
  • into a WLanguage list.
ArrayInsertLineInserts a row at a given position:
  • into a two-dimensional WLanguage array.
  • into an advanced two-dimensional array property (xlsDocument, ...).
ArrayMixMixes the elements of a WLanguage array.
ArrayMoveUsed to:
  • move an element in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, ...). The other array elements are moved accordingly.
  • swap two elements in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, ...).
ArrayMoveLineUsed to:
  • move a row in a two-dimensional array or in an advanced array property. The other array rows are moved accordingly.
  • swap two rows in a two-dimensional array or in an advanced array property.
ArrayReverseReverses the content of a one-dimensional array.
ArraySeekSeeks the subscript of an element in a WLanguage array.
ArraySeekByProcedureSeeks an element in a one-dimensional array by using a comparison procedure.
ArraySortSorts a WLanguage array.
ArraySwapLineUsed to swap two rows in a two-dimensional array or in an advanced array property.
ArrayToCSVConverts a one-dimensional array or a two-dimensional array into a character string in CSV format.
ArrayToStringConverts a one-dimensional array or a two-dimensional array into a character string.
AscReturns the ASCII code of the specified character.
awProcedureGetAndSendInfoSpecifies the WLanguage procedure that will be called when receiving information coming from awSendAndGetInfo.
awProcedureGetInfoSpecifies the WLanguage procedure that will be called when receiving information coming from awSendInfo.
awSendAndGetInfoSends data from an iOS phone to an Apple Watch (or conversely) while expecting an answer.
awSendInfoSends an information from an iOS phone to an Apple Watch (or conversely).
ChangeCharsetRetrieves and/or changes the character set used:
  • by all the screen fonts.
  • by all the operations performed on the character strings (functions and/or operators).
CharactReturns the character corresponding to the specified ASCII code.
CharactTypeReturns information about the type of a character.
CharactTypeOccurrenceReturns the number of characters matching the information of a given type.
CharactUnicodeReturns the character corresponding to the specified Unicode code
ChronoEndStops a stopwatch and returns the time passed (in milliseconds) since the start of timing (call to ChronoStart).
ChronoPausePauses a stopwatch in order to measure the time spent on a process.
ChronoResetStops and resets an existing stopwatch to zero.
ChronoResumeRestarts a stopwatch that was stopped by ChronoEnd or ChronoPause.
ChronoStartStarts a stopwatch to find out the duration of a process (in milliseconds) and resets an existing stopwatch.
ChronoValueIndicates the time passed (in milliseconds) since the call to ChronoStart.
CloseCloses a WINDEV window (and returns a value if necessary).
CombinationCheckNameChecks whether a combination of one of more options known by their names is valid.
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.
CommonLengthReturns the number of characters common to two characters strings (from the beginning or from the end).
CompleteReturns a character string of a given size.
CompleteDirAdds (if necessary) the "\" character at the end of a character string.
ContainsUsed to find out whether a sub-string is included in a string.
ConvertConverts a numeric value into a binary string in order to perform a search on a numeric key.
CriticalSectionEndMarks the end of a critical section: the code will be run by another thread.
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.
CSVToArrayFills a one- or two-dimensional array of the specified type with the character string in CSV format passed in parameter.
DataTypeIdentifies the type of a WLanguage variable.
DateTimeByDefaultUsed to define the default value of the Date, Time and DateTime variables.
dbgAssertUsed to find out and signal the possible errors via an assertive programming.
dbgAuditOptionRetrieves or modifies the options of the dynamic audit.
dbgAuditStatusRetrieves and modifies the status of the dynamic audit.
dbgCheckDifferentChecks whether the specified expressions are different in assertive programming and in automatic test mode.
dbgCheckEqualChecks whether the expressions are equal in assertive programming and in automatic test mode.
dbgCheckFalseChecks whether an expression is false in assertive programming and in automatic test mode.
dbgCheckNotNullChecks whether an expression is not Null in assertive programming and in automatic test mode.
dbgCheckNullChecks whether an expression is Null in assertive programming and in automatic test mode.
dbgCheckTrueChecks whether an expression is set to True in assertive programming and in automatic test mode.
dbgEnableAssertEnables or disables the assertive programming.
dbgEnableAuditEnables the dynamic audit by programming.
dbgEnableLogEnables the runtime log by programming.
dbgErrorProvokes:
  • an assertion during the test of the element or project (Go mode).
  • an error in automatic test mode.
dbgInfoReturns a debug information.
dbgLogOptionRetrieves or modifies the options of the runtime log.
dbgLogStatusReturns and modifies the status of the runtime log.
dbgOnErrorDefines the WLanguage procedure that will be called whenever an error is detected by a function from the dbgCheckXXX family.
dbgStandardOutputWrites an information into the standard output stream "stdout" (also called "console").
dbgWriteCommentAuditWrites a comment into the current dynamic audit.
dbgWriteWarningAuditWrites a custom runtime warning into the dynamic audit.
DeleteDeletes an element at a given position
  • from a one-dimensional WLanguage array
  • from an advanced array property (array of gglCalendar events, ...)
  • from an associative array
  • from a WLanguage list.
DeleteAllDeletes all the elements
  • from a one-dimensional or two-dimensional WLanguage array
  • from an associative array
  • from an advanced array property (array of gglCalendar events, ...)
  • from a WLanguage queue.
  • from a WLanguage stack
  • from a WLanguage list.
DeleteColumnDeletes a column at a given position from the advanced array property (array of events of gglCalendar, …).
DeleteLineDeletes a row at a given position:
  • from a two-dimensional array.
  • from the advanced array property (array of gglCalendar events, ...).
DequeueDequeues an element from a queue.
DeserializeDeserializes a buffer or a character string containing the data of a class, structure, array (including an associative array), queue, stack, list or advanced variable as well as their sub-elements.
DimensionReturns the size of a variable (string, numeric, array, ...) or resizes a dynamic array.
EndAutomatedProcedureStops the current or forthcoming execution of an automatic procedure (defined by the properties of the procedure in the code editor).
EndProgramEnds the execution of the current program.
EndTimerSysEnds the execution of a timer triggered by TimerSys.
EnqueueEnqueues an element into a queue.
EnumerationCheckNameChecks whether an enumeration value known by its name is valid.
EnumerationCheckValueChecks whether an enumeration value known by its associated value is valid.
EnumerationFromNameReturns an enumeration value known by its name.
EnumerationFromValueReturns an enumeration value known by its associated value.
ErrorChangeParameterConfigures the automatic behavior that will be implemented if an error occurs in the current process.
ErrorInfoRetrieves information about the last error that occurred in a function of a WINDEV, WINDEV Mobile or WEBDEV component.
ErrorPropagatePropagates a non-fatal error that can be processed by the calling code if the management of non-fatal errors was enabled for this code (in the code editor or by ErrorChangeParameter).
ErrorRestoreParameterRestores the error process of a process.
ErrorThrowTriggers a non-fatal error.
EventChangeModifies the status of a signal.
EventCloseCloses a synchronization signal between several threads.
EventCreateCreates a signal.
EventDestroyExplicitly destroys a signal.
EventOpenOpens a synchronization signal between several threads.
EventWaitLocks the current thread while waiting for the specified signal to be opened.
ExceptionChangeParameterConfigures the automatic behavior that will be implemented if an exception occurs in the current process.
ExceptionDisplayDisplays the standard window of exceptions with the content of the current exception.
ExceptionEnableRe-enables the current exception process if the exception was corrected.
ExceptionInfoRetrieves information about the current exception.
ExceptionPropagatePropagates an exception.
ExceptionRestoreParameterRestores the exception process of a process.
ExceptionThrowArtificially triggers the security mechanism of WLanguage by throwing an exception.
ExecuteStarts the execution of a process by programming.
ExecuteMainThreadTriggers the execution of the procedure specified in the main thread of the application.
ExecuteProcessStarts the execution of a process by programming (which means without any particular action performed by the user).
ExecutionModeUsed to:
  • find out and/or modify the behavior of the application or site when some errors are generated.
  • optimize the calls to the functions declared externally.
  • find out and/or modify how the JITc technology is used by the application.
  • find out and/or modify the management mode of low references for all the instantiated objects.
ExtractLineExtracts a specific line from a character string.
ExtractStringUsed to:
  • extract a sub-string from a character string according to a given string separator.
  • browse the sub-strings in a character string according to a given string separator.
FileToArrayFills an array of classes or structures with the content of a HFSQL data file or query.
FileToMemoryAutomatically initializes the values of the members found in a class or in a structure with the values of the items of the current file record.
GetDefinitionRetrieves the definition of the element type.
GetTypeDefinitionRetrieves the description of a type identified by its name.
In64bitModeIndicates whether the code is run in 64-bit mode or not.
InAJAXModeSpecifies whether the code is run from:
InAndroidEmulatorModeIndicates whether the code is run in the Android emulator or not.
InAndroidModeIndicates whether the code is run in Android mode.
InAndroidSimulatorModeIndicates whether the code is run in the Android simulator.
InAppleWatchEmulatorModeIndicates whether the code is run in the Apple Watch emulator.
InAppleWatchModeIndicates whether the code currently run is in Apple Watch mode.
InAppleWatchSimulatorModeIndicates whether the code is run in the Apple Watch simulator.
InAutomaticTestModeEnables you to find out whether an automatic test is currently run or not.
InAWPModeUsed to find out whether the page currently run is an AWP page.
InComponentModeIndicates whether the code is run:
  • from a WINDEV application, a WEBDEV site or a PHP page.
  • from a component.
InDelayedProcedureModeIndicates whether the code is run from a delayed procedure or from a scheduled task on the WEBDEV application server.
InFactoryModeIndicates whether the code is run by an action plan of the software factory.
IniOSEmulatorModeIndicates whether the code is run in the iOS emulator (iPhone, iPad).
IniOSModeIndicates whether the code currently run is in iOS mode (iPhone, iPad).
IniOSSimulatorModeIndicates whether the code is run in the iOS simulator (iPhone, iPad).
InJavaModeIndicates whether the code is run in Java.
InLinuxModeIndicates whether the code is run in Linux mode or not.
InPHPModeIndicates whether the code is run in PHP.
InPHPSimulatorModeIndicates whether the code is run in PHP simulator mode.
InPocketModeIndicates whether the code is run:
  • from a WINDEV Mobile application.
  • from a standard WINDEV application, from a WEBDEV site or from a PHP application.
Function kept for backward compatibility.
InPocketSimulatorModeIndicates whether the code is run in the Pocket simulator.
InPrelaunchedSessionModeUsed to find out whether the site is started in "pre-launched session" mode of WEBDEV.
InReportsAndQueriesModeIndicates whether the code is run during the test of a report or query in Reports & Queries.
InsertInserts an element at a given position:
  • into a one-dimensional WLanguage array.
  • into an associative array.
  • into an advanced array property (array of gglCalendar events, ...).
  • into a WLanguage list.
InsertColumnInserts a column at a given position into an advanced two-dimensional array property (xlsDocument, …).
InsertLineInserts a row at a given position:
  • into a two-dimensional WLanguage array.
  • into an advanced two-dimensional array property (xlsDocument, ...).
InServiceModeIndicates whether the code is run in a service.
InSimulatorModeUsed to find out whether the application is started in "simulator test mode" from WINDEV Mobile.
InStoredProcedureModeIndicates whether the code is run on a HFSQL server.
InTestModeIndicates whether the application or the site is started:
  • from the WINDEV or WEBDEV editor,
  • from the executable or the browser.
  • WebDev - Server code from the WEBDEVadministrator.
InTSEModeIndicates whether the code is run:
  • from a computer in TSE mode or from a remote desktop
  • from a computer directly.
InUMCModeIndicates whether the code is run from a code written in a user macro-code.
InUniversalWindowsAppModeIndicates whether the code is run in Universal Windows 10 App mode.
InUniversalWindowsAppSimulatorModeIndicates whether the code is run in the simulator for the applications in Universal Windows 10 App mode.
InWebModeIndicates whether the current process is run:
  • from a WINDEV executable.
  • from the WEBDEV runtime engine (AWP).
InWebserviceModeUsed to find out whether the execution is in progress in the AWWS engine.
InWidgetModeIdentifies whether the code is run in Android Widget mode.
InWindowsMobileModeIndicates whether the code is run:
  • from a Windows Mobile application.
  • from a standard WINDEV application, from a WEBDEV site or from a PHP application.
InWindowsModeIndicates whether the code is run in Windows mode or not.
InWindowsPhoneEmulatorModeIndicates whether the test is run via the Windows Phone emulator.
Function kept for backward compatibility.
InWindowsPhoneModeIndicates whether the code is run in Windows Phone mode.
Function kept for backward compatibility.
InWindowsPhoneSimulatorModeIndicates whether the code is run in the Windows Phone simulator.
Function kept for backward compatibility.
InWindowsStoreAppModeIndicates whether the code is run in Windows Store apps mode.
Function kept for backward compatibility.
InWindowsStoreAppSimulatorModeIndicates whether the code is run in the simulator for the applications in Windows Store apps mode.
Function kept for backward compatibility.
JSONToVariantConverts a string in JSON format into a Variant variable.
LanguageToCharsetReturns the character set corresponding to a language.
LanguageToNameReturns the name of a language.
LanguageToNationReturns the nation corresponding to a language.
LeftExtracts the left part (which means the first characters) from a character string or from a buffer.
LengthReturns:
  • the size of a character string, which means the number of characters found in the character string (including the space and binary 0 characters).
  • the size of a buffer, which means the number of bytes found in the buffer.
LineToPositionReturns the position of the first character of a line in a block of text.
ListInfoRetrieves the characteristics of a list: types of elements and number of elements.
LowerConverts a character string into lowercase characters according to the localization settings defined in Windows.
MeanCalculates the mean of several elements:
  • elements found in an array,
  • numeric values, ...
MemoryToFileAutomatically initializes the memory value of the items for the current file record with the values of the members of a class or structure.
MessTranslateRetrieves a message found in the code of a program in the current language.
MiddleExtracts
  • a sub-string from a given position in a string.
  • a section from a given position in a buffer.
MoveUsed to:
  • move an element in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, ...). The other array elements are moved accordingly.
  • swap two elements in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, ...).
MoveColumnMoves or exchanges a column in a two-dimensional array property of advanced type (xlsDocument, …).
MoveLineUsed to:
  • move a row in a two-dimensional WLanguage array or in an advanced array property. The other array rows are moved accordingly.
  • swap two rows in a two-dimensional WLanguage array or in an advanced array property.
NationDefines or identifies the display language (captions, messages, ...) used for the windows, pages, reports and controls.
NationRightToLeftUsed to find out whether the current language is written from right to left.
NationToLanguageReturns the language corresponding to a nation.
NoAccentTransforms the accented characters found in a character string into non-accented characters.
NoCharacterReturns a character string without the specified characters found on the left and on the right.
NoLeftCharacterReturns a character string without the specified characters found on the left of the initial string.
NoRightCharacterReturns a character string without the specified characters found on the right of the initial string.
NoSpaceReturns a character string without the space characters
  • found on the right and on the left.
  • found inside the string.
OpenChildOpens a non-modal child window.
OpenMobileWindowOpens a window in a mobile application.
ParallelTaskCancelImmediately ends the execution of the current task: the task is flagged as ptsCanceled.
ParallelTaskConfigureModifies the parameters of parallel tasks.
ParallelTaskExecuteTriggers the execution of a parallel task.
ParallelTaskExecuteAfterIndicates a continuation parallel task that will be run when one of the specified parallel task is ended.
ParallelTaskExecuteAfterAllIndicates a continuation parallel task that will be run when all the tasks found in an array of parallel tasks are ended.
ParallelTaskExecuteAfterOneIndicates a continuation parallel task that will be run once the first task is ended in an array of parallel tasks.
ParallelTaskRequestCancelationRequests the cancelation of a parallel task.
ParallelTaskWaitWaits for the end of execution of a parallel task.
ParallelTaskWaitAllWaits for the end of execution of all the parallel tasks found in an array.
PopPops an element from a stack.
PositionFinds the position of a character string inside another character string.
PositionOccurrenceFinds the Xth position of a character string in a character string.
PositionToLineReturns the number of the line to which belongs a character identified by its position in a block of text.
ProjectInfoReturns specific information about the project currently run.
PropertyExistUsed to find out whether a property exists on a control or on a class instance.
PushPushes an element into a stack.
QueueInfoRetrieves the characteristics of a queue: types of elements and number of elements.
RepeatStringConcatenates N repetitions of the same character string or buffer.
ReplaceReplaces all the occurrences of a word found in a string by another word.
ReverseReturns the complement to 255 for each character found in a character string.
RightExtracts the right part (which means the last characters) from a character string or from a buffer.
SeekSeeks the subscript of an element in a WLanguage array.
SeekByProcedureSeeks an element in a one-dimensional array by using a comparison procedure.
SeekProcedureSeeks a procedure identified by its name. The procedure found can be run directly.
SemaphoreCreateCreates a semaphore.
SemaphoreDestroyExplicitly destroys a semaphore.
SemaphoreEndAllows one or more threads to exit from the area protected by the semaphore.
SemaphoreStartLocks the current thread until the semaphore is opened (which means until a "free" spot becomes available in the protected section).
SerializeTransforms the following elements into a specific format:
  • a structure (and its sub-elements),
  • a class (and its sub-elements),
  • an array (including the associative arrays),
  • a queue,
  • a stack,
  • a list box
SortSorts a WLanguage array.
StackInfoRetrieves the characteristics of a stack: types of elements and number of elements.
StringBuildBuilds a character string according to an initial string and to parameters.
StringCompareCompares two strings character by character:
  • according to the sequence of ASCII characters.
  • according to the alphabetical order.
StringCountCalculates:
  • the number of occurrences of a specific character string (by respecting the search criteria) in another character string.
  • the number of occurrences of a set of strings found in an array.
StringDeleteDeletes:
  • all the occurrences of a sub-string inside a string.
  • a section of string inside a string. The part of string to remove is identified by its position and length.
StringEndsWithChecks whether a character string ends:
  • with a specific character string.
  • with one of the character strings found in a list.
StringFormatFormats a character string according to the selected options.
StringIncrementIncrements a number found at the beginning or at the end of a character string.
StringInsertInserts a string into another character string at a given position.
StringReverseReverses the characters of a string.
StringStartsWithChecks whether a character string starts:
  • with a specific character string.
  • with one of the character strings found in a list.
StringToArrayFills a one- or two-dimensional array of the specified type with the character string passed in parameter.
StringToUTF8Converts a string in ANSI or UNICODE format into a string in UTF8 format.
SumCalculates the sum of the array elements.
SwapLineUsed to swap two rows in a two-dimensional array or in an advanced array property.
ThreadCurrentReturns the name of the thread currently run.
ThreadEndEnds the execution of the current thread.
ThreadExecuteStarts the execution of a secondary thread.
ThreadModeChanges the management mode of threads.
ThreadPausePauses the current thread during the specified duration.
ThreadSendSignalThe current thread sends a signal to the specified thread in order to unlock it.
ThreadStateReturns the current status of a thread.
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.
TraceDisplays the requested information (content of a control for example) in a window opened in parallel of the current window.
TraceBuildDisplays a customizable message in the trace window opened in parallel of the current window.
TraceEndCloses the trace window if this window was opened or stops saving the trace information in a text file.
TraceStartOpens the trace window or saves the trace information in a text file.
TruncateTruncates the right part of a string or buffer.
TypeVarIdentifies the type of an expression, a variable (during a call to a procedure for example) or a control.
UncompleteDirRemoves the "/"' or "\"' character found at the end of a string.
UnicodeToAnsiConverts:
  • a character string in UNICODE format into a character string in ANSI format (Windows).
  • a buffer containing a character string in UNICODE format into a buffer containing a character string in ANSI format (Windows).
UpperConverts a character string into uppercase characters according to the localization settings defined in Windows.
UTF8ToAnsiConverts a string in UTF8 format into a string in Ansi format.
UTF8ToStringConverts a string in UTF8 format into a string in ANSI or UNICODE format.
UTF8ToUnicodeConverts a string in UTF8 format into a Unicode string.
ValReturns the numeric value of a character string.
VariableResetResets the variable to its initial value.
VariantConvertConverts the value stored in a Variant variable.
VariantToJSONConverts the content of a Variant variable to JSON format.
WinDevVersionReturns the version number of the wdxxxvm DLL.
WinStatusIdentifies or modifies the status of a window.
WordOccurrenceReturns the number of words in a string.
WordToArrayFills an array with the words of a string.
Universal Windows 10 App The new WLanguage functions for Universal Windows 10 App are as follows:
AbandonCloses the current window by running the code of the CANCEL button.
AbsReturns the absolute value of a numeric value or numeric expression (integer or real).
AddAdds an element in last position:
  • of a one-dimensional WLanguage array.
  • of an advanced array property (array of events of gglCalendar, ...).
  • of a WLanguage list.
AddColumnAdds a column at the end of a two-dimensional array property (xlsDocument variable for example).
AddLineAdds a row at the end:
  • of a one- or two-dimensional WLanguage array.
  • of a two-dimensional array property of a variable type (xlsDocument variable for example).
AgeReturns the age according to the date of birth.
AlbumPickerRetrieves a photo, an image or a video stored in the photo album of the mobile device.
AlbumSaveSaves an image, a photo or a video in the photo album of the mobile device.
AnsiToUnicodeConverts:
  • a character string in ANSI format (Windows) into a character string in UNICODE format.
  • a buffer containing a character string in ANSI format (Windows) into a buffer containing a character string in UNICODE format.
AppOpenFormOpens the form of an application on Android (Play Store), iOS (App Store) or Windows (Windows Store) in order for the user to give a mark to it and/or to comment it.
ArcCosReturns the arc cosine of a numeric value (integer or real).
ArcSinReturns the arc sine of a numeric value (integer or real).
ArcTanReturns the arc tangent of a numeric value (integer or real).
ArcTan2Returns the arc tangent 2 of the values passed in parameter.
ArrayAddAdds an element in last position:
  • of a one-dimensional WLanguage array.
  • of an advanced array property (array of events of gglCalendar, ...).
  • of a WLanguage list.
ArrayAddLineAdds a row at the end:
  • of a one-dimensional or two-dimensional array.
  • of an advanced two-dimensional array property (xlsDocument, …).
ArrayAddSortedAdds an element into a one-dimensional array while taking into account the sort criterion defined by ArraySort.
ArrayCopyCopies the content of an array into another array.
ArrayCountReturns:
  • the number of elements found in a one-dimensional array.
  • the number of rows found in a two-dimensional array.
  • the number of elements found in the first dimension of a three-dimensional or n-dimensional array.
ArrayDeleteDeletes an element at a given position:
  • from a one-dimensional WLanguage array.
  • from an advanced array property (array of gglCalendar events, ...).
  • from an associative array.
  • from a WLanguage list.
ArrayDeleteAllDeletes all the elements:
  • from a one-dimensional or two-dimensional WLanguage array.
  • from an associative array.
  • from an advanced array property (array of gglCalendar events, ...).
  • from a WLanguage queue.
  • from a WLanguage stack
  • from a WLanguage list.
ArrayDeleteDuplicateDeletes the duplicates from an array.
ArrayDeleteLineDeletes a row at a given position:
  • from a two-dimensional array.
  • from the advanced array property (array of gglCalendar events, …)
The size of the array is automatically reduced.
ArrayInfoReturns the characteristics of an array: type of the elements, number of dimensions, dimensions, ...
ArrayInsertInserts an element at a given position:
  • into a one-dimensional array.
  • into an associative array.
  • into an advanced array property (array of gglCalendar events, ...).
  • into a WLanguage list.
ArrayInsertLineInserts a row at a given position:
  • into a two-dimensional WLanguage array.
  • into an advanced two-dimensional array property (xlsDocument, ...).
ArrayMixMixes the elements of a WLanguage array.
ArrayMoveUsed to:
  • move an element in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, ...). The other array elements are moved accordingly.
  • swap two elements in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, ...).
ArrayMoveLineUsed to:
  • move a row in a two-dimensional array or in an advanced array property. The other array rows are moved accordingly.
  • swap two rows in a two-dimensional array or in an advanced array property.
ArrayReverseReverses the content of a one-dimensional array.
ArraySeekSeeks the subscript of an element in a WLanguage array.
ArraySeekByProcedureSeeks an element in a one-dimensional array by using a comparison procedure.
ArraySortSorts a WLanguage array.
ArraySwapLineUsed to swap two rows in a two-dimensional array or in an advanced array property.
ArrayToCSVConverts a one-dimensional array or a two-dimensional array into a character string in CSV format.
ArrayToStringConverts a one-dimensional array or a two-dimensional array into a character string.
AscReturns the ASCII code of the specified character.
BankHolidayIndicates whether a day is a bank holiday or not.
BankHolidayAddIndicates that a day (or a list of days) is a holiday.
BankHolidayDeleteAllClears the list of all bank holidays.
BankHolidayListReturns the list of bank holidays defined by BankHolidayAdd.
BCDecodeDecodes the information stored in a QR Code bar code.
BinaryANDReturns the result of a logical AND (bit by bit) between two values.
BinaryNOTReturns the result of a logical NOT (bit by bit) performed on a value.
BinaryORReturns the result of a logical OR (bit by bit) between two values.
BinaryXORReturns the result of a logical exclusive OR (bit by bit) between two values.
BrowserRunAppOpens the default Web browser of the current device.
BufferToHexaConverts a buffer into a displayable hexadecimal string (for example: "4A 5B 00").
BufferToIntegerExtracts an integer found in a binary buffer at a given position.
BufferToRealExtracts a real found in a binary buffer at a given position.
CalendarPositionReturns the month displayed in a Calendar control.
CalendarSelectReturns the date selected in a Calendar control.
CalendarSelectMinusDeselects a date in a multi-selection Calendar control.
CalendarSelectOccurrenceReturns the number of days selected in a Calendar control.
CalendarSelectPlusSelects a date in a Calendar control.
ChangeCharsetRetrieves and/or changes the character set used:
  • by all the screen fonts.
  • by all the operations performed on the character strings (functions and/or operators).
ChangeSeparatorChanges the value of the separators (decimal separator or thousand separator) used in the numeric masks for internationalization.
ChangeSourceWindowDynamically changes the window displayed in an Internal Window control.
Case of scrolling internal windows: Modifies the window currently displayed. This modification is saved in the list of internal windows to scroll.
CharactReturns the character corresponding to the specified ASCII code.
CharactTypeReturns information about the type of a character.
CharactTypeOccurrenceReturns the number of characters matching the information of a given type.
CharactUnicodeReturns the character corresponding to the specified Unicode code
ChronoEndStops a stopwatch and returns the time passed (in milliseconds) since the start of timing (call to ChronoStart).
ChronoPausePauses a stopwatch in order to measure the time spent on a process.
ChronoResetStops and resets an existing stopwatch to zero.
ChronoResumeRestarts a stopwatch that was stopped by ChronoEnd or ChronoPause.
ChronoStartStarts a stopwatch to find out the duration of a process (in milliseconds) and resets an existing stopwatch.
ChronoValueIndicates the time passed (in milliseconds) since the call to ChronoStart.
ClipboardRetrieves the text or the image found in the system clipboard.
CloseCloses a WINDEV window (and returns a value if necessary).
ColorHueCalculates the hue of a color.
ColorLightnessCalculates the lightness of a color.
ColorSaturationCalculates the saturation of a color.
CombinationCheckNameChecks whether a combination of one of more options known by their names is valid.
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.
ComboCloseForces the closing of the scroll list in a Combo Box control (simple or multi-column combo box).
ComboOpenExpands the list of a Combo box control (single-column or multi-column combo box).
CommandLineIdentifies and retrieves the different elements of the command line passed in parameter to the current program.
CommonLengthReturns the number of characters common to two characters strings (from the beginning or from the end).
CompleteReturns a character string of a given size.
CompleteDirAdds (if necessary) the "\" character at the end of a character string.
ConfirmDisplays a message in a standard dialog box that proposes "Yes", "No", "Cancel" and returns the user's choice.
ContactResetReinitializes:
ContainsUsed to find out whether a sub-string is included in a string.
ControlCloneCreates a new control from an existing control.
ControlCurrentReturns the name of the control currently in edit.
ControlDeletePermanently deletes a control from a window, a page or a report.
ControlEnabledUngrays a control or a group of controls found in a window. During this operation, an animation can be performed on the controls.
ControlErrorCustomizes the value displayed in the controls when the value cannot be displayed.
ControlExistChecks the existence of a control (or group of controls) in a window, in a page or in a report.
ControlGrayedGrays a control or a group of controls. During this operation, an animation can be performed on the controls.
ControlInvisibleMakes a control (or a group of controls) invisible in a window. During this operation, an animation can be performed on the controls.
ControlNoSpaceSpecifies whether the space characters on the right of the value found in the control are deleted.
ControlPaneReturns the name of the static or dynamic pane found in a Tab control associated with a control.
ControlPreviousSpecifies the name of the control that was in edit before the current control.
ControlTabReturns the name of the Tab control that contains the specified control.
ControlVisibleMakes a control (or a group of controls) visible in a window. During this operation, an animation can be performed on the controls.
ConversionConverts a value from a unit to another one.
ConvertConverts a numeric value into a binary string in order to perform a search on a numeric key.
CoordinateEditorToScreenConverts a size or a position specified in the reference dpi in the editor (160 dpi) to the native dpi of the screen on the device where the application is run.
CoordinateScreenToEditorConverts a size or a position specified in the native dpi of the screen on the device where the application is run to the reference dpi in the editor (160 dpi).
CosCalculates the cosine of an angle.
CoTanCalculates the cotangent of an angle.
CountReturns the number of occurrences of a control in a window, in a page or in a group of controls.
CriticalSectionEndMarks the end of a critical section: the code will be run by another thread.
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.
CryptEncrypts a character string in binary format or in ASCII format.
CSVToArrayFills a one- or two-dimensional array of the specified type with the character string in CSV format passed in parameter.
CurrentMonthReturns the current month.
CurrentTitleModifies the title of the current window (returned by CurrentWin) and the title bar.
CurrentWinIdentifies the window currently in edit.
CurrentYearReturns the current year in integer format.
dAlphaBlendBlends an image inside another image. This allows you to create fade-in effects between 2 images. This function handles the Image controls and the Image variables.
dArcDraws an arc of circle or an arc of ellipse:
  • in an Image control,
  • in an Image variable.
DataTypeIdentifies the type of a WLanguage variable.
DateDifferenceCalculates the number of days between two dates.
DateSysReturns or modifies the system date (date of the day defined on the current computer).
DateTimeByDefaultUsed to define the default value of the Date, Time and DateTime variables.
DateTimeDifferenceCalculates the difference between two dates and times.
DateTimeLocalToUTCConverts a date and a time expressed in local time (time zone, summer time, winter time) into a date and time expressed in universal time (UTC).
DateTimeToRealConverts a date and a time into an 8-byte real.
DateTimeUTCToLocalConverts a date and a time expressed in universal time (UTC) into a date and time expressed in local time (time zone, summer time, winter time).
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.
DateToDayReturns the day corresponding to a given date.
DateToDayInAlphaReturns the spelled-out day of the week corresponding to the specified date.
DateToIntegerTransforms a date into an integer.
DateToMonthInAlphaSpells out the month corresponding to the specified date.
DateToStringFormats:
  • the specified date to the specified format.
  • the specified date time to the specified format.
DateToWeekNumberReturns the number of the week corresponding to the specified date.
DateValidChecks the validity of a date found between January 01 0001 and December 31 9999.
DayNumberInAlphaReturns the name of the day of the week according to its number.
dBackgroundDeclares the default background color for the rectangles, the circles, ... used:
  • in an Image control,
  • in an Image variable.
dbgAssertUsed to find out and signal the possible errors via an assertive programming.
dbgAuditOptionRetrieves or modifies the options of the dynamic audit.
dbgAuditStatusRetrieves and modifies the status of the dynamic audit.
dbgCheckDifferentChecks whether the specified expressions are different in assertive programming and in automatic test mode.
dbgCheckEqualChecks whether the expressions are equal in assertive programming and in automatic test mode.
dbgCheckFalseChecks whether an expression is false in assertive programming and in automatic test mode.
dbgCheckNotNullChecks whether an expression is not Null in assertive programming and in automatic test mode.
dbgCheckNullChecks whether an expression is Null in assertive programming and in automatic test mode.
dbgCheckTrueChecks whether an expression is set to True in assertive programming and in automatic test mode.
dbgEnableAssertEnables or disables the assertive programming.
dbgEnableAuditEnables the dynamic audit by programming.
dbgEnableLogEnables the runtime log by programming.
dbgEndMemoryDiffSaves a memory dump containing the memory resources that have been allocated and that have not been freed since the previous call to dbgStartMemoryDiff.
dbgErrorProvokes:
  • an assertion during the test of the element or project (Go mode).
  • an error in automatic test mode.
dbgInfoReturns a debug information.
dbgLogOptionRetrieves or modifies the options of the runtime log.
dbgLogStatusReturns and modifies the status of the runtime log.
dbgOnErrorDefines the WLanguage procedure that will be called whenever an error is detected by a function from the dbgCheckXXX family.
dbgSaveDebugDumpSaves a debugging dump of the application.
dbgSaveMemoryDumpSaves a dump of the memory used by the application.
dbgStandardOutputWrites an information into the standard output stream "stdout" (also called "console").
dbgStartMemoryDiffStarts a difference operation of the memory used by the application.
dbgWriteCommentAuditWrites a comment into the current dynamic audit.
dbgWriteWarningAuditWrites a custom runtime warning into the dynamic audit.
dChordDraws the chord of a circle (intersection between an ellipse and a straight line):
  • in an Image control,
  • in an Image variable.
dCircleDraws a circle or an ellipse:
  • in an Image control,
  • in an Image variable.
dCopyCopies an image into another image.
dCopyBltCopies an image:
  • from an Image control into another Image control.
  • from an Image variable into another Image variable.
dCropReturns the cropped part of an image. This image is found in an Image variable.
DecimalPartReturns the decimal part of a number.
DecimalToSexagesimalReturns the sexagesimal angle (in base 60) corresponding to a decimal angle.
DeleteDeletes an element at a given position
  • from a one-dimensional WLanguage array
  • from an advanced array property (array of gglCalendar events, ...)
  • from an associative array
  • from a WLanguage list.
DeleteAllDeletes all the elements
  • from a one-dimensional or two-dimensional WLanguage array
  • from an associative array
  • from an advanced array property (array of gglCalendar events, ...)
  • from a WLanguage queue.
  • from a WLanguage stack
  • from a WLanguage list.
DeleteColumnDeletes a column at a given position from the advanced array property (array of events of gglCalendar, …).
DeleteLineDeletes a row at a given position:
  • from a two-dimensional array.
  • from the advanced array property (array of gglCalendar events, ...).
dEncrustColorEncrusts a color in an image found in an Image variable.
dEndDrawingFrees the image from memory.
DequeueDequeues an element from a queue.
DeserializeDeserializes a buffer or a character string containing the data of a class, structure, array (including an associative array), queue, stack, list or advanced variable as well as their sub-elements.
dFontDeclares the font that will be used by dText:
  • in an Image control,
  • in an Image variable.
dHaloAdds a halo effect on an image found in an Image variable.
dHorizontalSymmetryPerforms an horizontal symmetry of an image found:
  • in an Image control,
  • in an Image variable.
DialogDisplays a message box and returns the value of the button clicked by the user.
diffApplyApplies a difference buffer to a specific buffer.
diffCreateCompares two buffers and creates a buffer containing the differences between these two buffers.
DimensionReturns the size of a variable (string, numeric, array, ...) or resizes a dynamic array.
dInvertColorReverses the colors:
  • of an Image control,
  • of an Image variable.
dLineDraws a line:
  • in an Image control,
  • in an Image variable.
dLoadImageLoads an image in an Image variable from a memo, a file or a binary buffer.
dModifyHSLModifies the hue, the saturation and the lightness of an image found:
  • in an Image control,
  • in an Image variable.
dModifyHueModifies the hue of an image found:
  • in an Image control,
  • in an Image variable.
dModifyLightnessChanges the lightness of an image found:
  • in an Image control,
  • in an Image variable.
dModifySaturationModifies the saturation of an image found:
  • in an Image control,
  • in an Image variable.
dPenDeclares the default color and style for the lines, the rectangles, the circles, ... found:
  • in an Image control,
  • in an Image variable.
dPolygonDraws a polygon:
  • in an Image control,
  • in an Image variable.
dRectangleDraws a rectangle:
  • in an Image control,
  • in an Image variable.
dResizeResizes an image found
  • in an Image control,
  • in an Image variable
dRotationPerforms a rotation:
  • of an Image control,
  • of an image found in an Image variable.
dSaveImageBMPSaves an image:
  • in a file in BMP format.
  • in memory.
dSaveImageGIFSaves an image:
  • in a file in GIF format.
  • in memory.
dSaveImageJPEGSaves an image:
  • in a file in JPEG format.
  • in memory.
dSaveImagePNGSaves an image:
  • in a file in PNG format.
  • in memory.
dShadowAdds a shadow effect on an image found in an Image variable.
dSliceDraws a circle section or an ellipse section:
  • in an Image control,
  • in an Image variable.
dStartDrawingIndicates that the drawing functions that will be used are intended for:
  • the specified Image control,
  • the specified Image variable.
dTextDraws a text:
  • in an Image control,
  • in an Image variable.
DurationToStringFormats the specified duration into the specified format.
dVerticalSymmetryPerforms a vertical symmetry of an image found:
  • in an Image control,
  • in an Image variable.
EasterReturns the date of Easter for the specified year according to the western Christian calendar.
eChangeCurrencyConverts a currency into another currency.
eCurrencyNameReturns the caption of a currency.
eDefaultMemCurrencyIdentifies or modifies the stored currency used by default.
eDefaultViewCurrencyIdentifies or modifies the display currency used by default.
eExchangeRateReturns the value of the exchange rate for a currency.
eInitCurrencyAdds or modifies the characteristics of a currency in the exchange table of currencies.
EmailAddFolderAdds a folder into the messaging software (Outlook, messaging software using the IMAP protocol (Internet Message Access Protocol), ...).
EmailBuildSourceGenerates the source code of the outgoing email from the variables currently found in the email structure or in an Email variable].
EmailChangeFolderModifies the current folder in the messaging software (Outlook, messaging software using the IMAP protocol, ...).
EmailChangeStatusChanges the status of an email on a messaging server.
EmailCheckAddressChecks the validity of an email address.
EmailCloseSessionCloses a session for email management according to the selected mode (SMTP/POP3, IMAP, MS Exchange, Pocket Outlook or Lotus Notes).
EmailCopyCopies an email found in a directory to another directory of an IMAP server.
EmailCurrentFolderReturns the name of the current folder in the messaging software (Outlook, messaging software using the IMAP protocol (Internet Message Access Protocol), ...).
EmailDeleteMessageUsed to delete the current email according to the current protocol (POP3, IMAP, MS Exchange, Pocket Outlook, Lotus Notes or Outlook messaging).
EmailExpungeDestroys all the deleted emails marked as deleted ("Deleted" status) from the current folder of an IMAP session.
EmailGetAllRetrieves all the emails found on a server.
EmailGetIndicatorRetrieves the indicators defined on an email of an IMAP session.
EmailGetTimeOutReads the value of the "time-out" for connecting to the SMTP, POP3 and IMAP messaging servers
EmailImportHTMLImports, into the Email structure or into an Email variable, the content of an HTML file in order to send it by email.
EmailImportSourceFills an Email variable from the content of its ..Source property or the different variables of the email structure from the content of the Email.Source variable.
EmailListFolderReturns the list of folders:
  • found in the Outlook messaging software.
  • for an IMAP session.
EmailLoadAttachmentAdds an attached file to an email.
EmailMessageLengthCalculates the size of the specified message (without loading the message).
EmailMsgErrorReturns the message corresponding to the identifier of the error.
EmailNbMessageReturns the number of incoming messages currently found:
  • on the email server (POP3 protocol only).
  • in the Outlook messaging software.
EmailOpenMailOpens the default messaging software
  • of the Web user on the browser computer.
  • of the user on the current Windows computer.
  • on the phone
EmailProgressBarManages a progress bar while sending and receiving emails.
EmailReadFirstReads the first incoming email according to the protocol used (POP3 or IMAP, MS Exchange, Lotus Notes or Outlook).
EmailReadFirstHeaderReads the header of the first incoming email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadLastReads the last incoming email according to the protocol used (POP3 or IMAP, MS Exchange, Lotus Notes or Outlook).
EmailReadLastHeaderReads the header of the last incoming email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadMessageReads an incoming according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadMessageHeaderReads the header of an incoming email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadNextReads the incoming email found after the current email according to the protocol (POP3 or IMAP, MS Exchange, Lotus Notes or Outlook).
EmailReadNextHeaderReads the header of the email found after the current email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadPreviousReads the email found before the current email according to the protocol used (POP3 or IMAP, MS Exchange, Lotus Notes or Outlook).
EmailReadPreviousHeaderReads the header of the email found before the current email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailRemoveFolderDeletes a folder from the Outlook messaging software or from an IMAP server.
EmailResetRe-initializes all the variables of the email structure or all the variables of an Email variable.
EmailRunAppStarts the native application for sending emails found on the current computer
  • Computer running Windows,
  • Mobile device (Android, iPhone, iPad)
EmailSaveAttachmentCopies the file attached to the current email onto the user computer (locally).
EmailSendSends an email via the SMTP protocol while controlling the "buffer" of the email.
EmailSendMessageSends an email according to the protocol used (SMTP, MS Exchange, Pocket Outlook, Lotus Notes, Outlook).
EmailSetTimeOutChanges the value of the "time-out" for connecting to the SMTP, POP3 and IMAP messaging servers.
EmailStartIMAPSessionStarts a session for receiving and reading the emails with the IMAP protocol.
EmailStartPOP3SessionStarts a session for receiving and reading emails with the POP3 protocol.
EmailStartSessionStarts a session for email management according to the selected management mode (POP3, SMTP, IMAP, MS Exchange or Pocket Outlook).
EmailStartSMTPSessionStarts a session for sending emails with the SMTP protocol.
EndAutomatedProcedureStops the current or forthcoming execution of an automatic procedure (defined by the properties of the procedure in the code editor).
EndProgramEnds the execution of the current program.
EndTimerSysEnds the execution of a timer triggered by TimerSys.
EnqueueEnqueues an element into a queue.
EnumControlReturns the name of the Nth control found in the specified element.
EnumElementUsed to enumerate the project elements: windows, pages, reports, queries, ...
EnumerationCheckNameChecks whether an enumeration value known by its name is valid.
EnumerationCheckValueChecks whether an enumeration value known by its associated value is valid.
EnumerationFromNameReturns an enumeration value known by its name.
EnumerationFromValueReturns an enumeration value known by its associated value.
ErrorDisplays a custom error message in a system error window.
ErrorBuildDisplays a custom error message in a system error window.
ErrorChangeParameterConfigures the automatic behavior that will be implemented if an error occurs in the current process.
ErrorInfoRetrieves information about the last error that occurred in a function of a WINDEV, WINDEV Mobile or WEBDEV component.
ErrorPropagatePropagates a non-fatal error that can be processed by the calling code if the management of non-fatal errors was enabled for this code (in the code editor or by ErrorChangeParameter).
ErrorRestoreParameterRestores the error process of a process.
ErrorThrowTriggers a non-fatal error.
eToCurrencyConverts a value expressed in Euro into another currency.
eToEuroConverts a value expressed in a specific currency into Euro.
EvaluateExpressionEvaluates the value of an expression built in a character string.
EventChangeModifies the status of a signal.
EventCloseCloses a synchronization signal between several threads.
EventCreateCreates a signal.
EventDestroyExplicitly destroys a signal.
EventOpenOpens a synchronization signal between several threads.
EventWaitLocks the current thread while waiting for the specified signal to be opened.
ExceptionChangeParameterConfigures the automatic behavior that will be implemented if an exception occurs in the current process.
ExceptionEnableRe-enables the current exception process if the exception was corrected.
ExceptionInfoRetrieves information about the current exception.
ExceptionPropagatePropagates an exception.
ExceptionRestoreParameterRestores the exception process of a process.
ExceptionThrowArtificially triggers the security mechanism of WLanguage by throwing an exception.
ExecuteStarts the execution of a process by programming.
ExecuteCodeRuns the WLanguage code found in a character string.
ExecuteMainThreadTriggers the execution of the procedure specified in the main thread of the application.
ExecuteProcessStarts the execution of a process by programming (which means without any particular action performed by the user).
ExecuteUpdateUIImmediately runs the "Request for refreshing the display" process of the window or internal window.
ExecutionModeUsed to:
  • find out and/or modify the behavior of the application or site when some errors are generated.
  • optimize the calls to the functions declared externally.
  • find out and/or modify how the JITc technology is used by the application.
  • find out and/or modify the management mode of low references for all the instantiated objects.
ExpCalculates the exponential of a numeric value (reverse of Napierian logarithm).
ExtractLineExtracts a specific line from a character string.
ExtractStringUsed to:
  • extract a sub-string from a character string according to a given string separator.
  • browse the sub-strings in a character string according to a given string separator.
FactorialReturns the factorial of an integer number.
fAddBufferAdds the content of a buffer at the end of a file.
fAddTextAdds the content of a character string at the end of a file.
fAttributeReturns or modifies the attributes of a file.
fAttributeReadOnlySpecifies whether a text file is read-only and changes the read-only attribute of a file.
fBuildPathBuilds a complete file path from the directory and short name of a file. This function is mainly used to get a valid file name without having to worry about the presence of separators in the path ('/' or '\') or about their direction according to the platform.
fChangeSizeResizes an external file.
fCloseCloses an external file.
fCompareCompares the content of two files bit by bit.
fCompressCompresses a file.
fCopyFileCopies one or more files (regardless of their attributes).
fCreateCreates an external file.
fCryptEncrypts a file in binary or ASCII format.
fCurrentDirIdentifies or modifies the current directory.
fDataDirReturns the full path of the directory of HFSQL data files specified by the user when installing the application.
fDataDirUserReturns a directory path for the data of the current user of the current application.
fDateReturns or modifies the different dates associated with a file or with a directory (creation, modification or access).
fDateTimeReturns or modifies the different dates and times associated with a file or a directory (creation, modification or access).
fDeleteDeletes a file accessible from the current computer.
fDirFinds a file or a directory.
fDirAttributeReturns or modifies the attributes of a directory.
fDirectoryExistChecks the existence of a directory.
fDirExistChecks the existence of a directory.
fDirSizeReturns the size of a directory in bytes.
fExeDirReturns the directory from which the execution is started.
fExtractPathReturns the different elements of a path: disk, directories, name and extension of the file.
fExtractResourceExtracts a resource from the application into a physical location of the device.
fFileExistChecks the existence of an external file.
fFindFinds a character string or a buffer in a file opened by fOpen.
FileToArrayFills an array of classes or structures with the content of a HFSQL data file or query.
FileToMemoryAutomatically initializes the values of the members found in a class or in a structure with the values of the items of the current file record.
FileToScreenAutomatically initializes the controls found in a window or in a page with:
  • the values of the associated items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the status of the controls (grayed, inactive or invisible).
  • the values of the associated WLanguage variables. This operation is performed regardless of the status of the controls (grayed, inactive or invisible).
FinCurrentValReturns the current value of an investment.
FinDecreasingRedemptionCalculates the amortization value of a good over a specific period of time, via the formula for fixed-rate decreasing amortization.
FinErrorReturns the number of the last error caused by a Finxxx function (financial functions).
FinFutureValReturns the future value of an investment.
FinInterestRateCalculates the interest rate for a loan over a given period of time with fixed payments.
FinLinearRedemptionCalculates the value of linear amortization of a good over a specific period of time.
FinNetCurrentValReturns the net current value of an investment.
FinPaymentNbReturns the number of payments required to pay off a capital according to a given rate.
FinPeriodInterestCalculates for a given period the amount of interests due for a loan paid off by fixed periodic payments with a fixed interest rate.
FinRedemptionCreates an amortization matrix for a fixed-rate loan over a defined period of time.
FinRepayValReturns the amount of each regular payment for an investment with fixed interest rate and fixed payment.
FirstDayOfMonthReturns the first day of the month.
FirstDayOfWeekReturns the date of the first day of the week (which means Monday).
FirstDayOfYearReturns the date of the first day of the year.
fIsImageUsed to find out whether a file found on disk or a file contained in a buffer corresponds to a recognized image format.
fListDirectoryLists the sub-directories of a given directory and returns the list of sub-directories.
fListFileLists the files found in a directory and returns the list of files.
fLoadBufferLoads the content of a text file in a buffer variable.
fLoadTextLoads the content of a text file into any text control or text variable (string variable, edit control in a window, Static control in a report, ...).
fLockEntirely or partially locks an external file.
fMakeDirCreates a directory (and the intermediate directories if necessary).
fMergeMerges several files into a single one.
fMoveFileMoves a file from a directory into another one.
fNameOfFileReturns the name of an external file that is currently opened.
fOpenOpens an external file (ANSI or UNICODE) in order to handle it by programming.
fParentDirReturns the path of the parent directory for the specified directory.
fReadReads:
  • a block of bytes (characters) in an external file (ANSI or Unicode),
  • the content of an external file (ANSI or Unicode) and assigns it to a memory zone.
fReadLineReads a line in an external file (in ANSI or UNICODE format).
fReadLineRegularExpressionReads a line in an external file and retrieves in variables the sections of this line according to a regular expression.
fRemoveDirDeletes a directory from a disk.
fRenameModifies the name of a file.
fResourceDirReturns the path of the read-only resources of the application.
fSaveBufferCreates and fills a text file with the content of a string or buffer variable.
fSaveTextCreates and fills a text file with the content of a text control or text variable (string variable, edit control in a window, Static control in a report, ...).
fSeekReturns and modifies the current position in an external file.
fSepReturns the separator of directory according to the current platform ('\' or '/').
fSeparatorReturns a file path with normalized separators.
fSizeReturns the size of a file (in bytes).
fSizeUncompressedReturns the size of a file before compression. When a file is decompressed by fUncompress, we recommend that you to compare the non-compressed size of the file with the available disk space.
fSplitSplits a file into several files.
fTempDirReturns the name of the directory used to store the temporary files.
fTempPathReturns the name of the directory used to store the temporary files.
fTimeReturns or modifies the different times associated with a file or with a directory (creation, modification or access).
FullScreenEnables or disables the full-screen mode in the applications in Universal Windows 10 App mode.
fUncompressDecompresses a file that was compressed by fCompress.
fUncryptDecrypts a file that was encrypted by fCrypt.
fUnlockEntirely or partially unlocks an external file.
fWriteWrites:
  • a character string into an external file.
  • a memory section.
fWriteLineWrites a line into a text file (in ANSI or UNICODE format).
gAlignmentAligns a text or an image in an element found in a List Box or in a Combo Box control.
gBackgroundDescribes the display color:
  • for the background of the text displayed in an element of a List Box or Combo Box control,
  • for the inside section of a shape (rectangle or circle) displayed in an element of a List Box or Combo Box control.
gCircleDraws a circle or an ellipse in an element found in a List Box or Combo Box control.
gCoordPositions the cursor for writing a text in an element of a List Box or Combo Box control.
GeneratePasswordAutomatically generates a password with specific characteristics (size, characters used, ...).
geoAzimuthReturns the direction represented by a position in relation to another one.
geoDistanceReturns the distance between the two positions. This distance is expressed in meters by default.
geoGetAddressRetrieves an address (or a list of addresses) corresponding to the description of a geographical location.
GetColorEnables you to obtain a set of harmonious colors without having to use a color table .
GetCountryListReturns the list of countries according to the ISO 3166-1 standard.
GetDefinitionRetrieves the definition of the element type.
GetGUIDCalculates a globally unique identifier (named "GUID").
GetIdentifierCalculates a unique identifier (integer) for an executable or for a session.
GetTypeDefinitionRetrieves the description of a type identified by its name.
gFontDescribes the font used to display a text in a graphic List Box or Combo Box control.
gFontBoldIndicates whether the text that follows the call to this function is displayed in bold.
gFontItalicIndicates whether the text that follows the call to this function is displayed in italic or not.
gFontSizeIndicates the size of the font used to display a text in a graphic string.
gFontUnderlinedIndicates whether the text that follows the call to this function must be underlined or not.
gImageInserts an image into an element of a List Box or Combo Box control.
gLineDraws a line in an element of a List Box or Combo Box control.
gLinkAdds an "invisible" value into an element found in a List Box or Combo Box control.
gLinkActivateAllows (or not) to retrieve the value defined by gLink in a list box or in a combo box.
gPenDescribes the display color for the text and/or for the outline of a shape (rectangle or circle) in an element of a List Box or Combo Box control.
GPSDetectPositionAsks to be notified when the device gets close to a given position.
GPSEndIndicates the end of the use of the geo-localization functions
GPSFollowMovementAsks to be regularly notified about the current position of the device.
GPSGetPositionRetrieves information about the current position of the device.
GPSInfoReturns the information about the localization provider used by the application for the geo-localization functions.
GPSInitParameterInitializes the parameters of the WLanguage functions for geo-localization and finds a localization provider.
GPSLastPositionRetrieves the information about the last known position of the device.
GPSStatusRetrieves the activation status of the geo-localization provider or asks to be notified when the status changes.
GPSStopDetectionStops the detection of position that was started by GPSDetectPosition.
grAddDataAdds a data into a chart.
grAutoRefreshCategoryLabelIdentifies or defines whether the category labels are refreshed whenever the chart is drawn.
grAutoRefreshSeriesIdentifies or defines whether a series is refreshed whenever the chart is drawn.
grAxisTitleDefines the title of the X axis and the title of the Y axis in a chart.
grAxisTitleFontModifies the font used for the titles of the chart axes.
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.
grCategoryLabelInitializes the label of a data category (or section) in a chart.
grClearPictErases the drawing of a chart (in an Image control or in a window).
grColorReturns and initializes the color of the different chart elements.
grColumnSpacingIndicates the spacing between each data category in a column chart or in a Minimum/Maximum stock chart.
grCreateCreates a specific type of chart.
grCreateFontgrCreateFont is kept for backward compatibility.
grDeleteAllErases a chart and destroys this chart.
grDeleteSeriesDeletes a data series from a chart.
grDestinationControlDefines an Image control as destination of a chart.
grDestinationImageDefines an Image variable as destination of a chart.
grDonutHolePercentageModifies the percentage corresponding to the radius of the hole in a Donut chart.
grDrawDraws a chart according to the specified parameters.
gRectangleDraws a rectangle in an element found in a List Box or Combo Box control.
grExistChecks the existence of a chart in memory.
grGetDataRetrieves a data from a chart.
grGradientEnables or disables the display of color gradients in a chart.
grGraduateIndicates the step for the marks on the vertical/horizontal axis of a chart (which means the interval between two marks).
grGridlinesDisplays or hides the chart gridlines.
grHMAddDataAdds a data into a Heatmap chart.
grHMCaptionXModifies the caption of a category on the X axis of a Heatmap chart.
grHMCaptionYModifies the caption of a category on the Y axis of a Heatmap chart.
grHMColorSpecifies the colors of the different values in a Heatmap chart.
grHMDeleteColorDeletes the colors specified by grHMColor from a Heatmap chart.
grHMGetDataRetrieves a data from a Heatmap chart.
grIncreaseDataAdds a value to a data in a chart.
grInfoPointReturns the screen coordinates of a point or the screen coordinates of a value found in a chart.
grInfoXYReturns information about the series found at a specific point of the chart.
grLabelIndicates various parameters for the additional legend in a chart.
grLabelFontModifies the font used for the category labels of a chart.
grLegendIndicates the presence and position of the legend in a chart.
grLegendFontModifies the font used for the legend of a chart.
grLineThicknessRetrieves and/or modifies the value of the line thickness in a Line chart.
grLoadParameterRestores the parameters used to draw a chart.
grMaskFormats the data displayed by grLabel or by grTooltip.
grOrientationModifies the orientation of the chart axes.
grOriginModifies the start and end marks on one of the chart axes.
grOverlayChartUsed to display two different types of charts in the same chart.
grParameterRetrieves or modifies a parameter of a chart.
grPiePullOutPulls out a section (or all the sections) in a chart.
grPieStartAngleIndicates the start angle of the first section in a pie chart, semi-circular chart or donut chart.
grRaisedUsed to display a chart with a raised effect.
grScatterAddDataXYAdds a data into a "Scatter" chart.
grScatterGetDataXYRetrieves a data from a "Scatter" chart.
grScatterLinkPointLinks (or not) the points found in a "Scatter" chart.
grScatterPointSizeDefines the size of the points found in a "Scatter" chart.
grScatterSeriesColorInitializes the color of a series in a "Scatter" chart.
grScatterSeriesLabelInitializes the label of a data series in a "Scatter" chart.
grSeriesColorInitializes the color of a series or the color of a section.
grSeriesLabelInitializes the label of a data series in a chart.
grSeriesSecondaryAxisDefines whether a series will be drawn on the secondary axis.
grSmoothingSmoothes a Line chart or a Scatter chart by using the "cubic splines" algorithm.
grSourceCategoryLabelDefines the source of the category labels.
grSourceSeriesDefines the source of a series.
grStockAddDataAdds a data into a stock chart (candlestick, barcharts or minmax).
grStockGetDataRetrieves a data from a stock chart (candlestick, barcharts or minmax).
grTitleModifies the caption and/or the position of the chart title.
grTitleFontModifies the font used for the title of a chart.
grTypeIdentifies or modifies the type of a chart.
grWaterfallCategoryTypeIndicates the type of category in a Waterfall chart.
grWaterfallColorIndicates the color for a type of category in a Waterfall chart.
grZoomDefines the zoom of a chart.
gToTextDeletes the graphic elements from a character string that uses gLink, gImage, ...
HActivateAutoFilterEnables an automatic filter on the linked files when browsing an XML file.
HActivateFilterEnables the filter that was previously created for the specified data file (view or query).
HActivateTriggerRe-enables a trigger that was disabled by HDeactivateTrigger.
HAddAdds
  • the record found in memory into the data file (query or view)
  • the record found in a Record variable into the data file (query or view).
HAddGroupAdds a group of users.
HAddUserAdds a user to a database.
HAliasCreates a logical alias of a data file (or query) or cancels all the existing aliases.
HashCheckFileChecks the Hash of a file for a specific type of algorithm.
HashCheckStringChecks the Hash of a character string for a specific type of algorithm.
HashFileCalculates the Hash of a file according to a specific algorithm.
HashStringCalculates the Hash of a character string according to a specific algorithm.
HBackwardMoves backward several records from the current position in the data file, according to a specified item.
HBuildKeyValueBuilds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, ...).
HBuildKeyValueANSIRegardless of the platform used, the data saved in the HFSQL files is in ANSI format.
HCancelAliasCancels an alias that was declared beforehand by HAlias.
HCancelDeclarationAllows you to
HCancelSeekCancels the current search criterion.
HChangeConnectionDynamically changes the connection associated with a data file.
HChangeDirModifies the access path to a data file (which means the directory in which the file will be handled).
HChangeKeyChanges the search key.
HChangeNameModifies the physical name of a data file.
HChangePasswordChanges the password of a HFSQL Client/Server data file.
HCheckIndexChecks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file).
HCheckStructureDefines the mode for comparing the data files.
HCloseCloses a data file or all the data files opened by the current user: all the corresponding physical data files are closed for the current user.
HCloseAnalysisCloses the current analysis.
HCloseConnectionCloses a connection to a database.
HCompareItemCompares two values by sorting them according to the specified HFSQL index item: all the sort options specified for the item are taken into account (sensitivity to the case, to the punctuation, sort direction, Unicode language, ...).
HCopyFileCopies a HFSQL file (.fic, .ndx and .mmo files if they exist):
  • from the HFSQL server to the server (to perform a backup for example).
  • from the HFSQL server to the client (to perform a local backup for example).
  • from the client to the HFSQL server (to update the files for example).
  • from a HFSQL server to antoher HFSQL server.
HCopyRecordCopies:
  • the content of the current record (loaded in memory) into the current record of a data file.
  • the content of a Record variable into the current record of a data file.
HCreateMasterReplicaCreates the description file of a Master Replica (logged replication or universal replication).
HCreateMoveableReplicaCreates a movable replication.
HCreateSubscriberReplicaCreates the description file of a subscriber replica.
HCreateViewCreates a HFSQL view.
This function is using the former mechanism of views.
HCreationCreates an empty data file (".FIC" extension) with the index file and the memo file if necessary.
HCreationIfNotFoundPerforms the following operations:
  • If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation.
  • If the file exists, opens the file.
HCrossCrosses a record in a data file.
HDeactivateAutoFilterDisables an automatic filter on the linked files when browsing an XML file.
HDeactivateFilterTemporarily disables the filter on a data file (view or query).
HDeactivateTriggerDisables a trigger.
HDeclareDeclares a description of data file (found in an analysis) in the current project.
HDeclareExternalTemporarily imports into the current analysis the description of a file from an existing HFSQL file.
HDeleteDeletes a record from a data file (a query or a view).
HDeleteAllDeletes all the records from a data file, from a HFSQL view or from a query.
HDeleteDatabaseDeletes a database found on a HFSQL server.
HDeleteDirectoryDeletes a directory found in a HFSQL Client/Server database.
HDeleteFileDeletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server.
HDeleteGroupDeletes (from the server) a group of users associated with a connection.
HDeleteTriggerDestroys a trigger.
HDeleteUserDeletes a user associated with a connection from the sever.
HDeleteViewDestroys a view that was created beforehand. This function is using the former mechanism of views.
HDescribeConnectionDescribes a new connection to an external database.
HDescribeFileDescribes a data file by programming.
HDescribeFullTextIndexDescribes a full-text index of a data file created by programming.
HDescribeItemDescribes by programming an item found in a data file.
HDescribeKeyHDescribeKey is kept for backward compatibility (this function will still be supported in the forthcoming version).
HDescribeLinkDescribes a link between two data files by programming.
HDescribeTriggerAdds or modifies a trigger on a HFSQL data file.
HDisconnectClientDisplays a message on the client computers and disconnects the application.
HDuplicateRecordDuplicates the record read in a data file: the record found in memory is added into the data file (the query or the view).
HDuplicatesHDuplicates is kept for backward compatibility (this function will still be supported in the forthcoming version).
HEndNoDatabaseAccessRe-authorizes the access to one or more databases accessible by a connection.
HErrorReturns the number of the last error triggered by the HFSQL engine.
HErrorDuplicatesUsed to find out whether a duplicate error occurred.
HErrorInfoReturns a detailed information about the last error triggered by the HFSQL engine.
HErrorIntegrityAllows you to find out whether an integrity error occurred.
HErrorLockUsed to find out whether a lock error occurred.
HErrorModificationDuring a modification conflict, returns the value of a record item.
HErrorPasswordOnce a read or write function was run on a data file, this function allows you to find out whether an error caused by a wrong password occurred on this data file.
HErrorStatusModificationReturns the status of a record during a modification conflict.
HexaToBufferConverts a string representing bytes in hexadecimal into a binary buffer.
HexaToIntReturns the numeric value of an hexadecimal string.
HExecuteProcedureRuns a stored procedure.
HExecuteQueryDeclares a query created in the query editor to the HFSQL engine and runs this query.
HExecuteSQLQueryInitializes a query written in SQL language and declares this query to the HFSQL engine.
HExecuteViewRuns a view that was created beforehand (can be used to refresh the data of the view for example). This function is using the former mechanism of views
HExtractMemoExtracts the content of a binary memo item from a HFSQL file, from a query or from a HFSQL view into a physical file (on disk).
HFileExistAllows you to find out:
  • whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
  • whether a view or a query was defined.
HFilterDefines and enables a filter on a data file, a view or a query.
HFilterContainsDefines and enables a "Contains" filter on a data file, a view or a query.
HFilterIdenticalDefines and enables a filter used to find the exact value of a string item.
HFilterIncludedBetweenDefines and enables an "Included between" filter on a file, view or query.
HFilterStartsWithDefines and enables a "Start with" filter on a file, view or query.
HFirstPositions on the first record of a data file according to the specified search item.
HFlushForces the operating system of the computer where the data files are found to write the data onto the disk.
HForwardMoves several records forward from the current position in the data file, according to a specified item.
HFoundChecks whether the current record corresponds to the current filter or to the current search.
HFreeTransforms the crossed records (HCross) into deleted records.
HFreePositionDeletes a position saved by HSavePosition.
HFreeQueryFree the resources of a query (after the call to HExecuteQuery or HExecuteSQLQuery)
HGetCurrentPositionReturns the approximate position of the current record in the data file
HImportTextImports a Text file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile).
HIndexRebuilds the index of a data file (".NDX" file).
HIndexingInProgressIndicates that a reindex operation is currently performed on a HFSQL data file and returns the percentage of reindexing already performed.
HInfoDatabaseRightsAllows you to find out the rights granted to a user or to a group on a database.
HInfoFileReturns the characteristics of a file found on a HFSQL server.
HInfoFileRightsAllows you to find out the rights granted to a user or to a group on a HFSQL Client/Server data file.
HInfoGroupReturns information about the specified group of users.
HInfoItemThis function is kept for backward compatibility.
HInfoLockReturns information about the lock performed on a data file, on a record or on all the records found in a data file.
HInfoMemoReturns the characteristics of binary and text memos.
HInfoServerReturns the specified information about the server.
HInfoServerRightsAllows you to find out the rights granted to a user or to a group on a server.
HInfoUserUpdates the variables for user management with the information regarding the specified user.
HInfoViewReturns information about a materialized view.
HInfoViewRightsAllows you to find out the rights granted to a user or to a group on a SQL view or on a materialized view.
HiWordReturns the two high bytes of an integer.
HLastPositions on the last record of a data file according to a search item.
HLinkMemoUsed to associate a file with a binary memo item or to cancel the existing link between a file and a binary item.
HListConnectedUserLists the users currently connected to one or more files handled by a Client/Server connection.
HListConnectionReturns the list of connections currently described in the application.
HListDatabaseLists the Client/Server databases associated with a connection.
HListFileReturns the list of files:
  • found in the current analysis or in a specific analysis recognized by the HFSQL engine. The files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
  • available on a connection via a native access or via an OLE DB driver.
  • for a group of files defined in the data model editor.
HListGroupReturns the list of groups of users defined for a connection.
HListItemReturns the list of items:
  • found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
  • found in a Record type variable.
HListKeyReturns the list of keys found in a file (query or view) recognized by the HFSQL engine.
HListLinkReturns the list of links (Merise type) found in the current analysis or in a specific analysis.
HListTriggerReturns the list of triggers applied to one or more HFSQL data files.
HListUserReturns the list of users defined for a connection.
HLockFileLocks a data file and restricts the access to this data file for all the other sites or applications.
HLockRecNumLocks a record and restricts the access to this record for all the other applications.
HMergeViewCreates a HFSQL from two views created beforehand (HCreateView). This function is using the former mechanism of views.
HModeChanges the mode and the method for locking data files.
HModifyModifies the specified record or the record found in memory in the data file (query or view).
HModifyDatabaseRightsModifies the rights granted to a user or to a group for a HFSQL Client/Server database.
HModifyFileRightsModifies the rights granted to a user or to a group on a HFSQL Client/Server data file.
HModifyGroupModifies the group information according to the elements found in the corresponding variables for group management.
HModifyServerRightsModifies the rights granted to a user or to a group on a HFSQL server.
HModifyStructureUsed to update the structure of a HFSQL data file by performing an automatic data modification (also called data synchronization).
HModifyUserModifies the information about a user according to the elements found in the corresponding variables for user management.
HModifyViewRightsModifies the rights granted to a user or to a group on a SQL view or on a materialized view.
HNbRecReturns the number of records in a file, a query or a HFSQL view: active records, crossed records, deleted records, etc.
HNextPositions on the next record of a data file according to a search item.
HNoDatabaseAccessForbids all the accesses to a database or to all the databases.
HOnErrorCustomizes the management of HFSQL errors.
HOnServerCallCustomizes the management of message display on the client computer and the management of disconnection from a client computer.
HOpenOpens a data file.
HOpenAnalysisOpens an analysis in HFSQL Classic format.
HOpenConnectionEstablishes a connection to a specific database.
HourGlassTransforms the mouse cursor into an hourglass (and conversely).
In Android and iOS, displays an endless progress bar in a window.
HOutUsed to to find out whether the record on which we want to be positioned is located outside the data file, filter, view or query.
HPassDefines the password used to create or open a data file.
HPreviousPositions on the previous record found in a file according to a search item.
HPriorityUsed to find out and modify the priority of the calling application.
HReadReads a record in a file according to a given record number.
HReadFirstPositions on the first record of a file according to a search item.
HReadFirstLockHReadFirstLock is kept for backward compatibility only (this function will still be supported in the forthcoming version).
HReadFirstNoLockHReadFirstNoLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HReadLastPositions on the last file record according to a search item.
HReadLastLockHReadLastLock is kept for backward compatibility only (this function will still be supported in the forthcoming version).
HReadLastNoLockHReadLastNoLock is kept for backward compatibility (this function will still be available in the forthcoming version).
HReadLockHReadLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HReadNextPositions on the next record of a data file according to a search item.
HReadNextLockHReadNextLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HReadNextNoLockHReadNextNoLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HReadNoLockHReadNoLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HReadPreviousPositions on the previous file record according to a search item.
HReadPreviousLockHReadPreviousLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HReadPreviousNoLockHReadPreviousNoLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HReadSeekPositions on the first file record whose value for a specific item is greater than or equal to a sought value (generic search).
HReadSeekFirstPositions on the first file record whose value for a specific item is strictly equal to a sought value (exact-match search).
HReadSeekLastPositions on the last file record whose value for a specific item is less than or equal to a sought value (exact-match search).
HReadSeekLockHReadSeekLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HReadSeekNoLockHReadSeekNoLock is kept for backward compatibility (this function will still be supported in the forthcoming version).
HRecNumReturns:
  • the number of the current record in the HFSQL data file.
  • the number of the current record in the HFSQL view.
HReconnectPerforms a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified.
HRecordDateReturns the date and time of the last write operation performed on a record found in a HFSQL file (Classic or Client/Server).
HRecreateSubscriberReplicaRe-creates the description file of a subscriber replica (universal replication only) according to the information of the master replica (.RPM and .SYN files).
HRefreshViewAsks to recalculate the content of a materialized view.
HResetInitializes:
  • one or all the variables of the items found in a data file with their default values.
  • one or all the items of a Record variable with their default values.
HResetClientInitializes the structure for managing the Client computers (HClient structure).
HRestorePositionRestores the context of a file that was saved beforehand (HSavePosition): current record, filter, pointers.
HRetrieveItemReturns the content of an item found in the current record (in the data file, view, query, ...).
HRetrieveRecordReturns the content of the current record (in a file, a view or a query, ...).
HRplDeclareLinkDeclares a (1,1) (0,n) link between two tables.
HRplFilterProcedureDefines the WLanguage procedure that will be called whenever a replication operation is performed on a specific file.
HRplManageFileDefines the options used for the universal replication of a file:
  • the replication direction.
  • the management mode of conflicts.
HRplManageItemSpecifies the replication options for an item: the item can be replicated or not.
HRplPassDefines the passwords used to protect the movable replicas for the universal replication.
HSaveModifies the current record if it exists, otherwise adds a new record.
HSecurityEnables or disables the automatic security mechanism on one or more data files.
HSeekPositions on the first record of the data file whose value for a specific item is greater than or equal to a sought value (generic search by default).
HSeekFirstPositions on the first file record whose value for a specific item is greater than or equal to a sought value.
HSeekLastPositions on the last file record whose value for a specific item is less than or equal to a sought value.
HSendMessageToClientDisplays a message on the client computers.
HSetCacheAllows you to configure the management of caches in the HFSQL Client/Server engine.
HSetDuplicatesEnables or disables the management of duplicates on a unique key.
HSetIntegrityEnables or disables the management of an integrity constraint on a file link.
HSetMemoUsed to modify the management mode of memo items.
HSetPositionPositions on a record from the approximate position of one of its items.
HSetReplicationTemporarily disables (or re-enables) the replication.
HSetServerUsed to find out and modify some settings of the HFSQL Client/Server server.
HSimulateNetworkSimulates the operating mode of HFSQL Client/Server on an ADSL or 3G network.
HSLCreates a color from its hue, saturation and lightness.
HSortViewSorts a HFSQL view by creating an index on a view item. This function is using the former mechanism of views
HStatCalculatePerforms various statistical calculations on the keys of a data file.
HStatDateReturns the date of the last update for the index statistics.
HStateUsed to find out the status of a record.
HStatNbDuplicatesReturns the number of duplicates for a given key item.
HStatNbRecReturns the number of entries for a given key item.
HStatNbRecRangeReturns an estimate regarding the number of entries for a given key item in a given interval of values.
HStatTimeReturns the time of the last update for the index statistics.
HSubstDirAssociates the data directory specified in the analysis with a directory found on disk.
HSubstNameHSubstName is kept for backward compatibility (this function will still be supported in the forthcoming version).
HSynchronizeReplicaSynchronizes the master replica and the subscriber replica: the operations performed on one of the replicas are transferred into the other replica.
HTMLNavigateStarts a navigation operation in an HTML control.
HTMLToRGBConverts the HTML color into RGB color.
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.
HToFileCopies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password-protected.
HTransactionCancelIf a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
HTransactionEndValidates the current transaction:
  • the modifications performed on the data file since the beginning of transaction (HTransactionStart) are validated.
  • the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
  • the records locked in read-only by the transaction are unlocked.
HTransactionFreeTransforms all the records "in transaction" into "Normal" records if these records do not belong to a transaction currently in progress.
HTransactionInterruptedUsed to find out whether a transaction was interrupted (the transaction was neither validated nor canceled).
HTransactionIsolationConfigures the isolation mode of transactions for a connection to a HFSQL server.
HTransactionListReturns the list of current or interrupted transactions found on the server for the specified connection.
HTransactionStartStarts a transaction on the data files (HFSQL or accessed via Native Access) and creates the file of transactions.
HTTPAddFileAdds a file into the HTTP form.
HTTPAddParameterAdds a parameter into an HTTP form.
HTTPCancelFormCancels the declaration of an HTTP form and frees all its resources.
HTTPCreateFormCreates an HTTP form.
HTTPDestinationIndicates the backup file for the result of the next HTTP request, run in the same thread.
HTTPGetResultRetrieves the result or the header of the last HTTP request run.
HTTPProgressBarDisplays a progress bar when:
  • receiving the response to an HTTP request.
  • sending an HTTP form (HTTPSendForm) or an HTTP query.
HTTPRequestStarts an HTTP request on a server.
HTTPResetFormClears an HTTP form that is currently edited.
HTTPSendFormSends an HTTP form.
HUnlockFileUnlocks the records of a data file:
  • locked by HLockFile.
  • individually locked by a locking read function.
HUnlockRecNumUnlocks a record that was previously locked by:
  • HLockRecNum,
  • a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
HVersionUsed to find out:
  • whether the content of a file was modified
  • whether the content of a file used by a query was modified.
HWriteWrites a record into a data file without updating the indexes corresponding to all the keys used in the file.
iBorderPrints a border at the specified coordinates.
iChangeSubReportSourceModifies by programming the report associated with a sub-report in a composite report.
iCloseReportStops printing the current report immediately.
iColumnEndForces a column break in a multicolumn report.
iColumnNumReturns the column number of the current column in a multi-column report.
iCreateFontCreates a new print font.
iCurrentFileReturns the name of the file currently generated.
iDestinationConfigures the destination of the print.
iEllipsePrints an ellipse (in a rectangle).
iEndPrintingSignals the end of the document to print and actually starts printing the data stored in the printer spooler via the following functions: iPrint, iPrintImage, iNewLine, etc.
iEndReportForces the report print to stop.
iFontSelects the default font.
iForceComplementForces the printing of a Body Complement block.
iHLinePrints an horizontal line at the specified coordinates.
iImageHeightCalculates the height of the image to print (in millimeters).
iImageWidthCalculates the width of the image to print (in millimeters).
iInitReportQueryInitializes the query linked to the report (for a query with parameters).
iInitReportQueryConnectionInitializes the query linked to the report.
iInitSubReportInitializes the parameters of a sub-report of a composite report.
iLastFileReturns
  • the full name of the last file generated during the print (PDF, RTF, text, ...).
  • the list of created duplicate files
iLinePrints a line at the specified coordinates.
iListNestedReportsReturns
  • the list of nested reports currently printed (reports run by iPrintReport in one of the processes of the report currently printed)
  • the list of sequenced reports currently printed (iSequenceAdd).
iMarginDefines the "logical" print margins.
iMMToPicaConverts the coordinates of a point (expressed in millimeters) into system coordinates.
In64bitModeIndicates whether the code is run in 64-bit mode or not.
InAJAXModeSpecifies whether the code is run from:
InAndroidEmulatorModeIndicates whether the code is run in the Android emulator or not.
InAndroidModeIndicates whether the code is run in Android mode.
InAndroidSimulatorModeIndicates whether the code is run in the Android simulator.
InAppleWatchEmulatorModeIndicates whether the code is run in the Apple Watch emulator.
InAppleWatchModeIndicates whether the code currently run is in Apple Watch mode.
InAppleWatchSimulatorModeIndicates whether the code is run in the Apple Watch simulator.
InAutomaticTestModeEnables you to find out whether an automatic test is currently run or not.
InAWPModeUsed to find out whether the page currently run is an AWP page.
InComponentModeIndicates whether the code is run:
  • from a WINDEV application, a WEBDEV site or a PHP page.
  • from a component.
InDelayedProcedureModeIndicates whether the code is run from a delayed procedure or from a scheduled task on the WEBDEV application server.
iNestedHeaderFooterPrints (or not) the page headers and footers of the nested report.
iNewLinePrints a line (in Windows standard, with a rounded end) at the specified coordinates.
InFactoryModeIndicates whether the code is run by an action plan of the software factory.
InfoBuildDisplays a custom message in a system information window.
IniOSEmulatorModeIndicates whether the code is run in the iOS emulator (iPhone, iPad).
IniOSModeIndicates whether the code currently run is in iOS mode (iPhone, iPad).
IniOSSimulatorModeIndicates whether the code is run in the iOS simulator (iPhone, iPad).
INIReadReads the content of a INI file (or the content of a file structured like a .INI file).
InitParameterInitializes the management of persistent values.
InitRandomInitializes the generator of random numbers.
INIWriteWrites a specific value into a INI file (or into a file structured like an .INI file).
InJavaModeIndicates whether the code is run in Java.
InLinuxModeIndicates whether the code is run in Linux mode or not.
InPHPModeIndicates whether the code is run in PHP.
InPHPSimulatorModeIndicates whether the code is run in PHP simulator mode.
InPocketModeIndicates whether the code is run:
  • from a WINDEV Mobile application.
  • from a standard WINDEV application, from a WEBDEV site or from a PHP application.
Function kept for backward compatibility.
InPocketSimulatorModeIndicates whether the code is run in the Pocket simulator.
InPrelaunchedSessionModeUsed to find out whether the site is started in "pre-launched session" mode of WEBDEV.
InReportsAndQueriesModeIndicates whether the code is run during the test of a report or query in Reports & Queries.
InsertInserts an element at a given position:
  • into a one-dimensional WLanguage array.
  • into an associative array.
  • into an advanced array property (array of gglCalendar events, ...).
  • into a WLanguage list.
InsertColumnInserts a column at a given position into an advanced two-dimensional array property (xlsDocument, …).
InsertLineInserts a row at a given position:
  • into a two-dimensional WLanguage array.
  • into an advanced two-dimensional array property (xlsDocument, ...).
InServiceModeIndicates whether the code is run in a service.
InSimulatorModeUsed to find out whether the application is started in "simulator test mode" from WINDEV Mobile.
InStoredProcedureModeIndicates whether the code is run on a HFSQL server.
IntegerPartReturns the integer part of a number.
IntegerToDateTransforms an integer into a date in YYYYMMDD format.
IntegerToDayReturns the day of the week corresponding to the specified date (this date is an integer).
IntegerToDayInAlphaSpells out the day of the week corresponding to the specified date (this date is an integer).
IntegerToMonthInAlphaReturns and spells out the month corresponding to the specified date (this date is an integer).
IntegerToTimeTransforms an integer into a time in HHMMSSCC format.
IntegerToWeekNumberReturns the week number in the year corresponding to the specified date (this date is an integer).
InternetConnectedDefines whether an Internet connection is enabled on the current computer. In mobile, you can also be notified when the status of the Internet connection changes.
InTestModeIndicates whether the application or the site is started:
  • from the WINDEV or WEBDEV editor,
  • from the executable or the browser.
  • WebDev - Server code from the WEBDEVadministrator.
InTSEModeIndicates whether the code is run:
  • from a computer in TSE mode or from a remote desktop
  • from a computer directly.
IntToHexaReturns the hexadecimal string of a numeric value.
InUMCModeIndicates whether the code is run from a code written in a user macro-code.
InUniversalWindowsAppModeIndicates whether the code is run in Universal Windows 10 App mode.
InUniversalWindowsAppSimulatorModeIndicates whether the code is run in the simulator for the applications in Universal Windows 10 App mode.
InWebModeIndicates whether the current process is run:
  • from a WINDEV executable.
  • from the WEBDEV runtime engine (AWP).
InWebserviceModeUsed to find out whether the execution is in progress in the AWWS engine.
InWidgetModeIdentifies whether the code is run in Android Widget mode.
InWindowsMobileModeIndicates whether the code is run:
  • from a Windows Mobile application.
  • from a standard WINDEV application, from a WEBDEV site or from a PHP application.
InWindowsModeIndicates whether the code is run in Windows mode or not.
InWindowsStoreAppModeIndicates whether the code is run in Windows Store apps mode.
Function kept for backward compatibility.
iPageEndForces the move to the next page during the report print.
iPageHeightCalculates the height of the printable page (in millimeters) while taking the top or bottom margins into account.
iPageHeightLeftCalculates the available height (in millimeters) left on the current page, taking into account the defined margins (top or bottom).
iPageNumReturns or initializes the number of the page currently printed.
iPageWidthCalculates the width (in millimeters) of the printable page while taking the left or right margins into account.
iParameterRetrieves the configuration of the printer and configures the print.
iParameterPDFDefines the options of the generated PDF file.
iPicaToMMConverts the coordinates of a point (expressed in system coordinates) into millimeters.
iPrintSends the character string passed in parameter to the print buffer.
iPrintBarCodePrints a bar code (inside a rectangle).
iPrintBlockForces a report block to print.
iPrintBodyComplementForces a body complement block to print while specifying the height of the complement block.
iPrintImageSends the image file to print to the print buffer.
iPrintReportPrints a report created with the report editor.
iPrintWordSends the character string passed in parameter to the print "buffer".
iPrintZonePrints a text in a rectangular area.
iReportPrintingStatusReturns the status of the current print.
iResetRe-initializes the print settings (margins, font, paper format, orientation, ...) stored in the print library.
iResetNbPagesReinitializes the current number of pages, used in the preset controls such as "Number of pages" and "Page number and number of pages".
iRoundBorderPrints a border with rounded outlines at the specified coordinates.
iSequencingAddAdds a report into a sequence of reports.
iSequencingPrintPrints a sequence of reports.
IsEvenIdentifies an even number.
iSkipLineForces one or more line break.
iSkipPageGenerates a page break: the corresponding code is sent to the printer queue.
IsNumericEnables you to find out whether a variable or a control is:
  • a numeric (integer, real, currency or numeric).
  • a string that can be converted into numeric.
IsOddIdentifies an odd number.
iSubstBlockSubstitutes a report block for another block while the report is printed.
iTextHeightCalculates the height of the font for the text to print (en millimeters).
iTextWidthCalculates the width (in millimeters) of the text to print, according to the specified font.
iVLinePrints a vertical line at the specified coordinates.
iXPosUsed to manage the horizontal position (X coordinate) of the print cursor in the page.
iYPosUsed to manage the vertical position (Y coordinate) of the print cursor in the page.
iZoneHeightCalculates the necessary height of a fixed-width area in order for the entire text using the current font to be printed in this area.
LanguageToCharsetReturns the character set corresponding to a language.
LanguageToNameReturns the name of a language.
LanguageToNationReturns the nation corresponding to a language.
LastDayOfMonthReturns the date of the last day for the specified month.
LastDayOfWeekReturns the date of the last day of the week corresponding to a given date.
LeftExtracts the left part (which means the first characters) from a character string or from a buffer.
LengthReturns:
  • the size of a character string, which means the number of characters found in the character string (including the space and binary 0 characters).
  • the size of a buffer, which means the number of bytes found in the buffer.
LengthToStringConverts a length expressed in bytes into a character string formatted in kilobytes, megabytes or terabytes.
LineToPositionReturns the position of the first character of a line in a block of text.
ListAddAdds an element into a memory List Box control, a memory ListView control, a Carousel control or a memory Combo Box control
ListCountReturns the number of elements found in a List Box, ListView or Combo Box control.
ListDeleteDeletes an element from a memory list box, a listview or a combo box.
ListDeleteAllDeletes all the elements from a memory list box, a listview or a combo box.
ListDisplayRefreshes the display of a browsing List Box, ListView or Combo Box control.
ListInfoRetrieves the characteristics of a list: types of elements and number of elements.
ListInsertInserts an element to a memory List box control, a memory Listview control or a memory Combo box control.
ListModifyModifies an element in a memory list box (standard list box or listview) or in a memory combo box.
ListPositionDisplays a list box (or a listview) control from a specified element or returns the subscript of the first element displayed in a list box control (if the scrollbar was used).
ListSeekSeeks an element in a List Box control (standard list box or listview) or in a Combo Box control (including the values described by gLink).
ListSelectReturns the subscript of the element selected in a list box, in a listview or in a combo box.
ListSelectCountReturns the number of elements selected in a list box, in a listview or in a combo box.
ListSelectMinusDeselects an element from a list box, a listview or a combo box.
ListSelectPlusSelects one or more elements in a List Box, ListView or Combo Box control.
ListSortSorts the elements found in a memory List Box, ListView or Combo Box control.
LnCalculates the Napierian logarithm (reverse of exponential) of a numeric value.
LoadErrorLoads in memory the file containing the error messages in the requested language.
LoadParameterReads a persistent value.
LogCalculates the decimal logarithm of a numeric value.
LooperAddAdds a row at the end of a Looper control.
LooperAddLineAdds a row at the end of a Looper control.
LooperCountReturns the number of rows found in a browsing or memory Looper control.
LooperDeleteDeletes a row from a browsing or memory Looper control.
LooperDeleteAllDeletes all the rows from a memory Looper control.
LooperDisplayRefreshes the display of a browsing looper from a given position: the modifications performed in the linked file are applied to the looper.
LooperInsertInserts a row into a browsing or memory Looper control.
LooperInsertLineInserts a row into a browsing or memory Looper control.
LooperModifyModifies the values of the attributes in a Looper control row (browsing or memory looper).
LooperModifyLineModifies the values of the attributes in a Looper control row (browsing or memory looper).
LooperMoveLineMoves a row or swaps two rows in a Looper control.
LooperPositionMoves the scrollbar of a memory Looper control to display a specific row or returns the subscript of the first row displayed in a memory Looper control.
LooperRefreshVisibleModifies or returns the visibility status of the refresh bar in a Looper control.
LooperSeekSeeks a value in an attribute of a Looper control.
LooperSeekAnywhereSeeks a value in all the attributes of a Looper control.
LooperSelectReturns the subscript of the element selected in a Looper control.
LooperSelectCountReturns the number of rows selected in a Looper control.
LooperSelectMinusDeselects a row in a Looper control.
LooperSelectPlusSelects a row in a Looper control.
LooperSortAllows you to:
  • Sort a Looper control according to one or more attributes.
  • Sort a Looper control on all its attributes.
  • Cancel a sort that was performed beforehand (while ignoring the sort).
LowerConverts a character string into lowercase characters according to the localization settings defined in Windows.
LoWordReturns the two low bytes of an integer.
MakeIntegerBuilds a 4-byte integer from two 2-byte integers.
MapAddItineraryAdds an itinerary onto a Map control.
MapAddMarkerAdds a new marker onto a map displayed in a Map control.
MapDeleteAllDeletes all the markers from a Map control.
MapDeleteItineraryDeletes an itinerary from a Map control.
MapDeleteMarkerDeletes a marker from a map displayed by a Map control
MapDisplayPositionCenters the map displayed in a Map control on a geographical position or on a specific location.
MapEndOfMoveStops following the move of the device in a Map control.
MapFollowMovementDisplays the current position of the device in a Map control and updates this position during its move.
MapGetPositionReturns the geographical position of the point located in the center of the map currently displayed in a Map control.
MapInfoPositionReturns the coordinates (in pixels) of the point corresponding to a geographical position (latitude and longitude).
MapInfoXYReturns the geographical position (latitude and longitude) corresponding to a point of a Map control.
MapItineraryDistanceCalculates the distance of an itinerary in a Map control.
MapLicenseBingIndicates the "Bing map" license key that will be used in the Map controls used in Universal Windows 10 App mode.
MapModifyMarkerModifies a marker displayed in a Map control.
MatAddAdds two matrices of same dimensions (same number of rows and same number of columns).
MatchRegularExpressionChecks whether a character string corresponds to a specific format and retrieves the different sub-strings that constitute the format.
MatCopyCreates the copy of a matrix.
MatCreateCreates a matrix containing 0 row and 0 column.
MatDeleteDeletes an existing matrix.
MatDeterminantCalculates the determinant of a square matrix (the number of rows is equal to the number of columns).
MatErrorIdentifies the type of the last error caused by a Matxxx function (functions for managing the matrices).
MatExistChecks the existence of a matrix in memory.
MatFillInitializes all the elements found in a matrix of a given size.
MatFloatAddAdds a value to each matrix element.
MatFloatMultiplyMultiplies each matrix element by a value.
MatInvertReverses a square matrix.
MatMultiplyMultiplies two matrices.
MatNbColumnReturns the number of columns found in a matrix.
MatNbLineReturns the number of rows found in a matrix.
MatReadReads the value of a matrix element.
MatReadColumnReads the value of all the elements found in a matrix column.
MatReadLineReads the value of all elements found in a matrix row.
MatStackCompresses the memory footprint occupied by a matrix.
MatTransposeCalculates the transposed matrix.
MatWriteWrites an element into a matrix.
MaxReturns the greatest of the values passed in parameter.
MeanCalculates the mean of several elements:
  • elements found in an array,
  • numeric values, ...
MemAddAdds an element into a memory zone.
MemCountReturns the number of elements found in a memory zone.
MemCreateCreates a memory zone.
MemCurrentReturns the subscript of the current element.
MemDeleteDeletes an element from a memory zone.
MemDeleteAllClears and deletes a memory zone.
MemExistChecks the existence of a memory zone.
MemFirstPositions on the first element of a memory zone and returns the value of this first element.
MemFoundChecks whether the sought element was found.
MemKeyValReturns the value (added or modified by MemAdd or MemModify) of the current element in a memory zone.
MemLastPositions on the last element of a memory zone and returns the value of this element.
MemModifyModifies an element in a memory zone.
MemNextPositions on the next element of a memory zone and returns the value of this element.
MemoryToFileAutomatically initializes the memory value of the items for the current file record with the values of the members of a class or structure.
MemOutUsed to find out whether the browse performed on a memory zone is outside this memory zone.
MemPreviousPositions on the element found before the current element of a memory zone and returns the value of this element.
MemRetrieveRetrieves the return value of an element found in a memory zone.
MemSeekSeeks an element in a memory zone:
  • on the value added by MemAdd or on the value modified by MemModify,
  • on the return value.
MemSetPositionPositions the memory zone on an element.
MemSortSorts the elements found in a memory zone.
MessTranslateRetrieves a message found in the code of a program in the current language.
MiddleExtracts
  • a sub-string from a given position in a string.
  • a section from a given position in a buffer.
MinReturns the lowest of the values passed in parameter.
mlzAddLineAdds a new dynamic line into a multiline zone.
mlzDeleteDeletes a dynamic line from a multiline zone.
mlzDeleteAllDeletes all the dynamic lines from a multiline zone.
mlzInsertLineInserts a new dynamic line into a multiline zone.
MonthNumberInAlphaReturns the name of the month according to its number.
MoveUsed to:
  • move an element in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, ...). The other array elements are moved accordingly.
  • swap two elements in a one-dimensional WLanguage array or in an advanced array property (array of gglCalendar events, ...).
MoveColumnMoves or exchanges a column in a two-dimensional array property of advanced type (xlsDocument, …).
MoveLineUsed to:
  • move a row in a two-dimensional WLanguage array or in an advanced array property. The other array rows are moved accordingly.
  • swap two rows in a two-dimensional WLanguage array or in an advanced array property.
MultimediaBeginningPositions at the beginning of the multimedia file played in the Multimedia control.
MultimediaDurationReturns the size of the multimedia file currently played (in milliseconds) in the Multimedia control.
MultimediaEndPositions at the end of the multimedia file played in the Multimedia control.
MultimediaHeightReturns the height (in pixels) of the source image of the multimedia file played in the Multimedia control.
MultimediaOpenOpens a multimedia file in a Multimedia control.
MultimediaPausePauses a multimedia file played in a Multimedia control.
MultimediaPlayPlays a multimedia file in a Multimedia control.
MultimediaPositionReturns or modifies the current position of the multimedia file currently played in the Multimedia control.
MultimediaStatusIndicates the status of the multimedia file played in the Multimedia control.
MultimediaStopStops playing a multimedia file found in a Multimedia control.
MultimediaVolumeReturns or modifies the sound volume of the multimedia file played in a Multimedia control.
MultimediaWidthReturns the width (in pixels) of the source image of the multimedia file played in the Multimedia control.
MutexCreateExplicitly creates a mutex.
MutexDestroyExplicitly destroys a mutex.
MutexEndSignals that the thread frees the mutex.
MutexStartLocks the current thread while waiting for the mutex to be freed.
NationDefines or identifies the display language (captions, messages, ...) used for the windows, pages, reports and controls.
NationRightToLeftUsed to find out whether the current language is written from right to left.
NationToLanguageReturns the language corresponding to a nation.
NextTitleModifies the title of the next window to open.
NoAccentTransforms the accented characters found in a character string into non-accented characters.
NoCharacterReturns a character string without the specified characters found on the left and on the right.
NoLeftCharacterReturns a character string without the specified characters found on the left of the initial string.
NoRightCharacterReturns a character string without the specified characters found on the right of the initial string.
NoSpaceReturns a character string without the space characters
  • found on the right and on the left.
  • found inside the string.
NowReturns or modifies the system time (current time defined for the current computer).
NumberInWordsTransforms a number into a character string corresponding to the number "written in words".
NumToFinancialWritingChineseTransforms a numeric value (integer, real or currency) into a string in Chinese financial writing format.
NumToStringTransforms a numeric value (integer, real or currency) into a character string according to the specified format.
OKCancelDisplays a message in a standard dialog box that proposes "OK" and "Cancel" and returns the user's choice.
OpenChildOpens a non-modal child window.
OpenMobileWindowOpens a window in a mobile application.
OpenPopupMenuAutomatically opens a popup menu for the current control or window.
OrganizerAddAppointmentAdds a new appointment into an Organizer control.
OrganizerChangeModeModifies the time range displayed by an Organizer control (Day/Week/Month).
OrganizerDeleteAllDeletes all the appointments from an Organizer control.
OrganizerDeleteAppointmentDeletes an appointment from an Organizer control.
OrganizerListAppointmentReturns:
  • the list of appointments found between two dates in an Organizer control,
  • all the appointments found in an Organizer control,
  • a specific appointment (selected or hovered).
OrganizerModeReturns the display mode of an Organizer control: day, week, month, ...
OrganizerPositionDisplays an Organizer control from a specified date or returns the date of the first day (or the date of the last day) displayed in an Organizer control.
OrganizerTimeDisplayedDefines the time range displayed by the Organizer control in Day mode or in Week mode.
PageByPagePrint..PageByPagePrint is used to:
  • Ask a report to be printed page by page. Each page of the report will be sent separately to the printer spooler.
  • Find out the print mode of the report (page by page or all at once).
ParallelTaskCancelImmediately ends the execution of the current task: the task is flagged as ptsCanceled.
ParallelTaskConfigureModifies the parameters of parallel tasks.
ParallelTaskExecuteTriggers the execution of a parallel task.
ParallelTaskExecuteAfterIndicates a continuation parallel task that will be run when one of the specified parallel task is ended.
ParallelTaskExecuteAfterAllIndicates a continuation parallel task that will be run when all the tasks found in an array of parallel tasks are ended.
ParallelTaskExecuteAfterOneIndicates a continuation parallel task that will be run once the first task is ended in an array of parallel tasks.
ParallelTaskRequestCancelationRequests the cancelation of a parallel task.
ParallelTaskWaitWaits for the end of execution of a parallel task.
ParallelTaskWaitAllWaits for the end of execution of all the parallel tasks found in an array.
PhoneticReturns the phonetic corresponding to the string passed in parameter.
PhotoRunAppStarts the native camera application of the device in order to take a photo.
PopPops an element from a stack.
PositionFinds the position of a character string inside another character string.
PositionOccurrenceFinds the Xth position of a character string in a character string.
PositionToLineReturns the number of the line to which belongs a character identified by its position in a block of text.
PowerRaise a number to a power.
ProfilerEndStops "collecting data" for the performance profiler.
ProfilerStartStarts "collecting information" for the performance profiler.
ProjectInfoReturns specific information about the project currently run.
PropertyExistUsed to find out whether a property exists on a control or on a class instance.
PushPushes an element into a stack.
QueueInfoRetrieves the characteristics of a queue: types of elements and number of elements.
RandomReturns a random number.
RealToDateTimeConverts an 8-byte real into a date and time.
RepeatStringConcatenates N repetitions of the same character string or buffer.
ReplaceReplaces all the occurrences of a word found in a string by another word.
ReplicInfoReturns information about a replication.
ReplicInitializeInitializes or reinitializes a replication defined by the replication editor (ReplicEdit).
ReplicOpenOpens a replication in direct mode or with a replication server.
ReplicSynchronizeSynchronizes the data corresponding to a replication.
RequestUpdateUIRequests the execution of the "Request for refreshing the display" process of the window (or internal window).
ResetRe-initializes:
  • all the controls found in the current window or page (including the groups of controls, the supercontrols and the internal windows).
  • the controls found in a group of controls, a supercontrol, an internal window or an internal page.
ReverseReturns the complement to 255 for each character found in a character string.
RGBDescribes a color from its Red, Green and Blue components.
RGBBlueReturns the blue component of a RGB color.
RGBRedReturns the red component of a RGB color.
RGBToHTMLReturns the HTML color corresponding to the RGB color.
RightExtracts the right part (which means the last characters) from a character string or from a buffer.
RootReturns the root of a number.
RoundReturns the rounded value of a numeric value according to the specified number of decimal places.
RoundDownReturns the value of a numeric value rounded to the nearest lower integer.
RoundUpReturns the value of a numeric value rounded to the nearest greater integer.
rssBuildStringBuilds the RSS stream and returns the result (in XML format) in a character string.
rssInitializeLoads a RSS stream in memory.
rssSaveBuilds the RSS stream and saves the RSS stream in an XML file.
RTFToHTMLReturns the HTML string corresponding to the specified RTF string.
RTFToTextReturns the text without the formatting characteristics specific to the RTF format.
SaveParameterSaves a persistent value in the registry or in another file specified by InitParameter.
SchedulerAddAppointmentAdds a new appointment into a Scheduler control.
SchedulerAddResourceAdds a new resource into a Scheduler control.
SchedulerChangeModeModifies the period (which means the number of days) displayed by a Scheduler control.
SchedulerDeleteAllDeletes all the appointments and all the resources from a Scheduler control.
SchedulerDeleteAppointmentDeletes an appointment from a Scheduler control.
SchedulerDeleteResourceDeletes a resource from a Scheduler control.
SchedulerListAppointmentReturns:
  • the list of appointments found between two dates in a Scheduler control,
  • all the appointments found in a Scheduler control,
  • a specific appointment (selected or hovered).
SchedulerModeReturns the display mode of a Scheduler control: day, week, month, ...
SchedulerPositionDateTimeDisplays a Scheduler control from a specified date or returns the date of the first day (or last day) displayed in a Scheduler control.
SchedulerTimeDisplayedDefines the time range displayed by the Scheduler control in Day mode or in Week mode.
sComputeCrc16Checks a character string before and after transmission between WINDEV applications and WEBDEVsites.
sComputeCrc32Calculates the Cyclical Redundancy Check (CRC) of a buffer.
ScreenToFileAutomatically initializes:
  • the memory value of the items of a data file with the value of the controls found in the window or in the page. The items of the base data file linked to the window controls are automatically assigned with the values of the corresponding controls (even if these controls are grayed, inactive or invisible).
  • the value of the WLanguage variables with the value of the controls found in the window or in the page. The WLanguage variables linked to the window controls are automatically assigned with the values of the corresponding controls (event if these controls are grayed, inactive or invisible).
ScrollbarMaxPositionRetrieves the maximum position of one of the horizontal or vertical scrollbars found in a control of a WINDEV application.
ScrollbarPositionModifies or retrieves the position of one of the horizontal or vertical scrollbars found in a control of a WINDEV application.
SeekSeeks the subscript of an element in a WLanguage array.
SeekByProcedureSeeks an element in a one-dimensional array by using a comparison procedure.
SemaphoreCreateCreates a semaphore.
SemaphoreDestroyExplicitly destroys a semaphore.
SemaphoreEndAllows one or more threads to exit from the area protected by the semaphore.
SemaphoreStartLocks the current thread until the semaphore is opened (which means until a "free" spot becomes available in the protected section).
SensorDetectBeginningBumpsAllows you to be notified when bumps occur on the device on any one of its 3 axes.
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.
SensorDetectEndBumpsAllows you to be notified when bumps occur on the device on any one of its 3 axes.
SensorEndIndicates the end of the use of the sensor functions.
SensorGetOrientationRetrieves the current orientation of the device on one of its 3 axes.
SerializeTransforms the following elements into a specific format:
  • a structure (and its sub-elements),
  • a class (and its sub-elements),
  • an array (including the associative arrays),
  • a queue,
  • a stack,
  • a list box
SexagesimalToDecimalReturns the decimal angle corresponding to a sexagesimal angle.
ShellExecuteOpens a document in its associated application.
SinReturns the sine of an angle.
SIPVisibleUsed to:
  • find out whether the current keyboard is visible (enabled for the "Transcriber" keyboard).
  • make the keyboard visible (enabled for the "Transcriber" keyboard).
SMSResetRe-initializes all the variables of the SMS structure.
SMSRunAppStarts the native application for sending SMSs found on the device (Android or iPhone/iPad).
SOAPAddAttributeAdds an attribute to an automatic variable generated by the import of a Webservice.
SOAPAddHeaderAdds a header to the next SOAP function of a Webservice to run.
SOAPGetHeaderRetrieves a header in the SOAP message received further to a call to a Webservice.
SOAPPrepareBuilds the SOAP request for calling a function of a Webservice.
SortSorts a WLanguage array.
SoundPlays a sound in WAV format.
SpeechSynthesisInitializeInitializes the parameters of the speech synthesis for the current application.
SpeechSynthesisInProgressUsed to find out whether a read operation is in progress on the engine for speech synthesis.
SpeechSynthesisReadFileReads the content of the specified file by using the engine for speech synthesis found on the device.
SpeechSynthesisReadTextReads the specified text by using the engine for speech synthesis found on the device.
SpeechSynthesisStopStops all the current read operations on the engine for speech synthesis.
SQLAssociateAutomatically associates each column of the query result with a control or with a variable of the application.
SQLChangeConnectionModifies the current connection.
SQLCloseDeclares the end of the query execution and frees the memory resources allocated during the execution of the query.
SQLColRetrieves the content of the specified column from the result of the query, for the current line.
SQLColumnReturns the characteristics of all the columns (or items):
  • for a given table.
  • for a given query.
SQLColumnFormatReturns the different types of columns supported:
SQLConnectConnects the current application to a database that must be interrogated by SQL.
SQLConnectWSConnects the current application to a database that must be interrogated by SQL by using a WebService proxy (SOAP).
SQLDisconnectCloses the current connection and frees the memory used by the connection.
SQLExecNames and runs a SQL query.
SQLExecWDRRuns the SQL code of a query created in the query editor.
SQLFetchGoes to the next line (which means to the next record) of the query result.
SQLFirstPositions on the first line of the query result.
SQLGetColRetrieves the content of the specified column from the result of the query, for the current line.
SQLGetMemoRetrieves the content of a Memo column from the query result, for the current line.
SQLGetTextMemoRetrieves the content of a Text Memo column found in the query result, for the current line.
SQLInfoInitializes the different SQL variables with the information relative to the last query run.
SQLLastPositions on the last line of the query result.
SQLListSourceLists the data sources declared on a local site.
SQLListTableList all the tables that can be accessed by the connected database system.
SQLLockAllows you to lock:
  • The entire data table, in read and write mode. Its data cannot be accessed by other computers.
  • The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.
SQLModifyModifies the content of a line in the query result.
SQLNextPositions on the next line of the query result.
SQLPreviousPositions on the previous line of the query result.
SQLReqExistsChecks the existence of a query.
SQLSeekPositions on the specified result line of the query.
SQLTableTransfers the result of a query to a memory table (list box or combo box), with possibility of Partial Fetch (the result is retrieved by blocks of lines).
SQLTransactionUsed to start, validate or cancel a transaction:
  • on the files of a database opened by SQLConnect,
  • on the files of a database opened by a connection (OLE DB or Native Access) described in the data model editor or by HOpenConnection.
StackInfoRetrieves the characteristics of a stack: types of elements and number of elements.
StartShareOpens a popup allowing you to select the application that will be used to share a resource (text or document).
StatAverageCalculates the arithmetic, geometric or harmonic mean for a series of values.
StatAverageDeviationCalculates the average deviation of values in relation to their arithmetic mean.
StatCorrelationCalculates the coefficient of correlation between two series of values.
StatCovarianceCalculates the covariance between two series of values.
StatErrorReturns the error number for the last error caused by a Statxxx function (statistical functions).
StatMaxCalculates the maximum value for a series of values.
StatMinCalculates the minimum value for a series of values.
StatStandardDeviationCalculates the standard deviation for a series of values.
StatStandardDeviationPCalculates the standard deviation for a full series of values.
StatSumCalculates the sum for a series of values.
StatVarianceCalculates the variance for a series of values.
StatVariancePCalculates the variance for a full series of values.
StringBuildBuilds a character string according to an initial string and to parameters.
StringCompareCompares two strings character by character:
  • according to the sequence of ASCII characters.
  • according to the alphabetical order.
StringCountCalculates:
  • the number of occurrences of a specific character string (by respecting the search criteria) in another character string.
  • the number of occurrences of a set of strings found in an array.
StringDeleteDeletes:
  • all the occurrences of a sub-string inside a string.
  • a section of string inside a string. The part of string to remove is identified by its position and length.
StringEndsWithChecks whether a character string ends:
  • with a specific character string.
  • with one of the character strings found in a list.
StringFormatFormats a character string according to the selected options.
StringIncrementIncrements a number found at the beginning or at the end of a character string.
StringInsertInserts a string into another character string at a given position.
StringReverseReverses the characters of a string.
StringStartsWithChecks whether a character string starts:
  • with a specific character string.
  • with one of the character strings found in a list.
StringToArrayFills a one- or two-dimensional array of the specified type with the character string passed in parameter.
StringToDateTransforms a date in character string format into a date in YYYYMMDD format.
StringToDurationTransforms a duration in character string format into a duration that can be used by a Duration variable.
StringToTimeTransforms a time in character string format into a time in HHMMSSCC format, that can be used by a Time variable.
StringToUTF8Converts a string in ANSI or UNICODE format into a string in UTF8 format.
SumCalculates the sum of the array elements.
SwapLineUsed to swap two rows in a two-dimensional array or in an advanced array property.
SysColorIdentifies or modifies the color of a Windows element.
SysDateTimeReturns or modifies the system date (date and time of the day defined for the current computer).
SysDirReturns the path of a system directory.
SysIconBadgeReturns or modifies the value displayed in the badge associated with the icon of an iOS or Universal Windows 10 app application.
SysNationReturns the nation currently used by the system.
SysScreenOrientationUsed to find out and modify the orientation of the screen on the Mobile device.
SysThemeReturns the visual theme currently displayed on the device running Universal Windows 10 App.
TangentCalculates the tangent of an angle.
tapiDialerCallOpens the default telephony application (dialer) found on the phone and dials the specified number.
TextHeightCalculates the height (in pixels) of the text displayed in an edit control, in a Static control or in a Combo box 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.
TextToXMLConverts a character string in ANSI format into a character string in XML format.
TextWidthCalculates the width (in pixels) of the text displayed in an edit control, in a Combo Box control or in a Static control.
ThreadCurrentReturns the name of the thread currently run.
ThreadEndEnds the execution of the current thread.
ThreadExecuteStarts the execution of a secondary thread.
ThreadModeChanges the management mode of threads.
ThreadPausePauses the current thread during the specified duration.
ThreadSendSignalThe current thread sends a signal to the specified thread in order to unlock it.
ThreadStateReturns the current status of a thread.
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.
TileAddAdds a new tile customization for the current Windows Store Apps application
TileDeleteAllDeletes all the modifications made to the application tile.
TileDisplayBadgeDisplays a badge (numeric notification or image) on the tile of a Universal Windows 10 App application.
TimeDifferenceCalculates the difference between two times in hundredths of a second.
TimerSysPeriodically and automatically calls a WLanguage procedure.
TimeSysReturns or modifies the system time (current time defined for the current computer).
TimeToIntegerTransforms a time into an integer.
TimeToStringFormats the time passed in a parameter according to the specified format.
TimeValidChecks the validity of a time.
ToClipboardWrites text or image information into the system clipboard.
TodayReturns or modifies the system date (date of the day defined on the current computer).
TraceDisplays the requested information (content of a control for example) in a window opened in parallel of the current window.
TraceBuildDisplays a customizable message in the trace window opened in parallel of the current window.
TraceEndCloses the trace window if this window was opened or stops saving the trace information in a text file.
TraceStartOpens the trace window or saves the trace information in a text file.
TransferCopies a block of bytes or a fixed-length string from a memory address into another one.
TruncateTruncates the right part of a string or buffer.
TypeVarIdentifies the type of an expression, a variable (during a call to a procedure for example) or a control.
UncompleteDirRemoves the "/"' or "\"' character found at the end of a string.
UncompressDecompresses a memory block (buffer) that was compressed by Compress.
UncryptDecrypts a character string that was encrypted by Crypt.
UnicodeToAnsiConverts:
  • a character string in UNICODE format into a character string in ANSI format (Windows).
  • a buffer containing a character string in UNICODE format into a buffer containing a character string in ANSI format (Windows).
UpperConverts a character string into uppercase characters according to the localization settings defined in Windows.
URLDecodeDecodes an encoded URL (which means with characters in %xx format).
URLEncodeEncodes a URL with a sub-set of ASCII characters.
URLExtractPathReturns the different elements of a URL: protocol, user, password, domain, port, resource path, resource name, resource extension, request and fragment.
UTF8ToAnsiConverts a string in UTF8 format into a string in Ansi format.
UTF8ToStringConverts a string in UTF8 format into a string in ANSI or UNICODE format.
UTF8ToUnicodeConverts a string in UTF8 format into a Unicode string.
UUDecodeDecodes a character string in UUEncode format.
UUEncodeEncodes a character string according to the UUEncode algorithm.
ValReturns the numeric value of a character string.
VariableResetResets the variable to its initial value.
VariantConvertConverts the value stored in a Variant variable.
VariantToJSONConverts the content of a Variant variable to JSON format.
VibrationStopStops the vibrations of the device (even if they have been triggered by another application).
VibrationTriggerTriggers the vibrations of the device.
VideoStartAppStarts the native camera application of the device in order to record a video or to take a photo.
WarningDisplays a custom message in a system warning window.
WeekNumberReturns the week number in the year corresponding to the specified date (this date is a character string).
WeekToDateReturns the date of the Monday for the specified week and year.
WinChangeLayoutApplies a specific layout to a mobile window.
WinCurrentLayoutReturns the subscript of the current layout in the current window.
WinDevVersionReturns the version number of the wdxxxvm DLL.
WinInitializedAllows you to find out whether the "end of initialization" code was run for a window.
WinInputIdentifies the window containing the WLanguage code currently run.
WinSlidingVisibleDisplays or hides a sliding window (sliding menu).
WinStatusIdentifies or modifies the status of a window.
WithSpaceAdds or deletes the spaces found on the right of a text item when reading it.
WordOccurrenceReturns the number of words in a string.
WordToArrayFills an array with the words of a string.
XMLAddAttributeAdds an attribute into an XML document.
XMLAddChildAdds a child tag into an XML document.
XMLBuildStringRetrieves and formats the content of an XML document (created by XMLDocument and modified by the XML functions).
XMLCancelSearchCancels the search performed by XMLFind.
XMLChildPositions on the first child element of the current element.
XMLChildExistIndicates whether the current tag has child elements corresponding the sought type (tag, attribute, ...).
XMLCloseCloses an XML document created by XMLDocument.
XMLDataReturns the value of the current element (tag or XML attribute) or the value of one of its attributes.
XMLDeleteDeletes the current element (as well as the entire branch) from an XML document.
XMLDocumentCreates a new XML document.
XMLElementNameReturns the name of the current element (tag or attribute).
XMLElementTypeReturns the type of the current element (tag or attribute).
XMLExecuteXPathRuns an XPATH query
  • in an XML document.
  • in an xmlDocument variable.
XMLExtractDocumentCreates a new XML document from an existing XML document.
XMLExtractStringExtracts the content of a tag found in an XML document.
XMLFindPerforms a search in an XML document.
XMLFindNamespaceByNameFinds an XML namespace according to its XML node and in the parents of the node.
XMLFindNamespaceByURIFinds an XML namespace from its URI (Universal Resource Identifier) in a node and in the parents of this node.
XMLFirstPositions on the first element (tag or attribute) in the current tree level.
XMLFoundChecks whether the current element corresponds to the current browse or to the current search.
XMLInsertDocumentInserts the current XML tag found in an XML document into another XML document.
XMLInsertElementInserts an XML element (tag or attribute) into an XML document.
XMLLastPositions on the last element (tag or attribute) of the current tree level.
XMLModifyModifies the content of the current element found in the XML document.
XMLNamespaceReturns the prefix of the namespace associated with the current tag in an XML document.
XMLNamespaceURIReturns the URI of the namespace associated with the current tag in an XML document.
XMLNextPositions on the next element (tag or attribute).
XMLOpenLoads an XML document from a file, a URL or a string in an xmlDocument variable.
XMLOutUsed to find out whether the element (tag or attribute) on which we want to be positioned is outside the XML document.
XMLParentPositions on the parent element of the current element (tag or attribute).
XMLParentNameReturns the name of the parent tag for the current element (tag or attribute).
XMLPathReturns the current position in the document in XPATH format.
XMLPreviousPositions on the previous element (tag or attribute).
XMLReadReturns the value of an XML element or the value of the attribute of an XML element.
XMLRenameRenames the current element (tag or attribute) in an XML document.
XMLRestorePositionRestores the context of an XML document that was saved beforehand (XMLSavePosition).
XMLResultReturns the result of a calculation XPath query.
XMLRootPositions on the root tag of an XML document.
XMLSaveSaves an XML document in a file.
XMLSavePositionStores the current position in the XML document.
XMLToTextConverts a character string in XML format into a standard character string.
XMLValidDocumentValidates an XML document from an XSD schema.
XMLValidNodeValidates an XML node, its children and its attributes from its description in the XSD schema linked to the XML document.
XMLWriteCreates or modifies the value of an XML element or the value of the attribute of an XML element.
YesNoDisplays a message in a standard dialog box that proposes "Yes" and "No" and returns the user's choice.
zipAddDirectoryAdds all the files found in a directory and in its sub-directories into an archive and compresses them.
zipAddFileAdds a file (of any type) into an archive in CAB, ZIP, WDZ and 7z, TAR ou TGZ (TAR.GZ) format and compresses it.
zipAddFileListAdds a list of files (of any type) into an archive in ZIP, CAB, WDZ or 7z format and compresses it.
zipCloseCloses an archive.
zipCompressionLevelChanges the compression level used when creating an archive in ZIP format or in 7z format.
zipCreateCreates an archive.
zipCurrentFileReturns the name of the archived file currently handled by the functions for adding and extracting files.
zipDeleteAllDeletes all the files from an archive.
zipDeleteFileDeletes a file from an archive.
zipDeleteFileListDeletes a list of files from an archive.
zipExistUsed to find out whether an archive exists.
zipExtractAllExtracts all the files from an archive and decompresses them.
zipExtractFileExtracts a file from an archive and automatically decompresses it to a physical location or in memory.
zipExtractFileListExtracts and decompresses a list of files found in an archive to a physical location.
zipExtractPathReturns the path of a file found in the archive.
zipFindFileFinds a file in an archive (in CAB, ZIP, RAR, WDZ or 7z format).
zipInfoFileReturns the characteristics of a file found an archive:
  • The name of the file and its stored path.
  • The initial size of the file.
  • The compressed size of the file.
  • The date and time of file creation.
  • The date and time of file modification.
  • The date and time of file access.
  • The file attributes.
  • The encryption mode of the file.
zipListFileReturns the list of files found in an archive.
zipMsgErrorReturns the message associated with an error code on an archive.
zipNbFileReturns the number of files found in an archive (in CAB, RAR, ZIP, WDZ or 7z format).
zipOpenOpens an existing archive.
zipPasswordDefines the password used to add files into the specified archive and to extract files from the specified archive (RAR, ZIP and WDZ format).
Improved functions of WLanguage
Windows Mobile The following WLanguage functions have been improved:
ProfilerStartNew notation for generating the WPF file.
CompressNew parameter used to define the compression algorithm.
dPointNew syntax using the Point type.
dRectangle
  • Ability to use the Background and Border types in the function parameters.
  • New syntax using the Rectangle type to define the coordinates of the rectangle to draw.
dRectangleGradientNew syntaxes using the Rectangle type and the Background type.
FTPConnectConnection Type parameter: becomes an integer constant.
gAlignmentYou now have the ability to store the horizontal alignment or the vertical alignment of the previous element.
grMaskNew constant used to manage the formats of dates and times on axes.
HExecuteQueryNew constant used to manage the hourglass in case of lock.
HExecuteSQLQueryNew constant used to manage the hourglass in case of lock.
HSetServerNew constant to manage the maximum number of HFSQL tables not used by clients that are stored in cache (which means opened) on the server.
iPrintBarCodeNew constants used to print the Aztec and MaxiCode bar codes.
CriticalSectionStartNew syntax used to start a critical section on a variable.
CriticalSectionEndNew syntax used to end a critical section on a variable.
SysIconAddThe <Procedure> parameter can now correspond to a Procedure variable.
TableSeek
  • New search mode (contains)
  • Evolution of the search mode (switch from a boolean to an Integer constant).
TypeVarNew types of variables are taken into account.
zipAddFileNew parameter used to manage the progress bar.
zipAddFileListNew parameter used to manage the progress bar.
zipAddDirectoryNew parameter used to manage the progress bar.
zipSplitNew parameter used to manage the progress bar.
zipExtractFileNew parameter used to manage the progress bar.
zipExtractFileListNew parameter used to manage the progress bar.
zipExtractAllNew parameter used to manage the progress bar.
zipMergeNew parameter used to manage the progress bar.
zipDeleteFileListNew parameter used to manage the progress bar.
LooperSeek
  • New search mode (contains)
  • Evolution of the search mode (switch from a boolean to an Integer constant).
LooperDeleteNew parameter used to add an animation during the deletion.
AndroidAndroid Widget The following functions have been improved in this version:
AddSupports the List variables.
MapAddItineraryNew constant used to manage the non-optimized car itineraries.
BCCaptureManagement of Aztec and PDF417 bar codes.
ExeInfoNew constants used to find out whether the application was started by the management of position tracking.
FTPConnectConnection Type parameter: becomes an integer constant.
HTransactionCancelThe syntaxes that use a connection name are now available.
HTransactionStartThe syntaxes that use a connection name are now available.
HTransactionEndThe syntaxes that use a connection name are now available.
InsertSupports the List variables.
PhotoRunAppNew syntax taking a procedure name in parameter.
DeleteSupports the List variables.
DeleteAllSupports the List, Stack and Queue variables.
SpeechSynthesisReadFileThe result of the function is a boolean.
SpeechSynthesisReadTextThe result of the function is a boolean.
TableSeek
  • New search mode (contains)
  • Evolution of the search mode (switch from a boolean to an Integer constant).
VideoStartAppNew syntax taking a procedure name in parameter.
LooperSeek
  • New search mode (contains)
  • Evolution of the search mode (switch from a boolean to an Integer constant).
LooperDeleteNew parameter used to add an animation during the deletion.
iPhone/iPad The following WLanguage functions have been improved:
MapAddItinerary
  • New constant used to manage the non-optimized car itineraries.
  • Ability to define a manual itinerary.
dPointNew syntax using the Point type.
dRectangle
  • Ability to use the Background and Border types in the function parameters.
  • New syntax using the Rectangle type to define the coordinates of the rectangle to draw.
dRectangleGradientNew syntaxes using the Rectangle type and the Background type.
ExeInfoNew constants used to find out whether the application was started by the management of position tracking.
FTPConnect
  • Connection Type parameter: becomes an integer constant.
  • New constant used to manage the extended passive connection (EPSV mode).
GPSFollowMovementAbility to continue the geo-localization when the application is available in background or when the device is in stand-by mode.
grTooltipNew constant used to manage the Heatmap charts.
grCreateNew constants used to manage the Heatmap charts.
grMaskNew constant used to manage the formats of dates and times on axes.
grParameterNew constants used to manage the colors in the Heatmap charts.
grTypeNew constants used to manage the Heatmap charts.
HExecuteQueryNew constant used to manage the hourglass in case of lock.
HExecuteSQLQueryNew constant used to manage the hourglass in case of lock.
HSetServerNew constant to manage the maximum number of HFSQL tables not used by clients that are stored in cache (which means opened) on the server.
iPrintBarCodeNew constants used to print the Aztec and MaxiCode bar codes.
PhotoRunAppNew syntax taking a procedure name in parameter.
CriticalSectionStartNew syntax used to start a critical section on a variable.
CriticalSectionEndNew syntax used to end a critical section on a variable.
TableSeek
  • New search mode (contains)
  • Evolution of the search mode (switch from a boolean to an Integer constant).
TypeVarNew types of variables are taken into account.
VideoStartAppNew syntax taking a procedure name in parameter.
zipAddFile
  • Support for TAR and TGZ (TAR.GZ) formats
  • New parameter used to manage the progress bar.
zipAddFileList
  • Support for TAR and TGZ (TAR.GZ) formats
  • New parameter used to manage the progress bar.
zipAddDirectory
  • Support for TAR and TGZ (TAR.GZ) formats
  • New parameter used to manage the progress bar.
zipFindFileSupport for TAR and TGZ (TAR.GZ) formats
zipCreateSupport for TAR and TGZ (TAR.GZ) formats
zipSplitNew parameter used to manage the progress bar.
zipExistSupport for TAR and TGZ (TAR.GZ) formats
zipExtractPathSupport for TAR and TGZ (TAR.GZ) formats
zipExtractFile
  • Support for TAR and TGZ (TAR.GZ) formats
  • New parameter used to manage the progress bar.
zipExtractFileList
  • Support for TAR and TGZ (TAR.GZ) formats
  • New parameter used to manage the progress bar.
zipExtractAll
  • Support for TAR and TGZ (TAR.GZ) formats
  • New parameter used to manage the progress bar.
zipCloseSupport for TAR and TGZ (TAR.GZ) formats
zipCurrentFileSupport for TAR and TGZ (TAR.GZ) formats
zipInfoFileSupport for TAR and TGZ (TAR.GZ) formats
zipListFileSupport for TAR and TGZ (TAR.GZ) formats
zipMsgErrorSupport for TAR and TGZ (TAR.GZ) formats
zipNbFileSupport for TAR and TGZ (TAR.GZ) formats
zipNbPartSupport for TAR and TGZ (TAR.GZ) formats
zipOpenSupport for TAR and TGZ (TAR.GZ) formats
zipMergeNew parameter used to manage the progress bar.
zipDeleteFileListNew parameter used to manage the progress bar.
zipFileSizeSupport for TAR and TGZ (TAR.GZ) formats.
zipSizeSupport for TAR and TGZ (TAR.GZ) formats.
LooperSeek
  • New search mode (contains)
  • Evolution of the search mode (switch from a boolean to an Integer constant).
LooperDeleteNew parameter used to add an animation during the deletion.
New WLanguage properties
Windows Mobile The new WLanguage properties for the Windows Mobile applications are as follows:
AutomaticTextColor..AutomaticTextColor is used to find out and modify the color that will be used for all the captions of the elements that use the "automatic" color.
CalculatedDefaultItem..CalculatedDefaultItem is used to:
  • Find out the SQL expression defining the default value of an item. This item was defined in the data model editor or by programming.
  • Define the SQL expression returning the default value of a item (when the item is described by programming).
CalculatedItemExpression....CalculatedItemExpression is used to:
  • Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or by programming.
  • Define the SQL expression that gives the value of a calculated item (when describing the item by programming).
PersistedCalculatedItem..PersistedCalculatedItem is used to:
  • Find out whether the value of a calculated item is stored in the data file. This item was defined in the data model editor or by programming.
  • Define whether the value of a calculated item is stored in the data file (when describing the item by programming).
TimestampType..TimestampType is used to:
  • Find out the type of timestamp for an item. This item was defined in the data model editor or by programming.
  • Define the type of timestamp for a Date, Time or DateTime item (when describing the item by programming).
TimestampUTC....TimestampUTC is used to:
  • Find out whether a timestamp item will use a UTC time or a local time. This item was defined in the data model editor or by programming.
  • Define whether a timestamp item will use a UTC time or a local time (when describing the item by programming).
TransparencyMode..TransparencyMode is used to find out and modify the transparency mode of an image.
Android The new WLanguage properties for the Android applications are as follows:
AdditionCompleted..AdditionCompleted is used to find out and modify the mode for adding an element into a queue, a list or a stack.
AllowActionBarHiding..AllowActionBarHiding is used to automatically hide the Action Bar.
CheckSpell..CheckSpell is used to enable or disable the automatic spelling checker.
DeleteButton..DeleteButton is used to find out and modify the presence and position of a delete button in a Text edit control.
DirectInputAPT..DirectInputAPT is used to find out and specify whether a user can directly modify the title of an appointment in an Organizer or Scheduler control.
EndDate..EndDate is used to find out and modify the end date of the period selected
  • in a Calendar control,
  • in an Organizer control.
  • in a Scheduler control
EndTotalRange..EndTotalRange is used to:
  • find out and modify the last displayable date or time in a Scheduler control or in a TimeLine control.
  • modify the last displayable time in a TimeLine control.
EndVisibleRange..EndVisibleRange is used to:
  • find out and modify the last visible date or time in a Scheduler control or in a TimeLine control.
  • modify the last visible time in a TimeLine control.
GranularityDuration..GranularityDuration allows you to find out and modify the size of the grid used to resize:
  • the appointments of an Organizer control.
  • the appointments of a Scheduler control.
  • the events of a TimeLine control.
  • the tasks found in a Gantt Chart column.
GranularityMovement..GranularityMovement is used to find out and modify the size of the grid used to move:
  • the appointments of an Organizer control.
  • the appointments of a Scheduler control.
  • the events of a TimeLine control.
  • the tasks found in a Gantt Chart column.
MaskTitleDate..MaskTitleDate is used to find out and modify the mask used for the title of the day columns in an Organizer control or in a Scheduler control.
MaskTitleTime..MaskTitleTime is used to find out and modify the mask used for the title of time columns:
  • in an Organizer control.
  • in a Scheduler control.
  • in a TimeLine control.
MovementAPT..MovementAPT is used to find out and specify whether the user can move an appointment in a Scheduler control or in an Organizer control.
NbDayDisplayed..NbDayDisplayed is used to find out and modify the number of days displayed in an Organizer control or in a Scheduler control.
NbPendingThread..NbPendingThread is used to find the number of pending threads in a queue or in a stack.
Num1stDayOfTheWeek..Num1stDayOfTheWeek is used to find out and modify the 1st day of the week displayed in:
  • a Calendar control.
  • an Organizer control.
  • a Scheduler control
  • an edit control in Date format with Calendar
Opacity..Opacity is used to find out and define the percentage of opacity for a window or for the controls found in a window or in a page.
ParallaxRateHeight..ParallaxRateHeight is used to find out and specify the speed at which a control is reduced when the scrollbar found in the window (or in the internal window) moves.
ParallaxRateY..ParallaxRateY is used to find out and specify the speed at which a control moves when the scrollbar found in the window (or in the internal window) moves.
PeriodSelection..PeriodSelection is used to find out and indicate whether the user can select a period in a Scheduler control or in an Organizer control.
Resource..Resource is used to:
  • find out the resources visible in a Scheduler control.
  • find out the resource of the Scheduler control corresponding to the specified subscript.
ResourceHeight..ResourceHeight is used to find out and modify the height of the resources in a Scheduler control where the resources are displayed in row.
SearchValue..SearchValue is used to find out and modify the value of the search control in an Action Bar.
StartDate..StartDate is used to find out and modify the start date of the period selected:
  • in a Calendar control
  • in an Organizer control.
  • in a Scheduler control
StartTotalRange..StartTotalRange is used to:
  • find out and modify the first displayable date or time in a Scheduler control or in a TimeLine control.
  • modify the first displayable time in a TimeLine control.
StartVisibleRange..StartVisibleRange is used to:
  • find out and modify the first visible date or time in a Scheduler control or in a TimeLine control.
  • modify the first visible time in a TimeLine control.
SwipeEnabled..SwipeEnabled enables or disables the management of the swipe gesture by the user:
  • on an Internal Window control.
  • on a row in a Looper control.
WorkingHourEnd..WorkingHourEnd is used to find out and modify the end time of the working hours used:
  • by an Organizer control.
  • by a Scheduler control.
  • by a Gantt Chart column (in a Table or TreeView Table control).
WorkingHourStart..WorkingHourStart is used to find out and modify the start time of the working hours used:
  • by an Organizer control.
  • by a Scheduler control.
  • by a Gantt Chart column (in a Table or TreeView Table control).
iPhone/iPad The new WLanguage properties for iPhone/iPad applications are as follows:
AllowActionBarHiding..AllowActionBarHiding is used to automatically hide the Action Bar.
AutomaticTextColor..AutomaticTextColor is used to find out and modify the color that will be used for all the captions of the elements that use the "automatic" color.
CalculatedDefaultItem..CalculatedDefaultItem is used to:
  • Find out the SQL expression defining the default value of an item. This item was defined in the data model editor or by programming.
  • Define the SQL expression returning the default value of a item (when the item is described by programming).
CalculatedItemExpression....CalculatedItemExpression is used to:
  • Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or by programming.
  • Define the SQL expression that gives the value of a calculated item (when describing the item by programming).
DeleteButton..DeleteButton is used to find out and modify the presence and position of a delete button in a Text edit control.
DirectInputAPT..DirectInputAPT is used to find out and specify whether a user can directly modify the title of an appointment in an Organizer or Scheduler control.
EndDate..EndDate is used to find out and modify the end date of the period selected
  • in a Calendar control,
  • in an Organizer control.
  • in a Scheduler control
GranularityDuration..GranularityDuration allows you to find out and modify the size of the grid used to resize:
  • the appointments of an Organizer control.
  • the appointments of a Scheduler control.
  • the events of a TimeLine control.
  • the tasks found in a Gantt Chart column.
GranularityMovement..GranularityMovement is used to find out and modify the size of the grid used to move:
  • the appointments of an Organizer control.
  • the appointments of a Scheduler control.
  • the events of a TimeLine control.
  • the tasks found in a Gantt Chart column.
MaskTitleDate..MaskTitleDate is used to find out and modify the mask used for the title of the day columns in an Organizer control or in a Scheduler control.
MaskTitleTime..MaskTitleTime is used to find out and modify the mask used for the title of time columns:
  • in an Organizer control.
  • in a Scheduler control.
  • in a TimeLine control.
MovementAPT..MovementAPT is used to find out and specify whether the user can move an appointment in a Scheduler control or in an Organizer control.
NbDayDisplayed..NbDayDisplayed is used to find out and modify the number of days displayed in an Organizer control or in a Scheduler control.
Num1stDayOfTheWeek..Num1stDayOfTheWeek is used to find out and modify the 1st day of the week displayed in:
  • a Calendar control.
  • an Organizer control.
  • a Scheduler control
  • an edit control in Date format with Calendar
Opacity..Opacity is used to find out and define the percentage of opacity for a window or for the controls found in a window or in a page.
ParallaxRateHeight..ParallaxRateHeight is used to find out and specify the speed at which a control is reduced when the scrollbar found in the window (or in the internal window) moves.
ParallaxRateY..ParallaxRateY is used to find out and specify the speed at which a control moves when the scrollbar found in the window (or in the internal window) moves.
PeriodSelection..PeriodSelection is used to find out and indicate whether the user can select a period in a Scheduler control or in an Organizer control.
PersistedCalculatedItem..PersistedCalculatedItem is used to:
  • Find out whether the value of a calculated item is stored in the data file. This item was defined in the data model editor or by programming.
  • Define whether the value of a calculated item is stored in the data file (when describing the item by programming).
Resource..Resource is used to:
  • find out the resources visible in a Scheduler control.
  • find out the resource of the Scheduler control corresponding to the specified subscript.
ResourceHeight..ResourceHeight is used to find out and modify the height of the resources in a Scheduler control where the resources are displayed in row.
ScreenCastAllowed..ScreenCastAllowed is used to:
  • find out whether the use can move the display of the Multimedia control onto an external device (compatible with Air Play),
  • enable (or not) the ability to move the display of the Multimedia control onto an external device (compatible with Air Play).
ScreenCastInProgress..ScreenCastInProgress is used to find out whether the video played in a Multimedia control is currently played on an external device (compatible with Air Play).
SearchValue..SearchValue is used to find out and modify the value of the search control in an Action Bar.
SelectedResource..SelectedResource returns the name of the resource corresponding to the selection made by the user in a Scheduler control.
StartDate..StartDate is used to find out and modify the start date of the period selected:
  • in a Calendar control
  • in an Organizer control.
  • in a Scheduler control
SwipeEnabled..SwipeEnabled enables or disables the management of the swipe gesture by the user:
  • on an Internal Window control.
  • on a row in a Looper control.
TimestampType..TimestampType is used to:
  • Find out the type of timestamp for an item. This item was defined in the data model editor or by programming.
  • Define the type of timestamp for a Date, Time or DateTime item (when describing the item by programming).
TimestampUTC....TimestampUTC is used to:
  • Find out whether a timestamp item will use a UTC time or a local time. This item was defined in the data model editor or by programming.
  • Define whether a timestamp item will use a UTC time or a local time (when describing the item by programming).
WorkingHourEnd..WorkingHourEnd is used to find out and modify the end time of the working hours used:
  • by an Organizer control.
  • by a Scheduler control.
  • by a Gantt Chart column (in a Table or TreeView Table control).
WorkingHourStart..WorkingHourStart is used to find out and modify the start time of the working hours used:
  • by an Organizer control.
  • by a Scheduler control.
  • by a Gantt Chart column (in a Table or TreeView Table control).
Apple Watch The new WLanguage properties for the Apple Watch applications are as follows:
AdditionCompleted..AdditionCompleted is used to find out and modify the mode for adding an element into a queue, a list or a stack.
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.
BrushColor..BrushColor is used to manage the background color of a control, window, page or report block.
ByAddress..ByAddress is used to find out whether a parameter of a procedure was passed by address or not.
CaptionIn a database, ..Caption is used to:
  • Find out the caption associated with an item of a data file
  • Find out the caption associated with a data file
  • Find out and modify the caption of a connection
In a report, ..Caption is used to:
  • Find out the text displayed in a Static control or in a link control.
  • Modify the text displayed in a Static control or in a link control
In a window or in a page, ..Caption is used to:
  • Find out and modify the caption of a control in a window or in a page.
  • Find out and modify the caption of a menu option.
  • Find out and modify the title of a window or page.
  • Find out the content of a site map path
Class..Class is used to find out the real type of the class instance handled by a variable (object, variant or dynamic object).
CountReturns the number of occurrences of a control in a window, in a page or in a group of controls.
Date..Date is used to:
  • Retrieve the date from a DateTime variable.
  • Modify the date in a DateTime variable.
  • Retrieve the date from a Date item (in "Date and Time" format) .
  • Modify the date in a Date item (in "Date and Time" format)
Day..Day is used to:
  • Retrieve the day from a Date, DateTime variable or retrieve the number of days from a Duration variable.
  • Modify the day in a Date, DateTime variable or modify the number of days in a Duration variable.
  • Retrieve the day or the number of days from a Date item (in "Date", "Date and Time" or "Duration" format)
  • Modify the day or the number of days in a Date item (in "Date", "Date and Time" or "Duration" format)
Default..Default is used to find out whether the parameter passed to a procedure was specified or whether it was assigned with its default value.
Empty..Empty is used to find out whether:
  • a Looper, Table, List Box or Combo Box control is empty. The control can be a browsing control or a memory control.
  • a Chart control contains no series.
  • a report control is empty (control linked to an item).
  • an array (or an associative array) contains no element.
  • an element of an associative array exists or not.
  • a queue, a list or a stack contains no element
Height..Height is used to find out and modify the height:
  • of a control or block in a report.
  • of a control (found in a window), window, row found in a table, in a list box or in a listview, option found in a radio button or in a check box, break header or break footer found in a table or in a looper.
  • of a control (found in a page), break header or break footer found in a table or in a looper. The control can be stackable or not.
Hour..Hour is used to:
  • Retrieve the hour from a Time, DateTime variable or retrieve the number of hours from a Duration variable.
  • Modify the hour in a Time, DateTime variable or modify the number of hours in a Duration variable.
  • Retrieve the hour or the number of hours from a Date item (in "Date and time" or "Duration" format) or from a Time item.
  • Modify the hour or the number of hours in a Date item (in "Date and time" or "Duration" format) or in a Time item.
InDays..InDays is used to convert a Duration variable into days.
InHours..InHours is used to convert a Duration variable into hours.
InMilliseconds..InMilliseconds is used to convert a Duration variable into milliseconds.
InMinutes..InMinutes is used to convert a Duration variable into minutes.
InSeconds..InSeconds is used to convert a Duration variable into seconds.
Member..Member on the Variant variables is used to get the array of named elements.
Millisecond..Millisecond is used to:
  • Retrieve the number of milliseconds from a Time, DateTime or Duration variable.
  • Modify the number of milliseconds in a Time, DateTime or Duration variable.
  • Retrieve the milliseconds or the number of milliseconds from a Date item (in "Date and Time" or "Duration" format)
  • Modify the milliseconds or number of milliseconds in a Date item ("Date and Time" or "Duration" format)
Month..Month is used to:
  • Retrieve the month from a Date or DateTime variable.
  • Modify the month in a Date or DateTime variable.
  • Retrieve the month from a Date item (in "Simple date" or "Date and Time" format)
  • Modify the month in a Date item (in "Simple Date" or "Date and Time" format)
Name..Name is used to find out:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page
NbPendingThread..NbPendingThread is used to find the number of pending threads in a queue or in a stack.
NbReceivedReturns the number of parameters actually received by a procedure.
Second..Second is used to:
  • Retrieve the number of seconds from a Time, DateTime or Duration variable.
  • Modify the number of seconds in a Time, DateTime or Duration variable.
  • Retrieve the seconds or the number of seconds from a Date item (in "Date and Time" or "Duration" format)
  • Modify the seconds or the number of seconds in a Date item (in "Date and Time" or "Duration" format)
State..State is used to find out and modify the display status of an element
Time..Time is used to:
  • Retrieve the time from a DateTime variable.
  • Modify the time in a DateTime variable.
  • Retrieve the time from in a Date item (in "Date and Time" format)
  • Modify the time in a Date item ("Date and Time" format).
Type..Type is used to find out:
  • the type of an element described by programming (file or item description) or not (file or item defined in the data model editor, view or query).
  • the type of an object.
  • the type of the value stored in a variant
Value..Value is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream
  • Find out and modify the value of a control or the title of a page
Visible..Visible is used to:
  • Find out whether an element is visible
  • Make an element visible or invisible
Width..Width is used to find out and modify the width:
  • of a control or block in a report.
  • of a control (found in a window), window, column found in a table or column found in a list box (including listview).
  • of a control (found in a page), column found in a table or column found in a list box. The control can be stackable or not.
X..X is used to:
  • Find out the X coordinate of a control, of a Table control column or of a window (position on the X axis).
  • Modify the X coordinate of a control or window (position on the X axis).
Y..Y is used to:
  • Find out the Y coordinate of a control or window (position on the Y axis).
  • Modify the Y coordinate of a control or window.
Year..Year is used to:
Universal Windows 10 App The new WLanguage properties for the applications in Universal Windows 10 App mode are as follows:
Abbreviation..Abbreviation is used to find out the abbreviation of the data file. This abbreviation was defined in the data model editor when describing the data file. This property is read-only.
AccentuationSensitive..AccentuationSensitive is used to configure the management mode of the accented characters in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Access..Access is used to manage the type of access for a connection (HFSQL Client/Server, OLE DB, ...).
After..After replaces or inserts a procedure after the other procedures in:
  • a Procedure variable.
  • a process associated with a control.
Alias..Alias is used to:
  • find out or modify the alias of a window (WINDEV)
  • Find out and modify the alias of a dynamic tab pane (WINDEV)
  • find out the internal HTML/Javascript name of a control (WEBDEV).
AllModifiableWithReportsAndQueries..AllModifiableWithReportsAndQueries is used to find out whether a report can be entirely modified in Reports & Queries.
AllowActionBarHiding..AllowActionBarHiding is used to automatically hide the Action Bar.
Anchor..Anchor is used to manage the anchor of a control in a window or report.
AnchorRateBottom..AnchorRateBottom is used to:
  • Find out the anchor rate when a control moves on the vertical axis
  • Modify the anchor rate when a control moves on the vertical axis.
AnchorRateHeight..AnchorRateHeight is used to:
  • Find out the anchor rate in height of a control
  • Modify the anchor rate in height of a control.
AnchorRateRight..AnchorRateRight is used to:
  • Find out the anchor rate when a control moves on the horizontal axis
  • Modify the anchor rate when a control moves on the horizontal axis.
AnchorRateWidth..AnchorRateWidth is used to:
  • Find out the anchor rate when a control (or a table column) stretches on the horizontal axis.
  • Modify the anchor rate when a control (or a table column) stretches on the horizontal axis.
AutoBrowse..AutoBrowse is used to find out whether the browse performed in a browsing list box, looper, table or combo box is automatic or programmed.
AutoRefresh..AutoRefresh is used to:
  • Find out whether the data found in the series is automatically recalculated whenever grDraw is called
  • Modify the mode for recalculating the data found in the series
BackgroundImage..BackgroundImage is used to find out and modify:
  • The background image associated with a window.
  • The image associated with the border of a button.
  • The background image associated with a progress bar or slider.
  • The background image associated with an HTML edit control.
  • The background image of a report
  • The background image of a Shape control
  • The background image of a Repositionable Note control
BackgroundImagePrinted..BackgroundImagePrinted is used to:
  • Find out whether the background image of a report (form report or not) must be printed.
  • Print (or not) the background image of a report.
BackgroundImageState..BackgroundImageState is used to find out and modify the number of drawings found in the image associated with the border of a button.
Before..Before replaces or inserts a procedure before the other procedures in:
  • a Procedure variable.
  • a process associated with a control.
Binary..Binary is used to find out whether an item is a binary item or not.
Border..Border is used to find out and modify the characteristics of the border:
  • for a report control or for a report block.
  • for a window control.
BottomMargin..BottomMargin is used to:
  • Find out the bottom margin of a report.
  • Modify the bottom margin of a report.
BrowsedFile..BrowsedFile is used to find out and modify the data source used to display the records in the controls based on a data file.
BrowsedItem..BrowsedItem is used to:
  • Find out the item used to automatically browse the Table, Looper, List Box, ListView and Combo Box controls, the reports based on file or the supercontrols.
  • Modify the item used to automatically browse the Table, Looper, List Box, ListView and Combo Box controls, the reports based on file or the supercontrols. Then, the browse is reinitialized
BrushColor..BrushColor is used to manage the background color of a control, window, page or report block.
ByAddress..ByAddress is used to find out whether a parameter of a procedure was passed by address or not.
CalculatedDefaultItem..CalculatedDefaultItem is used to:
  • Find out the SQL expression defining the default value of an item. This item was defined in the data model editor or by programming.
  • Define the SQL expression returning the default value of a item (when the item is described by programming).
CalculatedItemExpression....CalculatedItemExpression is used to:
  • Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or by programming.
  • Define the SQL expression that gives the value of a calculated item (when describing the item by programming).
CaptionIn a database, ..Caption is used to:
  • Find out the caption associated with an item of a data file
  • Find out the caption associated with a data file
  • Find out and modify the caption of a connection
In a report, ..Caption is used to:
  • Find out the text displayed in a Static control or in a link control.
  • Modify the text displayed in a Static control or in a link control
In a window or in a page, ..Caption is used to:
  • Find out and modify the caption of a control in a window or in a page.
  • Find out and modify the caption of a menu option.
  • Find out and modify the title of a window or page.
  • Find out the content of a site map path
CaptionPeriodHeader..CaptionPeriodHeader is used to find out and modify the content of the period caption displayed in the header of a Scheduler or Organizer control found in a report.
CaseSensitive..CaseSensitive is used to configure the management mode of the case (uppercase/lowercase characters) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Charset..Charset is used to:
  • Find out the character set used by a Font variable.
  • Modify the character set used by a Font variable.
  • Find out the character set used by a HFSQL file.
Class..Class is used to find out the real type of the class instance handled by a variable (object, variant or dynamic object).
CollapsedImage..CollapsedImage is used to
  • find out and/or modify the default image associated with a collapsed row in a TreeView Table control.
  • find out and/or modify the default image associated with a collapsed row in a TreeView control.
  • find out and/or modify the image associated with a specific collapsed row in a Treeview Table control.
  • find out and modify the image in a collapsed row of a TreeView item in a "Treeview table" type report
Color..Color is used to find out and modify the color of the font for:
  • a font variable.
  • a text displayed in a Static control or in a calculated control of a report.
  • a text displayed in a window control.
  • a text displayed in a page control.
ColumnWidth..ColumnWidth is used to find out and modify the width of each column found in a multi-column Looper control.
Component..Component is used to configure the different components of a composite key.
CompositeKey..CompositeKey is used to find out whether an item is a composite key.
Compression..Compression is used to manage the compression of data during a connection (HFSQL Client/Server, ...).
Connection..Connection is used to find out and modify the connection currently associated with a data file.
CryptMethod..CryptMethod is used to manage the type of encryption for the communication established between the client computers and the HFSQL server.
Cursor..Cursor is used to find out and modify the position of the mouse cursor in one fo the following controls:
  • Edit control
  • Editable combo box
  • "Edit control" table column and "Editable combo box" table column.
CursorEnd..CursorEnd is used to find out and modify the end of selection position of the mouse cursor in one of the following controls:
  • Edit control
  • Editable combo box
  • "Edit control" table column and "Editable combo box" table column.
Database..Database is used to manage the database associated with a connection (HFSQL Client/Server, OLE DB, ...).
Date..Date is used to:
  • Retrieve the date from a DateTime variable.
  • Modify the date in a DateTime variable.
  • Retrieve the date from a Date item (in "Date and Time" format) .
  • Modify the date in a Date item (in "Date and Time" format)
Day..Day is used to:
  • Retrieve the day from a Date, DateTime variable or retrieve the number of days from a Duration variable.
  • Modify the day in a Date, DateTime variable or modify the number of days in a Duration variable.
  • Retrieve the day or the number of days from a Date item (in "Date", "Date and Time" or "Duration" format)
  • Modify the day or the number of days in a Date item (in "Date", "Date and Time" or "Duration" format)
DecimalPart..DecimalPart is used to configure the Numeric items.
Default..Default is used to find out whether the parameter passed to a procedure was specified or whether it was assigned with its default value.
DefaultValue..DefaultValue is used to:
  • Find out the default value of an item. This item was defined in the data model editor or by programming.
  • Define the default value of an item (when the item is described by programming).
DeletionRule..DeletionRule is used to configure the deletion rule (integrity management) of records that will be applied to the file described by programming.
DescribedDirectory..DescribedDirectory is used to manage the physical directory of HFSQL files.
DescribedName..DescribedName is used to manage the logical name of HFSQL files.
DescribedPhysicalName..DescribedPhysicalName is used to manage the physical name of HFSQL files.
Directory..Directory is used to manage the physical directory of HFSQL files.
DisplayCurrency..DisplayCurrency is used to find out and modify the currency used when displaying and/or entering data in a "Currency + Euro" control.
DisplayedItem..DisplayedItem is used to:
  • Find out the item or the variable displayed by the control.
  • Modify the item or the variable displayed by the control.
DisplayedValue..DisplayedValue is used to find out the value currently displayed on the screen in a window control or in a page control.
Empty..Empty is used to find out whether:
  • a Looper, Table, List Box or Combo Box control is empty. The control can be a browsing control or a memory control.
  • a Chart control contains no series.
  • a report control is empty (control linked to an item).
  • an array (or an associative array) contains no element.
  • an element of an associative array exists or not.
  • a queue, a list or a stack contains no element
EndDate..EndDate is used to find out and modify the end date of the period selected
  • in a Calendar control,
  • in an Organizer control.
  • in a Scheduler control
EndDatePeriodDisplayed..EndDatePeriodDisplayed is used to find out the end date of the period currently printed in a Scheduler control or in an Organizer control found in a report.
ExecutionCompleted..ExecutionCompleted is used to find out whether the execution of a query or view (in HFSQL Classic or Client/Server format) is completed.
ExpandedImage..ExpandedImage is used to:
  • find out and modify the default image associated with an expanded row in a TreeView Table control.
  • find out and/or modify the default image associated with an expanded row in a TreeView control.
  • find out and modify the image associated with a specific expanded row in a TreeView Table control.
  • find out and modify the image associated with an expanded row in a treeview item of a "TreeView table" report.
Extension..Extension is used to:
  • find out the extension of a file defined in the data model editor or by programming.
  • define the extension of a file (when the file is described by programming only).
FicCryptMethod..FicCryptMethod is used to configure the encryption mode of the data file.
FileLink..FileLink is used to find out and modify the link between a control:
  • and an item found in a data file.
  • and a variable
  • and several variables
FilterCondition..FilterCondition is used to find out the selection condition implemented by HFilter on a data file, a HFSQL view or a query.
FilteredItem..FilteredItem is used to find out the item on which a filter was implemented by HFilter.
FilterWithBounds..FilterWithBounds is used to find out whether bounds have been specified for the filter implemented byHFilter on a HFSQL data file, view or query.
Font..Font is used to:
  • Find out the identifier of the font used in a control found in a report, in a page or in a window.
  • Modify the font used in a control found in a report, in a page or in a window.
FontAppointmentContent..FontAppointmentContent is used to:
  • Find out the characteristics of the font used for the content of appointments in the Scheduler and Organizer reports.
  • Modify the characteristics of the font used for the content of appointments in the Scheduler and Organizer reports.
FontAppointmentTitle..FontAppointmentTitle is used to:
  • Find out the characteristics of the font used for the title of the appointments in the Scheduler and Organizer reports.
  • Modify the characteristics of the font used for the title of the appointments in the Scheduler and Organizer reports.
FontBold..FontBold is used to:
  • Find out whether a text is bold or not.
  • Modify the weight of a text
FontCharset..FontCharset is used to:
  • Find out the character set used by the screen fonts of a control.
  • Modify the character set used by the screen fonts of a control.
FontItalic..FontItalic is used to:
  • Find out whether the italic attribute is assigned to a text.
  • Modify the italic attribute of a text
FontName..FontName is used to:
  • Find out the font used in a control.
  • Modify the font used in a control
FontSize..FontSize is used to:
  • Find out the size of the font used in a control.
  • Modify the size of the font used in a control
FontStrikeOut..FontStrikeOut is used to:
  • Find out whether a text is struck out or not.
  • Strike out (or not) the text displayed in a control
FontUnderlined..FontUnderlined is used to:
  • Find out whether a text is underlined or not.
  • Underline (or not) a text
Format..Format is used to configure the format of data in a data file.
FullName..FullName is used to find out the full name:
  • of a control.
  • of a window.
  • of a menu option.
  • of a table column.
FutureHeight..FutureHeight is used to find out the height of an auto-sizable control in a report when this control is enlarged.
GenerationNumber..GenerationNumber is used to find out the generation number of the physical file associated with the specified logical file.
GranularityGridlines..GranularityGridlines allows you to find out and modify the size of the grid used to display the gridlines in a Scheduler control or in an Organizer control found in a report.
Grayed..Grayed is used to
  • Find out whether a control (or a group of controls) is grayed or not
  • Gray or ungray a control or a group of controls
Group..Group is used to:
  • find out whether the control belongs to a group of controls. If the control belongs to one or more groups, ..Group is used to identify these groups of controls.
  • associate a control with a group of controls.
GUIDAnalysis..GUIDAnalysis returns the GUID of the analysis that was used to create the data file
GUIDFile..GUIDFile is used to find out the GUID of the file defined in the analysis that was used to create the data file
Height..Height is used to find out and modify the height:
  • of a control or block in a report.
  • of a control (found in a window), window, row found in a table, in a list box or in a listview, option found in a radio button or in a check box, break header or break footer found in a table or in a looper.
  • of a control (found in a page), break header or break footer found in a table or in a looper. The control can be stackable or not.
HeightInPixel..HeightInPixel is used to find out the height of a report control in pixels.
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).
HorizontalAlignment..HorizontalAlignment is used to find out and modify the horizontal alignment of a control.
Hour..Hour is used to:
  • Retrieve the hour from a Time, DateTime variable or retrieve the number of hours from a Duration variable.
  • Modify the hour in a Time, DateTime variable or modify the number of hours in a Duration variable.
  • Retrieve the hour or the number of hours from a Date item (in "Date and time" or "Duration" format) or from a Time item.
  • Modify the hour or the number of hours in a Date item (in "Date and time" or "Duration" format) or in a Time item.
HSpace..HSpace is used to find out and modify the horizontal spacing between the report labels. This spacing was defined when the Label report was created.
HTML..HTML is used to find out whether the report currently printed is printed in HTML mode.
HugeFile..HugeFile is used to configure the maximum size of a data file.
Image..Image is used to find out and modify the background image associated with a control or with a block.
ImageState..ImageState is used to find out and modify the number of drawings found in:
  • The image associated with a button.
  • The image of the cursor in a slider.
  • The image associated with the button of a sidebar pane.
  • The image associated with the button of a tab pane.
  • The image associated with the Rating control.
InDays..InDays is used to convert a Duration variable into days.
InfoThumbnailGeneration..InfoThumbnailGeneration is used to find out whether the thumbnails of an item have been successfully generated.
InHours..InHours is used to convert a Duration variable into hours.
InitialContent..InitialContent is used to find out and modify the initial content:
  • of a memory List Box control.
  • of a memory Combo Box control.
  • of a "List of values" column found in a Table control.
  • in a Spreadsheet control.
InitialFile..InitialFile is used to find out the initial name of the data file associated with an item found in a query.
InitialHeight..InitialHeight is used to:
  • Find out the creation height of a control or window.
  • Modify the base height used to anchor the controls "in height".
  • Find out the creation height of a block or control in a report.
InitialItem..InitialItem is used to find out the initial name of an item found in a query. This name is known from the alias of this item.
InitialState..InitialState is used to find out the initial status of a control
InitialValue..InitialValue is used to find out the initial value of a control found in a window or in a page.
InitialVisible..InitialVisible is used to find out whether:
  • a control was visible during the first display of the associated window.
  • a window was visible during its first display.
InitialWidth..InitialWidth is used to:
  • Find out the initial width of a control or window.
  • Modify the base width used to anchor the controls in "width".
  • Find out the initial width of a report control.
InMilliseconds..InMilliseconds is used to convert a Duration variable into milliseconds.
InMinutes..InMinutes is used to convert a Duration variable into minutes.
InputMask..InputMask is used to:
  • find out the input mask.
  • modify the input mask (among the available masks for the type).
InputType..InputType is used to find out and modify the type of input allowed by a control: Duration, Date, Numeric, ...
InSeconds..InSeconds is used to convert a Duration variable into seconds.
IntegerPart..IntegerPart is used to configure the Numeric items.
InterfaceModifiableWithReportsAndQueries..InterfaceModifiableWithReportsAndQueries is used to find out whether the interface of a report can be modified in Reports & Queries.
InternalReportName..InternalReportName is used to:
KeyExpression..KeyExpression is used to configure the different components of a composite key.
KeySize..KeySize is used to configure the characteristics of a Text Memo key item.
KeyType..KeyType is used to configure the characteristics of a key item.
LabelHeight..LabelHeight is used to:
  • Find out the height of labels in a Label report.
  • Modify the height of labels in a Label report.
LabelNumberToStart..LabelNumberToStart is used to:
  • Find out the number of the label on the label sheet from which the print will be performed.
  • Modify the number of the label from which the print will be performed on the label sheet.
LabelWidth..LabelWidth is used to:
  • Find out the width of labels in a "Label" report.
  • Modify the width of labels in a "Label" report.
Language..Language is used to manage the language used to perform the comparisons and the sort for the Unicode items (Unicode Text item or Unicode Text Memo item).
LanguageDescribed..LanguageDescribed allows you to manage the language used to perform the comparisons and the sort for the Unicode items (Unicode Text item or Unicode Text Memo item).
LeftMargin..LeftMargin is used to:
  • Find out the left margin of a report.
  • Modify the left margin of a report.
Legend..Legend is used to:
  • Find out the label of a series.
  • Modify the label of a series.
LineHeight..LineHeight is used to find out and modify the height of the rows:
  • in a List Box control,
  • in a ListView control (standard display mode only),
  • in a Table control,
  • in a Combo Box control,
  • in a Looper control (height of the row),
  • in an Organizer control.
LinkedFile..LinkedFile is used to configure the characteristics of a link.
LinkedKey..LinkedKey is used to configure the characteristics of a link.
MapMode..MapMode is used to find out and change the display mode of a map in a Map control.
MaxAutoID..MaxAutoID is used to find out the maximum automatic identifier on a replicated file.
MaxHeight..MaxHeight is used to find out and modify the maximum height of a control or window.
MaxLinkedCardinality..MaxLinkedCardinality is used to find out and modify the maximum cardinality of the linked item in the link.
MaxSourceCardinality..MaxSourceCardinality is used to find out and modify the maximum cardinality of the source item in the link.
MaxThumbnailHeight..MaxThumbnailHeight is used to find out and modify the maximum height of an item thumbnail.
MaxThumbnailWidth..MaxThumbnailWidth is used to find out and modify the maximum width of an item thumbnail.
MaxValue..MaxValue is used to:
  • find out and modify the upper bound of a report based on a data file
  • find out the upper bound defined for the current filter.
  • find out the maximum value of a chart series.
  • find out and modify the maximum value for some types of controls
MaxWidth..MaxWidth is used to find out and modify the maximum width of a control or window.
Member..Member on the Variant variables is used to get the array of named elements.
Memo..Memo is used to find out whether an item is a memo item.
Memory..Memory is used to find out whether the specified control is a memory control or a browsing control.
MemoryCurrency..MemoryCurrency is used to find out and modify the currency used when handling a "Currency + Euro" control by programming.
MemoryFormat..MemoryFormat is used to find out and modify the format of the value returned for:
  • the Date or Time edit controls.
  • the Date or Time table columns.
  • the Calendar controls
  • the Static controls
  • the editable combo boxes.
  • the table columns displayed by combo boxes
MemZoneName..MemZoneName is used to:
  • find out the name of the memory zone used as data source for a report.
  • modify the name of the memory zone used as data source for a report.
Millisecond..Millisecond is used to:
  • Retrieve the number of milliseconds from a Time, DateTime or Duration variable.
  • Modify the number of milliseconds in a Time, DateTime or Duration variable.
  • Retrieve the milliseconds or the number of milliseconds from a Date item (in "Date and Time" or "Duration" format)
  • Modify the milliseconds or number of milliseconds in a Date item ("Date and Time" or "Duration" format)
MinAutoID..MinAutoID is used to find out the minimum automatic identifier on a replicated file.
MinHeight..MinHeight is used to find out and modify the minimum height of a control or window.
MinLinkedCardinality..MinLinkedCardinality is used to find out and modify the minimum cardinality of the linked item in the link.
MinSourceCardinality..MinSourceCardinality is used to find out and modify the minimum cardinality of the source item in the link.
Minute..Minute is used to:
  • Retrieve the minutes from a Time or DateTime variable or the number of minutes from a Duration.
  • Modify the minutes in a Time or DateTime variable or the number of minutes in a Duration.
  • Retrieve the minutes or the number of minutes from a Date item (in "Date and Time" or "Duration" format) or from a Time item
  • Modify the minutes or the number of minutes in a Date item (in "Date and Time" or "Duration" format) or in a Time item
MinValue..MinValue is used to:
  • find out and modify the lower bound of a report based on a data file.
  • find out the lower bound defined for the current filter.
  • find out the minimum value of a chart series.
  • find out and modify the minimum value for some types of controls.
MinWidth..MinWidth is used to find out and modify the minimum width of a control or window.
MmoCryptMethod..MmoCryptMethod is used to configure the encryption mode of the memo file (.MMO extension) associated with the data file.
MmoPackMethod..MmoPackMethod is used to configure the compression mode of the MMO file (containing the binary and text memos) associated with a data file.
ModificationRule..ModificationRule is used to configure the modification rule of records (integrity management) that will be applied to the file described by programming.
Modified..Modified is used to find out whether a control (or a group of controls) was modified by the user (with the keyboard or with the mouse.
Month..Month is used to:
  • Retrieve the month from a Date or DateTime variable.
  • Modify the month in a Date or DateTime variable.
  • Retrieve the month from a Date item (in "Simple date" or "Date and Time" format)
  • Modify the month in a Date item (in "Simple Date" or "Date and Time" format)
MsgSortSel..MsgSortSel is used to:
  • Find out the wait message displayed when sorting and selecting the report records.
  • Modify the wait message displayed when sorting and selecting the report records.
MultilineIn a window or in a page, ..Multiline is used to:
  • find out whether an edit control is multi-line. The property is read-only.
  • find out and modify the "multiline" option of a column in a Table control.
In a report, ..Multiline is used to:
  • find out whether a report control is multi-line
  • modify the "Multi-line" option of a report control.
Multiselection..Multiselection is used to find out and modify the selection mode:
  • of a Table (and TreeView Table) control.
  • of a Pivot Table control.
  • of a List Box (and ListView) control.
  • of a Looper control.
  • of a Calendar control.
  • of files in an Upload control.
Name..Name is used to find out:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page
NbArrayElement..NbArrayElement is used to configure the number of elements in an array item.
NbColumn..NbColumn is used to find out the number of report columns.
NbComponent..NbComponent is used to find out the number of elements found in a composite key.
NbCopy..NbCopy is used to find out and modify the number of report copies that must be printed.
NbDescribedThumbnail..NbDescribedThumbnail is used to find out the number of thumbnails described for an item.
NbItem..NbItem is used to find out the total number of items (including composite keys) in a record found in:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query.
NbKeyItem..NbKeyItem returns the total number of key items (including composite keys) found in a record of:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query.
NbLabel..NbLabel is used to:
  • Find out the number of labels printed across the page width.
  • Modify the number of labels printed across the page width.
NbLabelCopy..NbLabelCopy is used to:
  • Find out the number of copies of identical labels.
  • Modify the number of copies of identical labels.
NbMemoItem..NbMemoItem returns the total number of memo items found in a record of:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query.
NbPendingThread..NbPendingThread is used to find the number of pending threads in a queue or in a stack.
NbPrintedRec..NbPrintedRec is used to find out the number of records already printed.
NbReceivedReturns the number of parameters actually received by a procedure.
NbRecRead..NbRecRead is used to find out the number of records read: selected both by the source of the report AND by the filter code (if it exists).
NbThumbnail..NbThumbnail is used to find out the number of thumbnails generated for an item.
NdxCryptMethod..NdxCryptMethod is used to configure the encryption mode of the index file (.NDX extension) associated with the data file.
NewLine..NewLine is used to find out:
  • in a Table control, whether the current row was created by TableAddXXX or TableInsertXXX.
  • in a Looper control, whether the current row was created by LooperAddXXX or LooperInsertXXX.
  • in an Organizer control, whether an appointment was created via the popup menu.
  • in a Scheduler control, whether an appointment was created via the popup menu.
NewRecord..NewRecord is used to find out whether the record is a new record or whether it comes from the data file.
Note..Note is used to:
  • Find out the notes associated with a control, a window or a page.
  • Modify the notes associated with a control, a window or a page.
NoteTitle..NoteTitle is used to:
  • Find out the title of the notes used in the program documentation of a window, control or page
  • Modify the title of the notes used in the program documentation of a control, window or page.
Null..Null is used to:
  • Assign NULL to the item for the current record.
  • Find out whether the item is associated with the NULL value for the current record.
  • Define the default value of an item when the item is described by programming.
NullAllowed..NullAllowed is used to manage the NULL value in the items of HFSQL data files.
NullSupported..NullSupported is used to manage the NULL value in HFSQL data files.
Num1stDayOfTheWeek..Num1stDayOfTheWeek is used to find out and modify the 1st day of the week displayed in:
  • a Calendar control.
  • an Organizer control.
  • a Scheduler control
  • an edit control in Date format with Calendar
Numerical..Numerical is used to find out whether an item is a numeric item.
Occurrence..Occurrence is used to find out the number of elements found in a set.
Opacity..Opacity is used to find out and define the percentage of opacity for a window or for the controls found in a window or in a page.
PageByPagePrint..PageByPagePrint is used to:
  • Ask a report to be printed page by page. Each page of the report will be sent separately to the printer spooler.
  • Find out the print mode of the report (page by page or all at once).
PageEndStick..PageEndStick is used to:
  • Find out whether the page footer must be stuck to the last block.
  • Modify the management mode of the Page Footer block.
Password..Password can be used
  • on the edit controls (or on the text table columns) to find out whether the control is a "Password" control or to modify the "Password" type of the control
  • on the connections (HFSQL Client/Server, OLE DB, ...) to define the password of the user who is using the connection
PasswordProtected..PasswordProtected is used to find out whether a data file is password protected.
PersistedCalculatedItem..PersistedCalculatedItem is used to:
  • Find out whether the value of a calculated item is stored in the data file. This item was defined in the data model editor or by programming.
  • Define whether the value of a calculated item is stored in the data file (when describing the item by programming).
PhysicalName..PhysicalName is used to manage the physical name of HFSQL files.
Plane..Plane is used to:
  • Find out the active plane in a window (or in a report) or the plane to which a control belongs.
  • Modify the active plane of a window (or report) or associate a control with another plane.
PopupMenu..PopupMenu is used to:
  • Find out the custom popup menu associated with a control or with a window.
  • Modify the popup menu associated with a control or with a window (associate another popup menu with the control or with the window).
  • Customize the system menus of the controls by adding options.
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, ...
Provider..Provider is used to manage the type of connection (HFSQL Client/Server, OLE DB, ...).
PunctuationSensitive..PunctuationSensitive is used to configure the management mode of the punctuation (comma, dot, etc.) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Pushed..Pushed is used to find out and modify the status of an on/off button (pressed or not).
RecordSize..RecordSize is used to find out and modify the size (in bytes) of a record found in:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query.
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).
ReturnedValue..ReturnedValue is used to:
  • Find out and modify the value returned by a window, a page or a report.
  • Find out and modify the value returned by an option in a Radio Button control.
RightMargin..RightMargin is used to:
  • Find out the right margin of a report.
  • Modify the right margin of a report.
RightToLeft..RightToLeft is used to find out the actual writing direction, effective on a control, a column, a window or a report.
Second..Second is used to:
  • Retrieve the number of seconds from a Time, DateTime or Duration variable.
  • Modify the number of seconds in a Time, DateTime or Duration variable.
  • Retrieve the seconds or the number of seconds from a Date item (in "Date and Time" or "Duration" format)
  • Modify the seconds or the number of seconds in a Date item (in "Date and Time" or "Duration" format)
SecondaryAxis..SecondaryAxis is used to
  • find out whether a chart series is placed on the secondary axis
  • put a chart series on the secondary axis
Secure..Secure is used to configure the security level for file encryption.
SelectionOnly..SelectionOnly is used to:
  • Find out which elements of the table or treeview table will be printed: printing all the records or the selected records only.
  • Modify the print mode of the table or treeview rows: printing all the records or the selected records only.
SeriesColor..SeriesColor is used to:
  • Find out the color of a series in a chart.
  • Modify the color of a series in a chart
Server..Server is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, ...).
Size..Size is used to find out and modify the size of an element
Sorted..Sorted is used to:
  • Find out whether a control is sorted
  • Sort a control or not
SortType..SortType is used to:
  • Find out the sort direction defined for an item or for a component of a composite key. This item was defined in the data model editor or by programming.
  • Define the sort direction for an item or for a component of a composite key (when describing the item by programming)
Source..Source can be used on:
  • a Chart control: in this case, ..Source is used to find out the source of the series: Table column, list of values, ...
  • a connection: in this case, ..Source is used to find out and define the source of a connection (HFSQL Client/Server, OLE DB, ...)
SourceDescription..SourceDescription allows you to find out the name of the element used as data source for a series.
SourceFile..SourceFile is used to configure the characteristics of a link.
SourceKey..SourceKey is used to configure the characteristics of a link.
SourceName..SourceName is used to:
  • Find out the name of the data source for the report.
  • Change the data source of the report.
SourceWindow..SourceWindow is used to find out the source of an internal window (which means the internal window displayed by the Internal Window control).
SQLCode..SQLCode is used to find out the SQL code of a query created with the query editor (".WDR" file).
StartDate..StartDate is used to find out and modify the start date of the period selected:
  • in a Calendar control
  • in an Organizer control.
  • in a Scheduler control
StartDatePeriodDisplayed..StartDatePeriodDisplayed is used to find out the start date of the period currently printed in a Scheduler or Organizer control found in a report.
State..State is used to find out and modify the display status of an element
StoredItem..StoredItem is used to:
  • Find out the stored item or the stored variable of a table, looper, list box or combo box.
  • Modify the stored item or the stored variable of a table, looper, list box or combo box
StoredValue..StoredValue is used to find out the value currently stored by a row in a List Box control, ListView control or Combo Box control.
Subscript..Subscript is used to find out the physical subscript (physical order) of the item in the record.
Text..Text is used to find out whether an item is a text item.
TextDirection..TextDirection is used to find out and modify the writing direction used in a window, in a report or in a control (useful for managing languages such as Arabic or Hebrew).
TextItemCompleted..TextItemCompleted is used to configure the management of text items in a HFSQL file.
TextProgressBar..TextProgressBar is used to find out and modify the text displayed in a progress bar.
Thumbnail..Thumbnail is used to find out the value of an item thumbnail.
Time..Time is used to:
  • Retrieve the time from a DateTime variable.
  • Modify the time in a DateTime variable.
  • Retrieve the time from in a Date item (in "Date and Time" format)
  • Modify the time in a Date item ("Date and Time" format).
TimestampType..TimestampType is used to:
  • Find out the type of timestamp for an item. This item was defined in the data model editor or by programming.
  • Define the type of timestamp for a Date, Time or DateTime item (when describing the item by programming).
TimestampUTC....TimestampUTC is used to:
  • Find out whether a timestamp item will use a UTC time or a local time. This item was defined in the data model editor or by programming.
  • Define whether a timestamp item will use a UTC time or a local time (when describing the item by programming).
Title..Title is used to:
  • Find out the title of a table column, Chart control, window or page
  • Modify the title of a table column, Chart control, window or page.
ToolTip..ToolTip is used to find out and modify the text displayed in the tooltip associated with a control found in a window or in a page.
TopMargin..TopMargin is used to:
  • Find out the top margin of a report.
  • Modify the top margin of a report.
TotalNbRec..TotalNbRec is used to:
  • Find out the number of records to print.
  • Modify the number of records to print.
TwoWayAnimation..TwoWayAnimation is used to:
  • Find out whether the animation in an infinite progress bar control is two ways.
  • Configure the animation in a infinite progress bar control to be two ways.
Type..Type is used to find out:
  • the type of an element described by programming (file or item description) or not (file or item defined in the data model editor, view or query).
  • the type of an object.
  • the type of the value stored in a variant
TypeDescription..TypeDescription is used to:
  • Find out the type used by an Enumeration or Combination item. This item was defined in the data model editor or by programming.
  • Define the type used by an Enumeration or Combination item (when the item is described by programming).
URL..URL is used to:
  • Find out the address associated with a control.
  • Modify the address associated with a control.
User..User is used to manage the user of a connection (HFSQL Client/Server, OLE DB, ...).
Value..Value is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream
  • Find out and modify the value of a control or the title of a page
Vertical..Vertical is used to:
  • find out whether a control is oriented horizontally or vertically.
  • modify the display direction of the Table and Looper controls (switch from vertical to horizontal and conversely)
VerticalAlignment..VerticalAlignment is used to find out and modify the vertical alignment of a control.
ViewName..ViewName is used to:
  • find out the name of the HFSQL view, data source of a report
  • modify the name of the HFSQL view, data source of a report.
Visible..Visible is used to:
  • Find out whether an element is visible
  • Make an element visible or invisible
VisibleEndUser..VisibleEndUser is used to:
  • Find out whether an item is visible or not to the end users. This item was defined in the data model editor or by programming.
  • Define whether an item must be visible or not to the end users (when the item is described by programming).
VSpace..VSpace is used to find out and modify the vertical spacing between the report labels. This spacing was defined when the Label report was created.
Width..Width is used to find out and modify the width:
  • of a control or block in a report.
  • of a control (found in a window), window, column found in a table or column found in a list box (including listview).
  • of a control (found in a page), column found in a table or column found in a list box. The control can be stackable or not.
WidthInPixel..WidthInPixel is used to find out the width of a report control in pixels.
X..X is used to:
  • Find out the X coordinate of a control, of a Table control column or of a window (position on the X axis).
  • Modify the X coordinate of a control or window (position on the X axis).
XInitial..XInitial is used to:
  • Find out the X coordinate of a control or window (position on the X axis) when the window is opened.
  • Modify the X coordinate of a control anchored "to the right" (position on the X axis) when the window is opened.
  • Find out the X coordinate of a control in relation to its block (position in millimeters on the X axis) when the report is opened.
Y..Y is used to:
  • Find out the Y coordinate of a control or window (position on the Y axis).
  • Modify the Y coordinate of a control or window.
Year..Year is used to:
YInitial..YInitial is used to:
  • Find out the Y coordinate of a control or window (position on the Y axis) when the window is opened.
  • Modify the Y coordinate of a control anchored "to the bottom" (position on the vertical axis) when the window is opened.
  • Find out the Y coordinate of a control in relation to its block (position in millimeters on the vertical axis) when the report is opened.
Zoom..Zoom allows you to find out and modify the zoom value used:
  • in an Image control.
  • in a Map control.
  • in an Organization Chart control.
  • in a Table, Treeview Table, Pivot Table, Spreadsheet or List Box control.
  • in a window
ZOrder..ZOrder is used to manage the z-order position of a control.
Improved WLanguage properties
AndroidAndroid Widget The following properties have been improved in this version:
OccurrenceSupports the Queue, Stack and List variables.
EmptySupports the Queue, Stack and List variables.
New advanced types of WLanguage
Android The new advanced types available for the Android applications are as follows:
AppointmentThe Appointment type is used to define the advanced characteristics of an appointment: time, location, ...
BTLECharacteristicThe BTLECharacteristic type is used to handle a characteristic of a Bluetooth Low Energy service.
BTLEDescriptorThe BTLEDescriptor type is used to handle the descriptor of a Bluetooth Low Energy characteristic.
BTLEDeviceThe BTLEDevice type allows you to handle a device that is using the Bluetooth Low Energy technology.
BTLEServiceThe BTLEService type is used to handle a Bluetooth Low Energy service ("Bluetooth GATT Service").
ListA List variable is a structured type that is used to group a set of elements of the same type.
QueueA queue variable is a structured type that is used to group a set of elements of the same type.
RepetitionThe Repetition type is used to describe and modify the characteristics of repetition for an appointment via the different WLanguage properties.
StackA Stack variable is a structured type that is used to group a set of elements of the same type.
Android Widget The new advanced types available in Android Widget mode are as follows:
ListA List variable is a structured type that is used to group a set of elements of the same type.
QueueA queue variable is a structured type that is used to group a set of elements of the same type.
StackA Stack variable is a structured type that is used to group a set of elements of the same type.
iPhone/iPad The new advanced types available for the iPhone/iPad applications are as follows:
AppointmentThe Appointment type is used to define the advanced characteristics of an appointment: time, location, ...
BTLECharacteristicThe BTLECharacteristic type is used to handle a characteristic of a Bluetooth Low Energy service.
BTLEDescriptorThe BTLEDescriptor type is used to handle the descriptor of a Bluetooth Low Energy characteristic.
BTLEDeviceThe BTLEDevice type allows you to handle a device that is using the Bluetooth Low Energy technology.
BTLEServiceThe BTLEService type is used to handle a Bluetooth Low Energy service ("Bluetooth GATT Service").
CalendarThe Calendar type is used to handle a calendar (or organizer) associated with a user account or found on the device.
ReminderThe Reminder type is used to describe and handle a reminder to inform the user of an appointment.
RepetitionThe Repetition type is used to describe and modify the characteristics of repetition for an appointment via the different WLanguage properties.
Apple Watch The new advanced types available for the Apple Watch applications are as follows:
AutomaticEventThe AutomaticEvent type is used to manage an automatic signal.
DefinitionThe Definition type is used to find out the characteristics of a type:
  • simple type,
  • advanced type,
  • class,
  • structure.
ManualEventThe ManualEvent type is used to manage a manual signal.
ParallelTaskThe ParallelTask type is used to handle a task, which means a procedure run by a thread in the parallel programming.
ProcedureThe Procedure type is used to handle by programming
  • the procedures or methods found in the project
  • the procedures or methods found in an internal component.
  • the procedures or methods found in an external component.
Property descriptionThe Property Description type is used to get information about a property.
Universal Windows 10 App The new advanced types available for the Universal Windows 10 App applications are as follows:
AddressThe Address type is used to handle the address of a location or the address of a person.
AppointmentThe Appointment type is used to define the advanced characteristics of an appointment: time, location, ...
ColorThe Color type is used to define the advanced characteristics of a WLanguage color.
ImageThe Image type is used to define the advanced characteristics of an image.
MarkerThe Marker type is used to define the characteristics of a tag that must be positioned on a map displayed in a Map control.
PaletteThe Palette type is used to define all the advanced characteristics of a color palette.
xmlAttributeThe xmlAttribute type is used to handle the attributes of a node in an XML document.
xmlDocumentThe xmlDocument type is used to handle an XML file.
xmlNamespaceThe xmlNamespace type is used to handle the XML namespace of a node attribute in an XML document.
xmlNodeThe xmlNode type is used to handle a node of an XML document.
xpathResultThe xpathResult type is used it find out the result of the execution of an XPATH query.
Improved advanced types of WLanguage
Windows Mobile The following advanced types have been improved for the Windows Mobile applications:
BorderNew properties used to manage the borders and the rounding in an independent way.
Android The following advanced types have been improved for the Android applications:
MarkerNew property (Alignment) used to manage the alignment of the marker on the map.
iPhone/iPad The following advanced types have been improved for the iPhone/iPad applications:
BorderNew properties used to manage the borders and the rounding in an independent way.
httpRequestNew property (ConnectionTimeOut) used to manage the connection time-out.
ImageNew property (DrawingScale) used to manage the scale of the drawing.
MarkerNew property (Alignment) used to manage the alignment of the marker on the map.
restRequestNew property (ConnectionTimeOut) used to manage the connection time-out.
wsRequestNew property (Timeout) used to manage the response time-out.
Minimum required version
  • Version 20
Comments
Click [Add] to post a comment