Sybase.Database

This function retrieves a list of SQL tables and views that are accessible in a Sybase database stored on a specified server within the database instance called "database." The server's port can be in...

Syntax

Sybase.Database(server as text, database as text, optional options as nullable record) as table

About

This function retrieves a list of SQL tables and views that are accessible in a Sybase database stored on a specified server within the database instance called "database." The server's port can be included with a colon as an option. Furthermore, an optional parameter named "options" is available to provide control over the following settings: - CreateNavigationProperties: This setting, which defaults to true, determines whether navigation properties should be created for the retrieved values (true/false). - NavigationPropertyNameGenerator: This is a function used to generate names for navigation properties. - Query: The user can input a native SQL query to retrieve data. If the query yields multiple results, only the first result set will be returned. - CommandTimeout: This parameter sets a duration for the length of time the server-side query is permitted to run before cancelation. The default time is ten minutes. - ConnectionTimeout: This parameter specifies a duration for the amount of time to wai

Explanation

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