Source (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

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

Versions 19 and later

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

New in version 19

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

Versions 21 and later

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

New in version 21

This property is now available in Universal Windows 10 App mode for 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 used>..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 used>: Character string (with or without quotes) or Connection variable

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 used>..Source = <Data source>

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

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.