In french: Source
The Property Source
can be used on:
- a Chart control: in this case, the Property Source allows to know the source of the series: Table column, list of values, ...
- a connection: in this case, the Property Source allows:
- Find out the source of a connection (HFSQL Client/Server, OLE DB, ...).
- Define the source of 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: From version 19, HFSQL is the new name of HyperFileSQL.
Finding out the data source of a series Hide the details
<Result> = <Series>.Source
<Result>: Integer constant
Type of data source for the series:
|grTableColumn||The data source is a table column.|
|grCallback||The data source is a WLanguage function.|
|grListBox||The data source is a List Box control.|
|grProgramming||The data source is a list of values.|
|grItem||The data source is a file item.|
|grTable||The data source is an array.|
<Series>: Character string
Series to use. Use the following notation: <Graph name>[<Series number>].
Defining the data source of the connection Hide the details
<Connection used>.Source = <Data source>
<Connection used>: Character string (with or without quotes) or Connection variable
Name of connection used. This name was defined:
<Data source>: Character string
- Name or IP address of the server (for HFSQL Client/Server, SQL Server, Oracle, MySQL, etc.).
- Name of the file used as data source (for Access, XML, xBase, etc.).
The Property Server
is equivalent to the Property Source
These two properties are kept to make the code easier to understand. Indeed, during the connection (HFSQL Client/Server, SQL Server, Oracle, MySQL, etc.), Server
is more appropriate because a server name must be specified.
On the other hand, when connecting Access, XML, xBase, the Property Source makes more sense because it is necessary to indicate a file.
This page is also available for…