Retrieves a single database value which can be a field or an expression. The arguments passed to the function determine the value to be retrieved. Execution of this function causes any previously retrieved records in the connection object to be overwritten with the new recordset.
CCDLookUp(field, table, where_clause, connection)
Name | Type | Description | Required |
---|---|---|---|
field | string | Name of the database table field to be retrieved or an SQL expression whose value is to be retrieved. | Yes |
table | string | The name of the table from which the value is to be retrieved (SQL JOIN directives are possible). | Yes |
where_clause | string | SQL WHERE clause: the part of the SQL query that states the criteria for selecting the value. | Yes |
connection | cls |
Connection object against which the query will be executed. | Yes |