RevDatabaseType

Returns the type of database associated with a connection.Syntax:

revDatabaseType(<databaseID>)

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

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.

The revDatabaseType function 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 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.

Changes: The revDatabaseType synonym was added in version 2.0.

Parameters:

• databaseID: The number returned by the revOpenDatabase function when the database was opened.
• Returns: The revDatabaseType function returns a string containing up to twoitems (separated by a comma) Item 1 of the string is one of the following values: "MySQL", "ODBC", "Oracle", "PostgresSQL", "SQLite","Valentina".
• Item 2 of the string is empty for all database types except ODBC. If the database type is ODBC then item 2 of the string contains the name of the database system being accessed by the ODBC driver.

See also: revDatabaseColumnTypes (function), revOpenDatabases (function)