Error getting tags :
error 404Error getting tags :
error 404 revDatabaseColumnTypes | revDocs | RunRev
Welcome Guest (Log in)
Product Edition
Version
revDatabaseColumnTypes
Basics
Expander triangle
Type
Function
Syntax

revDatabaseColumnTypes(recordSetID)

Introduced
1.1.1
Changed
2.0
Environment
Desktop, Web and Server
Platform Support
MacOS,Mac OS X,Windows,Linux
Security
Disk,Network
Summary
Returns the data types of the columns in a record set (database cursor).
Examples

revDatabaseColumnTypes(the savedCursor of field 1)
if "BLOB" is among the items of revDatabaseColumnTypes(myCursor) then
put true into preferQueryBlob
end if

Additional Comments
Expander triangle

Use the revDatabaseColumnTypes function to find out the data type of a database field.

Parameters:

The recordSetID is the number returned by the revQueryDatabase function when the record set was created.

Value:

The revDatabaseColumnTypes function returns a list of data types, one for each column in the record set, separated by commas.

Comments:

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 data, so you should not attempt to display it in a field.

Important! The revDatabaseColumnTypesfunction is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your 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 to Revolution:

The revDatabaseColumnTypes synonym was added in version 2.0.

User Comments
Expander triangle