<Source>.ChangeDir (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Multiple changes of directory

Changing the name of data file

Substituting directories

Various

See also

<Source>.ChangeDir (Function)

In french: <Source>.ChangeRep

Not available with this kind of connection

Modifies the access path to a data file (which means the directory where the data file will be used). If the data file is opened when using <Source>.ChangeDir, the data file is automatically closed.
Reminder: By default, the physical file corresponding to the data file described in the analysis is handled in the directory specified in the analysis.
Changes the name of database associated with a table. In this case, the database name specified in the connection properties of table (in the data model editor) is ignored.
To modify the connection parameters of a data file not in HFSQL format, we recommend that you use HDescribeConnection and <Source>.ChangeConnection.

This function operates for the connections to a HFSQL database only.

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.

This function is now available for Android applications (for HFSQL data files).

This function is now available for Java applications.

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 for Android applications (for HFSQL data files).

This function is now available for Java applications.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available for Android applications (for HFSQL data files).

This function is now available for Java applications.

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.

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

Example

// Create the HFSQL Classic Stat data file in
// "C:\Statistics\January"
Stat.ChangeDir("C:\Statistics\January")
Stat.Creation()

// Create the HFSQL Client/Server Stat data file in "\January\"
// This directory is at the root
// of database folder (HFSQL Client/Server connection)
Stat.ChangeDir(".\January\")

// Data file associated with a connection by OLE DB.
// Replace the database that will be used for the "Customers" table
Customer.ChangeDir("C:\Temp\MyTestDB.mdb")
Customer.Creation()
// The "Customers" table was created in the "c:\temp\mytestdb.mdb" database
// The "Customers" table of database ("c:\temp\myinitialdb.mdb") was not modified

Syntax

With HFSQL data files Hide the details

<Result> = <Source>.ChangeDir(<New data file path>)

<Result>: Boolean

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

<Source>: Type corresponding to the specified source

Logical name of HFSQL data file (defined in the analysis).

<New data file path>: Character string (with quotes)

New access path to the data file (up to 260 characters). This path can contain the name of drive and directories, or it can be a relative path.
If the path is a relative path, the "." (or "?") character is used to specify the current directory and the ".." character is used to specify the parent directory.
If this parameter corresponds to an empty string (""), the data file will be handled in the directory specified in the analysis.
No relative path can be used.
The access path to the data file must be relative to the database found on the server. You cannot specify a path outside the database. A WLanguage error occurs when attempting to access data files outside the database. For example:
Valid path:

FileName.ChangeDir("SUBDIR")
//or
FileName.ChangeDir(".\SUBDIR")

Invalid path:

FileName.ChangeDir("C:\DB\SUBDIR")

The new path will be automatically created if it is valid and if it does not exist.
Versions 17 and later
This parameter can correspond to a full path or a path relative to the current directory (returned by fCurrentDir). This parameter is case-sensitive.
Reminder: On iPhone/iPad, an application has the rights to write into its setup directory or into one of its subdirectories.
New in version 17
This parameter can correspond to a full path or a path relative to the current directory (returned by fCurrentDir). This parameter is case-sensitive.
Reminder: On iPhone/iPad, an application has the rights to write into its setup directory or into one of its subdirectories.
This parameter can correspond to a full path or a path relative to the current directory (returned by fCurrentDir). This parameter is case-sensitive.
Reminder: On iPhone/iPad, an application has the rights to write into its setup directory or into one of its subdirectories.

With an OLE DB access or a Native Connector (also called Native Access) Hide the details

<Result> = <Source>.ChangeDir(<New database>)

<Result>: Boolean

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

<Source>: Type corresponding to the specified source

Logical name of table (defined in the analysis).

<New database>: Character string (with quotes)

Access path to database to use (up to 260 characters). In this case, the database name specified in the connection properties of table in the analysis is ignored.
This path can contain the name of drive and directories, or it can be a relative path.
If the path is a relative path, the "." (or "?") character is used to specify the current directory and the ".." character is used to specify the parent directory.
No relative path can be used.

Remarks

Multiple changes of directory

<Source>.ChangeDir can be called several times with different parameters. When the path is redefined several times for the same data file, the last specified path replaces all the other ones.

Changing the name of data file

The <Source>.ChangeDir function only allows to change the path access to the physical data file. To change the physical name of the data file, use function <Source>.ChangeName.

Substituting directories

<Source>.ChangeDir is used to associate a directory with a data file. To substitute a directory for another one, use HSubstDir.

Caution: The directory substitution performed by HSubstDir applies to the directory defined by the function <Source>.ChangeDir. For example:

HSubstDir("C:\Statistics\January", "C:\New\JanStats")
Stat.ChangeDir("C:\Statistics\January")
Stat.Creation // Data file created in C:\New\JanStats

Various

If the ".REP" management is switched on (function HSetREP), the modification of path is saved in the ".REP" file (see management of .REP).
Closing the data file stores the new path but does not store a possible password specified when opening the data file.
<Source>.ChangeDir is equivalent to HAssign available in the earlier versions.
This function can be used when establishing a connection with a HFSQL server. &nbspCaution: The order in which the functions for connecting to an HFSQL Client/Server database are called is important. See Optimizing the connection times to the HFSQL Client/Server databases for more details.
<Source>.ChangeDir can be used with the Native XML Access.

Component: wd260hf.dll