Alpha Doc Reference: https://www.alphasoftware.com/documentation/pages/Ref/Api/Namespace/SQL/ResultSet/ToPropertyArray%20Method.xml


dim cn as sql::Connection

dim args as sql::Arguments

dim rs as sql::ResultSet

dim arr[0] as p

cn.open("::name::conn")

vsql = "SELECT * FROM mytable WHERE lastname=:lastname"

args.set("lastname","wood")

cn.execute(vsql,args)

rs = cn.resultset

Rs.toPropertyArray(arr)

cn.close()


for x = 1 to arr.size()

lastname = arr[x].lastname

'do something with this

next