I'm using the following to insert a record in a table:
sql="INSERT INTO table (Order,Quantity) VALUES ('test',10)
How can I find out the db.execute actually added a new record or not.
If the order
is set to Yes(No Duplicate)
it will fail to insert a new record if Order
thanks for any kind of help