Generate own Querystring or use others RRS feed

  • Question

  • User1906504752 posted


    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?



    Monday, November 17, 2008 9:17 AM


  • User-821857111 posted

    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.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, November 17, 2008 9:25 AM