CodeCharge StudioThe RemoteDLookup feature is used to execute a database query from the client-side without reloading the web page.
All forms and controls
| Property | Description |
|---|---|
| Enabled | Specifies whether the feature is active. |
| Name | User assigned name identifying the feature within HTML. |
| Expression | Field or expression to be used in the SELECT clause of the SQL statement to be executed. |
| Domain | Table or view name to be used in the FROM clause of the SQL statement to be executed. |
| Criteria | Criteria to be used in the WHERE clause of the SQL statement to be executed. |
| Connection | Connection from which the database value will be retrieved. |
| Convert result to | Data type to which the retrieved value should be converted. The type specified must comply with the nature of the value to be retrieved i.e. a string cannot be converted to an integer. The possible data types are Text, Integer, Float, Date, Boolean and Memo. |
| Start event | Client event or condition that starts the execution. |
| Target Name | Name of the variable which will receive the retrieved database value. |
| Type Of Target | Type of variable which will receive the retrieved database value [Control, variable, expression, session, application, cookie]. |
| Control Property | HTML atribute of the Control (value, innerHtml, etc.) |
