How to handle multiple MySQL query within a single mouseUp?

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
alex298
Posts: 101
Joined: Mon May 01, 2006 1:17 pm

How to handle multiple MySQL query within a single mouseUp?

Post by alex298 » Fri May 05, 2006 2:58 am

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
Alex
Nice to meet all of you.

Post Reply

Return to “Databases”