Name: revDatabaseColumnLengths

Type: function

Syntax: revDatabaseColumnLengths(<recordSetID>)

Summary: <return|Returns> the maximum field sizes in a <record set (database cursor)(glossary)>.

Synonyms: revdb_columnlengths

Introduced: 1.1

OS: mac,windows,linux,ios,android

Platforms: desktop,server,web,mobile

Security: disk,network

Example:
revDatabaseColumnLengths(storedSet)

Parameters:
recordSetID: The number returned by the revQueryDatabase function when the record set (database cursor) was created.

Returns: The <revDatabaseColumnLengths> <function> returns a list of maximum lengths, separated by commas.

Description:
Use the <revDatabaseColumnLengths> <function> to find out how large a database field is.

Each item in the <revDatabaseColumnLengths> is the maximum size of a <database field>.

If the operation is not successful, the <revDatabaseColumnLengths> <function> returns an error message that begins with the <string> "revdberr".

>*Important:*  The <revDatabaseColumnLengths> <function> is part of the <Database library>. To ensure that the <function> works in a <standalone application>, you must include this <Revolution custom library|custom library> when you create your <standalone application|standalone>. In the Inclusions section of the General screen of the <Standalone Application Settings> window, make sure the "Database Support" checkbox is checked and the database drivers you are using are selected in the list of database drivers.

Changes:
The revDatabaseColumnLengths synonym was added in version 2.0.

References: string (keyword), Database library (library), Revolution custom library (library), revDatabaseColumnNamed (function), revDatabaseColumnTypes (function), revDatabaseColumnIsNull (function), revDatabaseColumnNumbered (function), Standalone Application Settings (glossary), database field (glossary), standalone application (glossary), record set (database cursor) (glossary), return (glossary), function (control_st)

Tags: database
