Source (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

InfoThumbnailGeneration

KeyExpression (Example)

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

Equivalence

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Source (Property)

In french: Source

The Source property can be used on:

a Chart control: in this case, the Source property is used to get the source of the 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, the Source property is used to:
- Get the source of a connection (HFSQL Client/Server, OLE DB, etc.).
- 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.

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

Getting the data source of a series Hide the details

<Result> = <Series>.Source

<Result>: Integer constant

Type of data source for the series:
grCallback The data source is a WLanguage function.
grItem The data source is a file item.
grListBox The data source is a List Box control.
grProgramming The data source is a list of values.
grTable The data source is an array.
grTableColumn The data source is a table column.

<Series>: Character string

Series to use. Use the following notation: <Chart name>[<Series number>].

Getting 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 or Connection variable

Name of the 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 or Connection variable

Name of the 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

The Server and Source properties are equivalent.

These two properties are kept to make the code easier to understand. In a connection (HFSQL Client/Server, SQL Server, Oracle, MySQL, etc.), the Server property is more appropriate because it is necessary to specify a server name.

However, in an Access, XML or xBase connection, the Source property is more appropriate because it is necessary to specify a file.