Deprecated
Data Access Layer (DAL) methods are deprecated. While the existing code keeps working, we recommend switching to Database API.
Executes a SQL query passed as a parameter. Returns the first value of the first entry or null if nothing is found.
Syntax
DBLookup(XVar sql)
Arguments
sql
a SELECT clause. Example: "select * from UsersTable where ID=32".
Return value
Returns the first value of the first entry or null if nothing is found.
Example
Returns the zip value where userid is 25:
XVar zip = tDAL.DBLookup("select zip from carsmake where userid=25");
See also:
