PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HRetrieveRecord (Function)
In French: HRécupèreEnregistrement
ODBCNot available with this kind of connection
Returns the content of the current record (in a HFSQL data file, view, query, ...).
Versions 15 and later
Android This function is now available for the Android applications.
New in version 15
Android This function is now available for the Android applications.
Android This function is now available for the Android applications.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
Rec is string = HRetrieveRecord(CUSTOMER)
// Retrieves the string containing the entire record
MyRecord is string = HRetrieveRecord(CUSTOMER)
// Extracts the last name of the customer
CustomerLastName is string = ExtractString(MyRecord, 1)
// Extracts the first name of the customer
CustomerFirstName is string = ExtractString(MyRecord, 2)
Syntax

Retrieving the content of a record for the specified file Hide the details

<Result> = HRetrieveRecord([<File Name> [, <Item Separator> [, <Array Separator> [, <Format>]]]])
<Result>: Character string
Value of the record, in the following format:
<Content of Item 1> + <Item Separator> + <Content of Item 2> +...
The contents of items are extracted according to the physical order of the items in the data file. If the item corresponds to NULL, <Content of Item> corresponds to an empty string ("").
Depending on the specified <Format>, this character string is in ANSI format (default) or Unicode format.
<File Name>: Optional character string (with or without quotes)
Name of the data file (view or query) used. If this name is not specified, HRetrieveRecord handles the last data file used by the last function for HFSQL management (starting with the letter H).
<Item Separator>: Optional character string (with quotes)
Character string used to separate the different items in <Result>. The default separator is TAB.
<Array Separator>: Optional character string (with quotes)
Character string used to separate the values of array items (or sub-items) in <Result>. The default separator is TAB.
Caution: for backward compatibility wit WINDEV 5.5, the separators are not indicated when the array items are empty.
<Format>: Optional Integer constant
Format used to return the value of the record. By default, an ANSI format character string is returned. To get a Unicode format string, use the following constant:
hUnicode<Result> is a Unicode character string.
Versions 19 and later
WINDEVWEBDEV - Server codeWindows Mobile

Retrieving the content of a record for the specified Record variable Hide the details

<Result> = HRetrieveRecord(<Record> [, <Item Separator> [, <Array Separator> [, <Format>]]])
<Result>: Character string
Value of the record, in the following format:
<Content of Item 1> + <Item Separator> + <Content of Item 2> +...
The contents of items are extracted according to the physical order of the items in the data file. If the item corresponds to NULL, <Content of Item> corresponds to an empty string ("").
Depending on the specified <Format>, this character string is in ANSI format (default) or Unicode format.
<Record>: Optional Record variable
Name of the Record variable used.
<Item Separator>: Optional character string (with quotes)
Character string used to separate the different items in <Result>. The default separator is TAB.
<Array Separator>: Optional character string (with quotes)
Character string used to separate the values of array items (or sub-items) in <Result>. The default separator is TAB.
Caution: for backward compatibility wit WINDEV 5.5, the separators are not indicated when the array items are empty.
<Format>: Optional Integer constant
Format used to return the value of the record. By default, an ANSI format character string is returned. To get a Unicode format string, use the following constant:
hUnicode<Result> is a Unicode character string.
New in version 19
WINDEVWEBDEV - Server codeWindows Mobile

Retrieving the content of a record for the specified Record variable Hide the details

<Result> = HRetrieveRecord(<Record> [, <Item Separator> [, <Array Separator> [, <Format>]]])
<Result>: Character string
Value of the record, in the following format:
<Content of Item 1> + <Item Separator> + <Content of Item 2> +...
The contents of items are extracted according to the physical order of the items in the data file. If the item corresponds to NULL, <Content of Item> corresponds to an empty string ("").
Depending on the specified <Format>, this character string is in ANSI format (default) or Unicode format.
<Record>: Optional Record variable
Name of the Record variable used.
<Item Separator>: Optional character string (with quotes)
Character string used to separate the different items in <Result>. The default separator is TAB.
<Array Separator>: Optional character string (with quotes)
Character string used to separate the values of array items (or sub-items) in <Result>. The default separator is TAB.
Caution: for backward compatibility wit WINDEV 5.5, the separators are not indicated when the array items are empty.
<Format>: Optional Integer constant
Format used to return the value of the record. By default, an ANSI format character string is returned. To get a Unicode format string, use the following constant:
hUnicode<Result> is a Unicode character string.
WINDEVWEBDEV - Server codeWindows Mobile

Retrieving the content of a record for the specified Record variable Hide the details

<Result> = HRetrieveRecord(<Record> [, <Item Separator> [, <Array Separator> [, <Format>]]])
<Result>: Character string
Value of the record, in the following format:
<Content of Item 1> + <Item Separator> + <Content of Item 2> +...
The contents of items are extracted according to the physical order of the items in the data file. If the item corresponds to NULL, <Content of Item> corresponds to an empty string ("").
Depending on the specified <Format>, this character string is in ANSI format (default) or Unicode format.
<Record>: Optional Record variable
Name of the Record variable used.
<Item Separator>: Optional character string (with quotes)
Character string used to separate the different items in <Result>. The default separator is TAB.
<Array Separator>: Optional character string (with quotes)
Character string used to separate the values of array items (or sub-items) in <Result>. The default separator is TAB.
Caution: for backward compatibility wit WINDEV 5.5, the separators are not indicated when the array items are empty.
<Format>: Optional Integer constant
Format used to return the value of the record. By default, an ANSI format character string is returned. To get a Unicode format string, use the following constant:
hUnicode<Result> is a Unicode character string.
Remarks
  • The content of Binary Memo items is not retrieved but the item separator is present (to avoid a shift).
  • The content of composite keys is not retrieved but the item separator is present (to avoid a shift).
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment