I have the following in a function definition.
sql = 'SELECT column1, column2, column3 FROM table1 WHERE column4 = ?' args = [column4_value] tbl = system.db.runPrepQuery(sql, args, db) return tbl
If my value column4_value exists then this code returns column1, column2, column3 as a dataset with 1 row. However, if column4_value doesn’t exist what is returned from this definition? Is it a dataset with no rows? Can I still call tbl if there are no rows? How can I check if runPrepQuery is returning nothing?