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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.