<Source>.DeclareExternal (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

See also

<Source>.DeclareExternal (Function)

In french: <Source>.DéclareExterne

Not available with this kind of connection

Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. This data file is opened. To no longer use this file description, call <Source>.CancelDeclaration.

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 Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

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.

Versions 19 and later

This function is now available for Android applications.

This function is now available in Android Widget mode.

This function is now available for Java applications.

New in version 19

This function is now available for Android applications.

This function is now available in Android Widget mode.

This function is now available for Java applications.

This function is now available for Android applications.

This function is now available in Android Widget mode.

This function is now available for Java applications.

This function is available for HFSQL Classic or Client/Server data files only.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

Syntax

Use with an OLE DB access, a Native Connector, HFSQL Client/Server and an existing connection Hide the details

<Result> = <Source>.DeclareExternal(<Alias> , <Connection>)

<Result>: Boolean

True if the operation was performed,
False if a problem occurred. HErrorInfo is used to identify the error.

<Source>: Type corresponding to the specified source

Name of data file in the external database.
This parameter corresponds to the physical name of data file, in relation to the database (extension included). Example: "myfile.fic" (or if the database has subdirectories: ".\directory\myfile.fic").
If the data file is password protected, this password must be specified with <Source>.Password before using <Source>.DeclareExternal.

<Alias>: Character string (with quotes)

Logical name of data file. This name will be used to handle the data file in the current application. This name can also correspond to a Data Source variable.

<Connection>: Character string (with quotes)

Connection to a database. This connection has been defined in the analysis editor or described programmatically with the function HDescribeConnection.

Use with an OLE DB access or a Native Connector Hide the details

<Result> = <Source>.DeclareExternal(<Alias> , <User> [, <Password> [, <Data source> [, <OLE DB provider or Native Connector> [, <Access>]]]])

<Result>: Boolean

True if the operation was performed,
False if a problem occurred. HErrorInfo is used to identify the error.

<Source>: Type corresponding to the specified source

Name of data file in the external database.

<Alias>: Character string (with quotes)

Logical name of data file. This name will be used to handle the data file in the current application.

<User>: Character string

Name of user of the data source.

<Password>: Optional character string

Password of data file to open (if this password exists).

<Data source>: Optional character string

Full path of data source.

<OLE DB provider or Native Connector>: Optional character string

Name of OLE DB provider or one of the following constants:
hNativeAccessAS400 Native AS/400 Connector (optional module)
hNativeAccessDB2 Native DB2 Connector (optional module)
hNativeAccessInformix Native Informix Connector (optional module)
Versions 20 and later
hNativeAccessMariaDB
New in version 20
hNativeAccessMariaDB
hNativeAccessMariaDB Native MariaDB Connector (optional module of WINDEV/WEBDEV)
hNativeAccessMySQL Native MySQL Connector (optional module)
hNativeAccessOracle Native Oracle Connector (optional module)
hNativeAccessPostgreSQL Native PostgreSQL Connector (optional module of WINDEV/WEBDEV)
hNativeAccessProgress Native Progress Connector (optional module)
Versions 16 and later
hNativeAccessSQLAzure
New in version 16
hNativeAccessSQLAzure
hNativeAccessSQLAzure Native SQL Azure Connector (optional module, supplied with Native SQL Server Connector)
Versions 15 and later
hNativeAccessSQLite
New in version 15
hNativeAccessSQLite
hNativeAccessSQLite Native SQLite Connector
hNativeAccessSQLServer Native SQL Server Connector (optional module)
hNativeAccessSybase Native SYBASE Connector (optional module)
hNativeAccessXBase Native xBase Connector
hNativeAccessXML Native XML Connector
hODBC OLE DB provider for ODBC. Used to access an ODBC source declared in the ODBC data sources of Windows
hOledbAccess97 OLE DB provider for Access 97
hOledbAccess2000 OLE DB provider for Access 2000
hOledbAccess2007 OLE DB provider for Access 2007
Versions 19 and later
hOledbAccess2010
New in version 19
hOledbAccess2010
hOledbAccess2010 OLE DB provider for Access 2010
hOledbDBase5 OLE DB provider for dBase 5
hOledbExcel2000 OLE DB provider for Excel 2000
hOledbExcel2007 OLE DB provider for Excel 2007
hOledbExcel97 OLE DB provider for Excel 97
hOledbLotus4 OLE DB provider for Lotus 4
hOledbOracle OLE DB provider for Oracle
hOledbSQLServer OLE DB provider for SQL Server
Caution: To use an OLE DB connection, you must:
install MDAC version 2.6 or later (setup performed by WINDEV/WEBDEV and when creating the client version)
install the OLE DB provider corresponding to the database used.
The available constants are as follows:
hNativeAccessOracle Native Oracle Lite Access (optional module)
hNativeAccessSQLServer Native SQL Server CE Access (optional module)

<Access>: Optional constant

Configures the type of access to the data file.
hOReadWrite
(default value) 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.

Remarks

All the HFSQL functions can be used on the imported data file except for the integrity management.
You can import as many descriptions as necessary.
This function can be used with data files in XML format.
The first syntax of this function cannot be used when accessing a database via Remote access.
To use <Source>.DeclareExternal in a stored procedure:
- the relative path of the data file must be specified in relation to the directory of the database containing the stored procedure. The path must include the name and extension of the data file.
- no connection must be used: the current database on which the stored procedure is found will be used.
By default, if the current project:
- is associated with an analysis, the lock mode applied to the data files is the multi-user mode (the files are not locked when they are opened and they can be accessed by the other applications).
- is not associated with an analysis, the lock mode performed on the data files is the single-user mode: the files are locked in read/write mode as soon as they are opened. This mode prevents the other applications from accessing the files already opened by the current application.

Component: wd260hf.dll