var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: run multiple sql statements
Hello, a general question, if you have multiple sql statements is there a preferred way to run them, i.e if I have say, sql1, sql2, sql3 is a) or b) best
SQL= sql1 & sql2 & sql3
You cannot run multiple sql statements in Access (you receive an error message stating that caracters were found after the end of the query).
You can do it if you address a SQL server using a pass-through query, though. The problem is that it will me more complex to debug in case of problem and I cannot imagine any gain in doing so.
Have a nice day!
Thanks Sinndho, that answers my question
In other words, A) is your only choice.
Um... You mean you can't do it like B). It can be done with A).
You cannot run multiple sql statements in Access
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
Thanks StarTrekker, I aways appreciate a response to a question, whether it's an answer or a clarification of an answer