DEFAULTEXT()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to return a file name with a new extension if one does not already exist

Syntax

DEFAULTEXT(<expC1>,<expC2>)

See Also

BASENAME(), DBF(), DEFAULT(), FORCEEXT(), FORCEPATH(), GETENV(), JUSTDRIVE(), JUSTEXT(), JUSTFNAME(), JUSTPATH(), JUSTSTEM(), NDX(), PATH(), SET FULLPATH, SET PATH, SYS()

Description

The DEFAULTEXT() function returns a file name based on <expC1> with a new extension <expC2> if one does not already exist.

Example

open database southwind
use customers
? defaultext(alias(),"dbd")
? defaultext(alias(),"dbt")
? defaultext(alias(),"dbx")