Source (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage properties / HFSQL properties

Equivalence

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Source (Property)

In french: Source

The Source property can be used on:

a Chart control field field: in this case, the Source property indicates the source of the series: table column, list of values, etc, ...
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 can be 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, when you open a file that uses an open connection, that connection will be closed and reopened with the new parameters.

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 is defined:
in the data model editor,
with the HDescribeConnection and HOpenConnection functions,
with 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 is defined:
in the data model editor,
with the HDescribeConnection and HOpenConnection functions,
with 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.