If no autoinc value has been updated yet, a NULL value is returned. Specifying STATEMENT returns the last used value for only the current SQL statement. Specifying CONNECTION will return the last used value for the entire connection. Returns the last used autoinc value from an insert or append. If boolean_expr is False, the evaluation of false_expr is returned. If boolean_expr is True, the evaluation of true_expr is returned. If a Visual FoxPro (VFP) table column is NULL, then it is not considered empty (see Null Values ). For DBF tables, a column is considered empty in the traditional Xbase sense (e.g., zero length strings and 0 numeric values are considered empty). For ADT tables, a column is considered empty if it is NULL. Returns TRUE i f the specified column is empty and FALSE otherwise. The value 0 indicates the lowest possible phonetic match, with the values 1, 2, and 3 indicating increasing degrees of phonetic matching. The value 4 indicates the closest match (it actually means that the soundex encoding of str1 and str2 are identical). The value returned will be in the range 0 to 4. Returns an integer value that indicates the difference between the values returned by the SOUNDEX() function for str1 and str2. Returns name of database for the connection. The data-type parameter can be SQL_BINARY, SQL_VARBINARY, SQL_BIT (logical), SQL_VARCHAR, SQL_CHAR, SQL_DATE, SQL_DOUBLE, SQL_INTEGER, SQL_NUMERIC, SQL_TIME, SQL_TIMESTAMP, or SQL_MONEY. Returns the value of expr converted to data-type. It can be any valid character value (including a character field value or expression result), but it must be a character literal or a parameter value in order to be fully optimized. The search condition (second parameter) is given as a character string. This function returns a logical TRUE or FALSE for records that meet the search condition. Performs a full text search on the given field or on all fields that have full text search (FTS) indexes if the asterisk (*) is specified. If all the expressions evaluate to NULL, COALESCE returns a NULL value. No parameters or BLOBs are allowed as an expression type. All expressions must be of the same type or be implicitly convertible to the same type. Returns the first non-NULL expression result. Only SQL_BINARY, SQL_VARBINARY, SQL_VARCHAR, SQL_CHAR, and SQL_NUMERIC support the precision parameter and only SQL_NUMERIC supports the scale parameter. The data-type parameter can be SQL_BINARY, SQL_VARBINARY, SQL_BIT (logical), SQL_VARCHAR, SQL_CHAR, SQL_DATE, SQL_NUMERIC, SQL_DOUBLE, SQL_INTEGER, SQL_TIMESTAMP, SQL_TIME, or SQL_MONEY. Returns the value of expr casted to data-type with an optional precision and scale value. The Application ID can be set and retrieved using the sp_SetApplicationID and sp_GetApplicationID system procedures. The Application ID is initialized to the file name of the application (executable) that connected to the Advantage Database Server (only for ACE based clients). Returns the Application ID of the connection application. Miscellaneous Functions Miscellaneous Functions
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |