SQLCHECKUNIQUE()
From Lianjapedia
Revision as of 13:17, 18 March 2020 by Yvonne.milne (Talk | contribs)
Under Construction
Contents
Purpose
Function to check whether a column value is unique
Syntax
SQLCHECKUNIQUE(<cTable>, <cKeyField>, <cKeyValue>)
See Also
KEYLOOKUP(), LOOKUP(), RLOOKUP(), SEEK(), SET RELATION, SQLLOOKUP()
Description
The SQLCHECKUNIQUE() function checks the uniqueness of a column value. The function will auto-detect if the specified table is a native Lianja table or a Virtual Table and act accordingly.
You should always provide a fully qualified database!table if your app is to work in Web/Mobile e.g "southwind!employees".
Keywords | Description |
---|---|
cTable | Character expression to specify the table to be checked (native or Virtual Table). |
cKeyField | Character expression to specify the column in the table to be checked. |
cKeyValue | Character expression containing the value to be compared against cKeyField. If this is a character field then enclose it in quotes within quotes: " 'string' ". If it is a numeric then enclose it like this "1". |