PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
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
Database (Property)
In french: BaseDeDonnées
ODBCHFSQLNot available with these kinds of connection
The Property Database allows to manage the database associated with a connection (HFSQL Client/Server, OLE DB, ...). You can:
  • Find out the database associated with a connection (HFSQL Client/Server, OLE DB, etc.).
  • Define the database associated with a connection (HFSQL Client/Server, OLE DB, etc.). In this case, if the connection is currently opened, it will be closed and reopened with the new parameters during the first access to a file that uses this connection.
Remark: The connection can correspond to:
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.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
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
MyConnection is Connection
// Describe the connection
MyConnection.User = "USER"
MyConnection.Password = "PASSWORD"
MyConnection.Server = "MYSERVER"
MyConnection.Database = "Test"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
MyConnection.CursorOptions = hClientCursor
 
HOpenConnection(MyConnection)
Syntax

Finding out the database associated with a connection Hide the details

<Associated database> = <Connection>.Database
<Associated database>: Character string
  • Database used as data source for the connection.
  • Empty string ("") if no specific database is associated with the connection.
<Connection>: Name or Variable type Connection
Name of connection used. This name was defined:
WindowsLinuxUniversal Windows 10 AppUser code (UMC)

Defining the database associated with a connection Hide the details

<Connection>.Database = <New associated database>
<Connection>: Name or Variable type Connection
Name of connection used. This name was defined:
<New associated database>: Character string
  • Database used as data source for the connection.
  • Empty string ("") if no specific database is associated with the connection.
Remarks
The Property CtInitialCatalog allows to know the database by Default of a connection. This property is kept for backward compatibility. It is recommended to use the Database property.
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment