HDBSortType (Function)

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

Management of xBase files

See also

HDBSortType (Function)

In french: HDBTypeTri

Available 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:
hDBASCII Sort according to ASCII order.
hDBLexicographic Lexicographic sort.

<Type of Sort>: Constant

Type of sort to use:
hDBASCII
(Default value) Sort according to ASCII order.
hDBLexicographic Lexicographic 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.
hDBLexicographic Lexicographic 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.

Component : wd240hf.dll