Hi what is the correct way to do the following

I d like to run a query that insert a record in one table in my database, if that is successful I d like to run a second insert query into a second table in the same database.

I am using db_insert for my first query but I d like to know what is the correct way to do this please

Many Thanks

Comments

Jaypan’s picture

I'm not understanding the issue - you can just do one query and then the other.