4D v16

DATABASE_PATH

Home

4D - SQL Reference
- Functions
- - SQL Functions
  - ABS
  - ACOS
  - ASCII
  - ASIN
  - ATAN
  - ATAN2
  - AVG
  - BIT_LENGTH
  - CAST
  - CEILING
  - CHAR
  - CHAR_LENGTH
  - COALESCE
  - CONCAT
  - CONCATENATE
  - COS
  - COT
  - COUNT
  - CURDATE
  - CURRENT_DATE
  - CURRENT_TIME
  - CURRENT_TIMESTAMP
  - CURTIME
  - DATABASE_PATH
  - DATE_TO_CHAR
  - DAY
  - DAYNAME
  - DAYOFMONTH
  - DAYOFWEEK
  - DAYOFYEAR
  - DEGREES
  - EXP
  - EXTRACT
  - FLOOR
  - HOUR
  - INSERT
  - LEFT
  - LENGTH
  - LOCATE
  - LOG
  - LOG10
  - LOWER
  - LTRIM
  - MAX
  - MILLISECOND
  - MIN
  - MINUTE
  - MOD
  - MONTH
  - MONTHNAME
  - NULLIF
  - OCTET_LENGTH
  - PI
  - POSITION
  - POWER
  - QUARTER
  - RADIANS
  - RAND
  - REPEAT
  - REPLACE
  - RIGHT
  - ROUND
  - RTRIM
  - SECOND
  - SIGN
  - SIN
  - SPACE
  - SQRT
  - SUBSTRING
  - SUM
  - TAN
  - TRANSLATE
  - TRIM
  - TRUNC
  - TRUNCATE
  - UPPER
  - WEEK
  - YEAR

Home

4D v16

4D - SQL Reference

Functions

DATABASE_PATH



	DATABASE_PATH()

Beschreibung

The DATABASE_PATH function returns the complete pathname of the current database. The current database can be modified using the USE DATABASE command. By default, the current database is the main 4D database.

The pathname returned is in the POSIX format.

Beispiel

Let us suppose that the current external database is named TestBase.4DB and is located in the "C:\MyDatabases" folder. After execution of the following code:

 C_TEXT($vCrtDatabasePath)

 Begin SQL

    SELECT DATABASE_PATH()

    FROM _USER_SCHEMAS

    LIMIT 1

    INTO :$vCrtDatabasePath;

 End SQL

... the $vCrtDatabasePath variable will contain "C:/MyDatabases/TestBase.4DB”.

Siehe auch

CREATE DATABASE
USE DATABASE

Vorige Seite

Nächste Seite

EIGENSCHAFTEN

Produkt: 4D
Thema: Functions

GESCHICHTE

ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v16)

Fehler melden