PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • Equivalence
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..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, ...
    Notes:
  • a connection: in this case, ..Source is used to:
    • Find out 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 re-opened with the new parameters during the first access to a file that is using this connection.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
WEBDEV - Server codeAjax
IF CHART_MyChart[3]..Source = grTableColumn THEN
        // Changes the data source
        grSourceSeries(CHART_MyChart, 3, grListBox, "MyList")
END
WEBDEV - Server codeAjaxHFSQL Client/ServerOLE DBNative Connectors (Native Accesses)
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
WEBDEV - Server codeAjax

Finding out the data source of a series Hide the details

<Result> = <Series>..Source
<Result>: Integer constant
Type of data source for the series:
grTableColumnThe data source is a table column.
grCallbackThe data source is a WLanguage function.
grListBoxThe data source is a List Box control.
grProgrammingThe data source is a list of values.
grItemThe data source is a file item.
grTableThe data source is an array.
<Series>: Character string
Series to use. Use the following notation: <Chart name>[<Series number>].
WEBDEV - Server codeAjaxHFSQL Client/ServerOLE DBNative Connectors (Native Accesses)

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:
WEBDEV - Server codeAjaxHFSQL Client/ServerOLE DBNative Connectors (Native Accesses)

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:
<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
WEBDEV - Server codeAjaxHFSQL Client/ServerOLE DBNative Connectors (Native Accesses)

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.
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment