PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..Connection is used to find out and modify the connection currently associated with a data file.
This connection was defined:
This property can be used for a data file defined in the data model editor or by programming.
Versions 17 and later
iPhone/iPad This property is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone/iPad applications.
iPhone/iPad This property is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Find out the connection currently associated with Customer file
Info(Customer..Connection)
Syntax

Finding out the connection currently associated with a data file Hide the details

<Current connection> = <File name>..Connection
<Current connection>: Character string
  • Name of the connection currently associated with the specified data file.
  • Empty string ("") if no connection is currently associated with the specified data file.
<File name>: Character string (with or without quotes)
Name of data file used. This name was defined in the data model editor or by the File description type.

Modifying the connection currently associated with a data file Hide the details

<File name>..Connection = <New connection>
<File name>: Character string (with or without quotes)
Name of data file used. This name was defined in the data model editor or by the File description type.
<New connection>: Character string or connection
  • Name of the connection to associate with the specified data file.
  • Empty string ("") if no connection is currently associated with the specified data file.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Example Connection
//Conexao Catalogo
ConnCatalogo is Connection
ConnCatalogo..Provider = GPU_01_DbCatalogo.Db_ProviderDatabase
ConnCatalogo..User = GPU_01_DbCatalogo.Db_User
ConnCatalogo..Password = GPU_01_DbCatalogo.Db_Password
ConnCatalogo..Database = GPU_01_DbCatalogo.Db_Database
ConnCatalogo..Server = GPU_01_DbCatalogo.Db_Server
ConnCatalogo..Access = GPU_01_DbCatalogo.Db_Access
ConnCatalogo..Source = GPU_01_DbCatalogo.Db_Source
ConnCatalogo..CacheSize = GPU_01_DbCatalogo.Db_CacheSize

IF HOpenConnection(ConnCatalogo) = true

HChangeConnection("*",ConnCatalogo)

END
BOLLER
07 Apr. 2019