HOpen (Function)

Note: The opening of data files is managed automatically. However, in some cases, you may have to explicitly open a data file (to check the file existence or the password validity for example).

Versions 15 and later

This function is now available for Android applications.

New in version 15

This function is now available for Android applications.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available in Android Widget mode.

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

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Example

// Opens the Customer file
HOpen(Customer)

// Opens all files whose password is "PSW"
HOpen("*", "PSW")

// Check the status report of HOpen
IF HOpen(Customer, "ABCD", hORead) = False THEN
Error("Unable to open the Customer file" + HErrorInfo())
END

Syntax

<Result> = HOpen([<File name> [, <Password>] [, <Access mode>]])

<Result>: Boolean

True if the data file was opened.
False if a problem occurred (wrong password, ...). HError is used to identify the error. HErrorInfo returns more details.

<File name>: Optional character string (with or without quotes)

Name of data file used (logical name, defined in the analysis). If this name is not specified, HOpen handles the last data file used by the last function for HFSQL management (starting with the letter H).
If this parameter is corresponds to "*", all the data files described in the analysis are opened. If the password is specified, this password will be used to open all the data files.
This parameter can also correspond to the name of a group of files (or custom-folder) defined in the analysis (not available in Android and Android Widget). If the password is specified, this password will be used to open all the data files of the group.
Caution: this parameter cannot correspond to a File Description variable.

<Password>: Optional character string (with quotes)

Password of data file.
If no password is associated with the data file, you have the ability to use an empty string ("").

<Access mode>: Optional integer constant

Configures the access mode to the data file. If this parameter is not specified, the data file will be opened according to its characteristics (if the data file is read-only, it will be opened in read-only ; if the data file is read/write, it will be opened in read/write mode).
hOReadWrite The data file can be accessed in read/write. You have the ability to read the records and to write new records.
hORead The data file can be accessed in read-only. You only have the ability to read the records. No record can be added or deleted.
This parameter is ignored.
This parameter is ignored.

Remarks

Managing the password

The password can be specified:

when the data file is opened by HOpen,
before the data file is opened by HPass.

Creating or opening a data file

HCreationIfNotFound can replace HOpen. Indeed, if the data file exists, it is automatically opened.

Opening a data file that is already opened

If HOpen is used on a data file that is already opened with a different <Access Mode>, the filters, the locks and the characteristics of the current browse are lost.

Managing the list of data files used (.REP)

WINDEV Mobile allows you to update a list of data files used by the application (equivalent to the.REP file in WINDEV).

HOpen fills the list of data files used by the applications (.REP for WINDEV and WEBDEV) if the update is enabled for this list.

See List of data files handled by an application for more details.

Managing fatal errors

If a fatal error occurs when opening a data file, it may be interesting to continue the program while processing the error. To do so, we recommend that you perform the following exception process:

WHEN EXCEPTION IN
HOpen(PARENT)
DO
Error("HFSQL error: " + HError())
ELSE
Trace("File opened")
END

Not available.

Opening a connection and the specified table

HOpen opens (if necessary) the connection to the database before opening the specified table. If the connection is already opened (with the same parameters), this connection is automatically used.

Note: The connection used by default corresponds to the connection associated with the table in the data model editor.

Component : wd240hf.dll