returns the data types of the columns in a record set.
# Metadata
Platforms: desktop, server, mobile OS: mac, windows, linux, ios, android Introduced: 1.1.1 Security: disk, network
# Syntax
revDatabaseColumnTypes(recordSetID)
# Params
- recordSetID : The number returned by the revQueryDatabase function when the record set was created.
# Examples
revDatabaseColumnTypes(the savedCursor of field 1)
if "BLOB" is among the items of revDatabaseColumnTypes(myCursor) then put true into preferQueryBlob end if
# Description
Use the revDatabaseColumnTypes function to find out the data type of a database field.
The possible data types are:
* BIT * CHAR * STRING * WSTRING * BLOB (short for binary large object) * TIMESTAMP * DATE * TIME * DATETIME * FLOAT * DOUBLE * INTEGER * SMALLINT * WORD * BOOLEAN * LONG
You can use the revDatabaseColumnTypes function to find out what kind of data you need to be prepared for. For example, if BLOB is one of the data types, that column is binary file, so you should not attempt to display it in a field.
>*Important:* The revDatabaseColumnTypes function is part of the > Database library. To ensure that the function works in a > standalone application, you must include this > LiveCode custom library when you create your > standalone application. In the Inclusions pane of the > Standalone Application Settings window, make sure both the > "Database" library checkbox and those of the database drivers you are > using are checked.
# Tags
# See
- **keyword:** field - **control structure:** function - **function:** revDatabaseColumnNames, revDatabaseColumnLengths, revDatabaseType - **library:** Database library - **glossary:** LiveCode custom library, return, binary file, record set, Standalone Application Settings, standalone application, column, database field, BLOB