LiveCode Forums.

Hello,

Database: MySQL

My project is a bit complicate. It always require to execute several SQL queries within a single mouseUp action, for example:


on mouseUp
................................
................................
................................

## SQL Query 1
select * from table1 ...........
.........................................
........................................

## SQL Query 2
UPDATE table2 SET...............
............................................
............................................

## SQL Query 3
INSERT into table3 VALUES ( ........
..................................................
...................................................

end mouseUp


My questions is:

1. What is the best approach to handle this kind of multiple SQL queries with a single mouseUp action?

2. Do I need or better to execute the SQL queries only one with each mouseUp button action. For example:


on mouseUp
send mouseup to btn "SQL Query 1" of this card
send mouseup to btn "SQL Query 2" of this card
send mouseup to btn "SQL Query 3" of this card
end mouseUp



Thanks and best regards