close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 12 years ago

Last modified 11 years ago

#1692 new enhancement

query DBMS name and version

Reported by: Jorge Owned by: Jorge
Priority: highest Milestone: Mantainance
Component: Database Version: 3.1
Severity: critical Keywords:
Cc: Chakib Faghloumi, Pedro Gea

Description

It is requested the implementation of function to query the name of the DBMS and version.

Text GetDBMSName(Real void);
Text GetDBMSVersion(Real void);
Text GetDataBaseName(Real void);

Change History (8)

comment:1 Changed 12 years ago by Jorge

(In [5900]) refs #1692, implementing function handler for mysql, postgres & odbc.

comment:2 Changed 12 years ago by Jorge

(In [5901]) refs #1692, implement the user functions GetDBMSName, GetDBMSVersion & GetDataBaseName

comment:3 Changed 12 years ago by Jorge

First tests produces results like:

> Text GetDBMSName(?)
"Oracle"

> Text GetDBMSVersion(?)
"11.02.0010"

comment:4 Changed 11 years ago by Pedro Gea

Se sugiere modificar los nombres de estas funciones para hacerlos acorde a las otras funciones globales relacionadas con bases de datos: DB*.

comment:5 Changed 11 years ago by Pedro Gea

El método GetDBMSName no devuelve el mismo identificador para el gestor de base de datos. En el caso de una conexión postgre vía ODBC se obtiene "PostgreSQL" y para una conexión nativa se obtiene "pos".

comment:6 Changed 11 years ago by Jorge

(In [6042]) refs #1692, adopting the naming convention DBxxx

comment:7 Changed 11 years ago by Jorge

(In [6043]) refs #1692, buffer size specification was wrong

comment:8 Changed 11 years ago by Jorge

(In [6044]) refs #1692, return the same name as odbc

Note: See TracTickets for help on using tickets.