AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Syntaxes according to the values to convert
  • Using HConvertX (method kept for backward compatibility with WINDEV 5.5)
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
HConvertX (Function)
HFSQL ClassicHFSQL Client/ServerDisponible solo con estos tipos de conexión
Converts a numeric value into a binary string in order to perform a search on a numeric key. It builds a composite key from one or more numeric items.
File description in the data model editor
HBuildKeyValue must be used to perform searches on the composite keys for data files that use "Mode 7" to manage spaces in text items. For more details, see Composite keys.
Advertencia
These functions are kept for backward compatibility to migrate the applications developed in WINDEV 5.5 and WEBDEV 1.5.
Ejemplo
// CompKey is made of PRODREF (text) and QTY (integer)
// EDT_Quantity and EDT_ProductRef are two edit controls
Srch is string
HConvertE(Search, EDT_Quantity)
Srch = Complete(EDT_ProductRef, 8) + Srch
HReadSeek(Orders, CompKey, Srch)
Sintaxis
<Result> = HConvertX(<Text variable> , <Numeric value>)
<Result>: Boolean
  • True if no problem occurred,
  • False if an error occurs. HError is used to identify the error.
<Text variable>: ANSI string variable
Variable to which the conversion result will be assigned. This variable must have a sufficient size and it will be filled with space characters.
<Numeric value>: Numeric variable or numeric value
Value to convert.
Observaciones

Syntaxes according to the values to convert

HConvertC(<string>,<Short integer>)
HConvertD(<string>,<Double real>)
HConvertE(<string>,<Integer>)For backward compatibility with WEBDEV 1.5, this function handles integer_55 on 2 bytes.
HConvertL(<string>,<Long integer>)We recommend that you use HBuildKeyValue.
HConvertM(<string>,<Currency>)
HConvertP(<string>,<Turbo real>)For compatibility with previous versions, this function is identical to HConvertD.
HConvertR(<string>,<Simple real>)
HConvertU(<string>,<Unsigned integer>)For backward compatibility with earlier versions, this function handles integer_55 on 2 bytes.
HConvertV(<string>,<1-byte signed integer>)
Tip If you wish to use the HConvertXfunction, we advise you to use the Convert function, which is easier to handle.

Using HConvertX (method kept for backward compatibility with WINDEV 5.5)

To build the value of a composite key without using HBuildKeyValue, you must:
  • entirely fill the text components with the hMinVal constant.
  • convert the numeric components with HConvert.
Example:
MyCompositeKey = Complete(Customer.LastName, Dimension(Customer.LastName), hMinVal) + ...
Complete(Customer.FirstName, Dimension(Customer.FirstName), hMinVal)
Remarks:
  • The hMinVal constant is equivalent to Charact(0).
  • The hMaxVal constant is equivalent to Charact(255).
For more details on how to use composite keys on filters, see Composite keys and filters.
Componente: wd300hf.dll
Versión mínima requerida
  • Versión 9
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 06/12/2024

Señalar un error o enviar una sugerencia | Ayuda local