Version: Deprecated Pages

system.db deprecated

caution

These functions exist only for backwards compatibility.

📄️ clearAllNamedQueryCaches

This clears the caches of all Named Queries in a project.

This clears the cache of a Named Query.

This function is used to format Dates nicely as strings.

Exports the contents of a dataset as a CSV file.

Exports the contents of a dataset as an Excel spreadsheet.

Exports the contents of a dataset to an HTML page.

Runs a named query and returns the results.

Runs a SQL query, usually a SELECT query, against a database, returning the results as a dataset.

Runs a query against a database connection just like the runQuery function, but only returns the value from the first row and column.

Runs a named query through the store and forward system and to multiple datasources at the same time.

Runs a query through the store and forward system and to multiple datasources at the same time.

Runs a query against a database connection, returning the number of rows affected.