Article ID: 104342
Article Last Modified on 3/10/2005
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft FoxPro 2.6a Standard Edition
- Microsoft FoxPro 2.6a Standard Edition
This article was previously published under Q104342
SUMMARY
The Microsoft FoxPro Connectivity Kit can be used with FoxPro versions 2.5x for MS-DOS and Windows. The FoxPro Connectivity Kit, and the Open Database Connectivity (ODBC) specification in general, supports the minimum ANSI SQL standard. Below is a list of the SQL System functions that are supported.
In FoxPro 2.6x and Visual FoxPro 3.0, the Connectivity Kit is included in the Professional Edition.
MORE INFORMATION
The following table lists the supported System functions.
Parameter arguments denoted as <exp> can be the name of a column, the result of another scaler function, or a literal, where the underlying data type could be represented as SQL_NUMERIC, SQL_DECIMAL, SQL_TINYINT, SQL_SMALLINT, SQL_INTEGER, SQL_BIGINT, SQL_FLOAT, SQL_REAL, SQL_DOUBLE, SQL_DATE, SQL_TIME, or SQL_TIMESTAMP.
Parameter arguments listed as <value> can be a literal constant, where the underlying data type can be represented as SQL_NUMERIC, SQL_DECIMAL, SQL_TINYINT, SQL_SMALLINT, SQL_INTEGER, SQL_BIGINT, SQL_FLOAT, SQL_REAL, SQL_DOUBLE, SQL_DATE, SQL_TIME, or SQL_TIMESTAMP.
Values returned are represented as ODBC data types.
Function Description
--------------------------------------------------------------------
USER() Returns the user's authorization name. (The
user's authorization name is also available via
SQLGetInfo by specifying the information type
SQL_USER_NAME.)
DATABASE() Returns the name of the database corresponding
to the connection handle (hdbc). (The name of
the database is also available via SQLGetInfo
by specifying the information type
SQL_DATABASE_NAME.)
IFNULL(exp,value) If <exp> is null, <value> is returned. If <exp>
is not null, <exp> is returned. The possible
data type(s) of <value> must be compatible with
the data type of <exp>.
Following is an example of how the USER() function could be used from within FoxPro to return the user's authorization name. This example assumes that a valid connection to an ODBC data source has already been established and that the connection handle is contained in the variable mhand:
FoxPro 2.x Example
result=DBEXEC(mhand, "SELECT {FN USER()}","output")
Visual FoxPro Example
result=SQLEXEC(mhand, "SELECT { FN USER() }", "output")
REFERENCES
Microsoft Open Database Connectivity Software Development Kit (SDK) "Programmer's Reference," version 1.0, page 530
Additional query words: FoxWin FoxDos VFoxWin CK 2.50 2.50a 2.50b 2.60 2.60a
Keywords: KB104342
