OleDb.DataSource

This function retrieves a table of SQL tables and views from the OLE DB data source specified by the connection string provided in the connectionString parameter. The connectionString can be in text f...

Syntax

OleDb.DataSource(connectionString as any, optional options as nullable record) as table.

About

This function retrieves a table of SQL tables and views from the OLE DB data source specified by the connection string provided in the connectionString parameter. The connectionString can be in text format or as a record of property value pairs, where the values can be text or numeric. Additionally, an optional parameter called options can be provided as a record to specify extra properties. The options record includes fields such as CreateNavigationProperties (which determines if navigation properties should be generated on the returned values, default is true), NavigationPropertyNameGenerator (a function used to create names for navigation properties), Query (a native SQL query used to fetch data, where only the first result set will be returned if multiple are produced), HierarchicalNavigation (a feature to group tables by their schema names, default is true), ConnectionTimeout (duration to wait before abandoning connection attempt, default is driver-dependent), CommandTimeout (duration to cancel server-

Explanation

The record parameter should be defined in the format [option1 = value1, option2 = value2...] or [Query = "select ..."].