Subject Filter problem
From Charlie <tm@tc.com>
Date Fri, 28 Mar 2025 17:05:55 -0400
Newsgroups dbase.getting-started

I am having a problem filtering this.  I've tried different attempts including params with no luck.

sql
   this.COLLECTION6 = new QUERY(this)
   with (this.COLLECTION6)
      left = 448.0
      width = 64.0
      height = 37.0
      database = form.coindata1
      sql = "SELECT SUM(qty * estv) AS catval FROM COLLECTION"
      active = true
   endwith

variable:
fltr = trim(form.category1.rowset.fields["cat"].value)

one of several attempts at a filter:
form.collection6.rowset.filter = [category ='] + fltr + [']
form.entryfield6.value = form.collection6.rowset.fields["catval"].value

This gives me 'undefined: category'

Any help would be appreciated!