For example, to find all people whose surname starts with "S" you can use something like
Code: Select all
searchstr="S%"
rlt = Conn.Find("people","surname ilike &1",searchstr)
This is just the beginning!
Code: Select all
startdate=date(2000,1,1)
rlt=Conn.Find("people","birthdate < &1",startdate)
It me that I have only discovered this today. I thought that it could only use equality search terms, like "surname = &1".