AutoScript
{.................parametrized database example...........}
name = Input("Inpuut Form","Give Name","%")
start_sql "*" "KOSMOS"
SELECT AU_CONTACT, DISP_NAME, FIRSTNAME
FROM AU_CONTACT
WHERE (FIRSTNAME LIKE :N & "%")
end_sql
q = QueryByName()
call TSetParam(q,"N",name)
call TExecute(q)
count = TRecordCount(q)
call message("CONTACT ID, DISP_NAME, NAME")
call TFirst(q)
for i = 1 to count
id = TGetFld(q,"AU_CONTACT")
name = TGetFld(q,"DISP_NAME")
first = TGetFld(q,"FIRSTNAME")
call message(id,", ",name,", ",first)
call TNext(q)
next
call FreeEmbSQL(q)