Last post Nov 17, 2008 09:25 AM by Mikesdotnetting
Nov 17, 2008 09:17 AM|Nezdet|LINK
I have created a method that genratos SQLstring. Depending on what values I send in.. I have choosen to do this way cause there are different joins depending on what category the user has choosen..
Can these be done by SQL Procedure?
Nov 17, 2008 09:25 AM|Mikesdotnetting|LINK
Depends on what the SQL you are trying to generate is, but usually, yes. In Access, you can only have one SELECT, INSERT, UPDATE or DELETE statement per saved query (procedure), so you would need to create a number of them and then choose the one that your
code identifies as being the appropriate one givent the values passed in by the user.