ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HDelete (Function)
Deletes a record from a data file (query or view).
HFirst (Function)
Sets the position on the first record of a data file according to the specified browse item.
HCross (Function)
Crosses a record in a data file.
HLockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
HStatTime (Function)
Returns the time of the last update for the index statistics.
HStatDate (Function)
Returns the date of the last update for the index statistics.
HDuplicateRecord (Function)
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
Native SQL Server Connector: Executing the same stored procedure multiple times
In some cases, it may be useful to execute the same stored procedure multiple times by changing one or more parameters ......
Millisecond (Property)
The Millisecond property 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)...
Second (Property)
The Second property 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)...
HErrorLock (Function)
Used to check whether a lock error occurred.
<Source>.FilterIdentical (Function)
Defines and enables a filter used to find the exact value of a string item.
HFilterIdentical (Function)
Defines and enables a filter used to find the exact value of a string item.
HDescribeConnection (Function)
Describes a new connection to an external database.
HDescribeItem (Function)
Describes a file item through programming.
spMatchesDescription (Property)
The spMatchesDescription property determines if the parameters (key derivation function, hash algorithm, iteration count and output length) of the item of type "Password" in the data file match the parameters described programmatically or in the analysis.
spDerivation (Property)
The spDerivation property is used to: Get the key derivation function used to hash an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically. Set the key derivation function used for hashing (only for "Password" items defined programmatically)....
spLength (Property)
The spLength property is used to: Get the hash output length. This property can be used for items of type "Password" defined in the data model editor or programmatically. Set the hash output length (only for "Password" items defined programmatically)....
spIterationCount (Property)
The spIterationCount property is used to: Get the iteration count of the hash algorithm used for an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically. Sets the iteration count of the hash algorithm used for an item of type "Password" (only for "Password" items described programmatically)....
spHash (Property)
The spHash property is used to: Get the algorithm used for salting an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically. Set the algorithm used for salting (only for "Password" items described programmatically)....
spAge (Property)
The spAge property gets the time elapsed since the password was last changed.
<Source>.StatCalculate (Function)
Performs various statistical calculations on the file keys.
<Source>.Read (Function)
Reads a record in a file according to a given record number.
Data model editor: the different types of items
The different types of items proposed in the data model editor are as follows:
<Source>.Last (Function)
Sets the position on the last record of a data file according to a browse item.