AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • When to use <Source>.Password?
  • Defining a password on a data file
  • Deleting the password defined on a data file
  • Managing passwords (OLE DB and Native Accesses)
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
Defines the password used to create or open a data file. The password is stored and it will be used when opening or creating the data file if no password is specified.
Remarks:
Java JDBC access: This function is not available for databases accessed via JDBC.
Ejemplo
// Open a data file with password and error check
Customer.Password("Password")
IF Customer.CreateIfNotFound() = False THEN
	Error("HFSQL error: " + HErrorInfo())
	RETURN
END
// <Source>.ErrorPassword is used to find out whether the error that occurred is a password error
IF Customer.CreateIfNotFound() = False THEN
	// Error details
	IF HErrorPassword() = True THEN
		Error("Invalid password")
		// Code to retry
	END
END
Sintaxis
<Result> = <Source>.Password([<Password>])
<Result>: Booleano
  • True if the password is saved,
  • False if an error occurred (insufficient memory for example). HError and HErrorInfo return more details about the problem.
<Source>: Tipo de fuente especificada
Name of data file that uses a password.
If the data file is declared with <Source>.DeclareExternal, <Source> corresponds to the name of the data file alias.
<Password>: Cadena de caracteres opcional
Password associated with the data file.
If this parameter is not specified or is an empty string (""), no password is defined for the data file. The password size is not limited.
Novedad versión 2025
Cadenas secretas: Si utiliza el almacén de cadenas secretas, el tipo de cadena secreta utilizado para este parámetro debe ser "ANSI o Unicode string".
Para obtener más información sobre las cadenas secretas y el almacén, consulte Almacén de cadenas secretas.
HFSQL ClassicHFSQL Client/Server HFSQL data file password is case insensitive.
Observaciones

When to use <Source>.Password?

<Source>.Password must be called:
Remarks:

Defining a password on a data file

A data file will be protected by password if:
Note A data file can be password-protected without being encrypted, and vice versa. The password is independent of data encryption. The data encryption must be configured during the file description in the data model editor ("Details" tab).

Deleting the password defined on a data file

To delete a password on a data file, an automatic data file modification must be performed.
To do so, perform a modification in the analysis (modify the size of an item for example). In this case, an automatic data file modification will be proposed when the analysis is generated. You will be able to modify or delete the password associated with one or more data files.
If your data files are already deployed, specify that an automatic data file modification is required when creating the setup program. The password will be deleted or modified.
Attention: if you remove the password from your data files, don't forget to adapt your code.
WINDEVWEBDEV - Código ServidorOLE DBConectores Nativos

Managing passwords (OLE DB and Native Accesses)

The password must be specified in the parameters of the connection.
Clasificación Lógica de negocio / UI: Lógica de negocio
Componente: wd300hf.dll
Versión mínima requerida
  • Versión 25
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 05/12/2024

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