Source (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

See also

Source (Property)

In french: Source

..Source can be used on:

a Chart control: in this case, ..Source is used to find out the source of series: Table column, list of values, ...
Remarks:
- grSourceSeries is used to define the data source of series.
- ..SourceDescription is used to find the name and/or the content of data source.
a connection: in this case, ..Source is used to:
- 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 re-opened with the new parameters during the first access to a file that is using this connection.

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

Versions 19 and later

This property is now available in Windows Store Apps mode for the Chart controls.

New in version 19

This property is now available in Windows Store Apps mode for the Chart controls.

Versions 21 and later

This property is now available in Universal Windows 10 App mode for the Chart controls.

New in version 21

This property is now available in Universal Windows 10 App mode for the Chart controls.

Example

IF CHART_MyChart[3]..Source = grTableColumn THEN
// Changes the data source
grSourceSeries(CHART_MyChart, 3, grListBox, "MyList")
END

MyConnection is Connection
// Describe the connection
MyConnection..User = "USER"
MyConnection..Password = "PASSWORD"
MyConnection..Source = "MYSERVER"
MyConnection..Database = "Database"
MyConnection..Provider = hAccessHFClientServer
MyConnection..Access = hOReadWrite
MyConnection..ExtendedInfo = "Extended information"
MyConnection..CursorOptions = hClientCursor

HOpenConnection(MyConnection)

Syntax

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: <Chart name>[<Series number>].

Finding out the source of a connection Hide the details

<Data source> = <Connection name>..Source

<Data source>: Character string

Name 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.)

<Connection name>: Character string (with or without quotes)

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

Defining the data source of the connection Hide the details

<Connection name>..Source = <Data source>

<Connection name>: Character string (with or without quotes)

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

<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.).

Remarks

Equivalence

..Server is equivalent to ..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 contrary, during an Access, XML or xBase connection, ..Source is more appropriate because a file must be specified.