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
HDBSortType (Function)
In French: HDBTypeTri
Native AccessesHFSQLAvailable only with these kinds of connection
Returns or modifies the sequence of text items in the xBase files.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
nSortType is int
// Retrieves the sort order
nSortType = HDBSortType()

// Changes the type of sort
SWITCH nSortType
CASE hDBASCII: Info( "ASCII sort" )
CASE hDBLexicographic
  HDBSortType(hDBASCII)
  Info( "Lexicographic sort changed to ASCII sort" )
OTHER CASE
  Info("Error: Unknown sort")
END
Syntax

Modifying the order sequence Hide the details

<Result> = HDBSortType(<Type of Sort>)
<Result>: Constant
Type of sort order used before changing the order:
hDBASCIISort according to ASCII order.
hDBLexicographicLexicographic sort.
<Type of Sort>: Constant
Type of sort to use:
hDBASCII
(Default value)
Sort according to ASCII order.
hDBLexicographicLexicographic sort.

Finding out the order sequence Hide the details

<Result> = HDBSortType()
<Result>: Constant
Type of order currently used:
hDBASCII
(Default value)
Sort according to ASCII order.
hDBLexicographicLexicographic sort.
Remarks
  • This function is not available when accessing a database via Remote Access.
  • This function is not available when using a stand-alone executable.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment