Hi, When I do custom query in the DBTables, it will return me some records. Is it possible for me to add new record instead of modifying the existing record? Thank you.
There currently is no way to add rows into a DBTables item, at least not that I could find.
A method we used in the past, though, is to not use DBTables but to create an object using the ADODB objects where we would query the table, dump it to a CSV file and then do a comparison of CSV to CSV. You can then easily add rows to the CSV file to update your different scenarios without having to re-query the tables.