revDatabaseType

returns the type of database associated with a connection.

# Metadata

Platforms: desktop, server, mobile OS: mac, windows, linux, ios, android Introduced: 1.1.1 Security: disk, network

# Syntax

revDatabaseType(databaseID)

# Params

- databaseID : The number returned by the revOpenDatabase function when the database was opened.

# Examples

if revDatabaseType(1) is not "odbc" then checkLicense end if

if revDatabaseType(the currentDB \ of group "Display" ) is "Valentina" then sendValQuery else sendGenericQuery end if

# Description

Use the revDatabaseType function to send different queries or perform different operations depending on what kind of database is being used.

You can use the revDatabaseType function to distinguish between different database types. For example, you may need to frame a SQL query differently depending on what type of database you are communicating with.

>*Important:* The revDatabaseType 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

database,

# See

- **control structure:** function - **function:** revDatabaseColumnTypes, revOpenDatabases - **glossary:** LiveCode custom library, Standalone Application Settings, database, standalone application, return, SQL query - **library:** Database library