db.Execute result

I'm using the following to insert a record in a table:

sql="INSERT INTO table (Order,Quantity) VALUES ('test',10)
db.execute (sql)

Select allOpen in new window

How can I find out the db.execute actually added a new record or not.

If the order field's Index is set to Yes(No Duplicate)
it will fail to insert a new record if Order is duplicated




thanks for any kind of help