Updated on

LimitClauseKind.None (0) is an enumeration that describes the type of limit clause supported by the SQL dialect used by this data source. It is a member of the LimitClauseKind.Type and specifies that this SQL dialect does not support a limit clause.


The Odbc.DataSource function lets you connect to various data sources. Within this function, there’s a parameter named SqlCapabilities. This parameter can be used to specify certain capabilities or modifications to the SQL query being executed.

One of the options you can set within SqlCapabilities is the LimitClauseKind. This kind hasn’t been widely documented.

Here’s a simple example to illustrate the use of LimitClauseKind.None:

  "dsn = your_dsn",
  [ HierarchicalNavigation = true,
    SqlCapabilities = [ LimitClauseKind=LimitClauseKind.None ]

By setting the LimitClauseKind to None, you’re specifying that this SQL dialect does not support a limit clause.

Generally this is done through the user-interface using the navigation pop-up screen that appears when selecting Odbc.DataSource as method to connect.

Learn more about LimitClauseKind.None in the following articles:

Other related enumerations are:

Applies to

Here’s a list of functions that work with LimitClauseKind.Type:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot