Hi looking for some guidance. I have a routine where I am trying to find a count of records when a field = a certain value. It is only returning a result of one. when I have seeded the DB with at least 2-3 records in my testing. am I missing something in the statement?
dim sql as string
dim c, count as integer
sql = “select count (*) as count from table where attribute = ‘Active’”
dim rs as RecordSet=APP.name.SQLSelect(sql)
DBdisplay.cell(dbdisplay.lastindex,0) ="Total Active: " + str(count)