AutoScript
{...................database call examlpe...........}
cust_count = SelectFrom("SELECT COUNT(TITLE) FROM AU_BUSINESS")
call message("customer count=",cust_count)
{............SelectFrom is only for single records (one record) returns...}
cust_name = SelectFrom("SELECT TOP 1 TITLE FROM AU_BUSINESS")
call message("customer name=",cust_name)
{............SelectFrom is a set of concatenations..}
cust_name2 = SelectFrom("SELECT TITLE FROM AU_BUSINESS WHERE (AU_BUSINESS=",47215,")")
call message("customer name 2=",cust_name2)