Hi
If I'm running a number of the following SQL update commands
Update customer set LastClosingBalance =? where accountnumber='?' Update customer set LastClosingBalance =? where accountnumber='?'
It is only running one at a time, what is the command I use in between to make sure that they all run at once?
It is running them all but only reporting the results of the most recent query.
Your results of '1 record affected' are simply from the last query. All of the previous queries did run - use a SELECT query to verify if you don't trust me.
Tom
Have something to add? Share your thoughts — no account required.
Ask the community — no account required