Results 1 to 2 of 2

Thread: Dynamic sql query

  1. 04-25-2011, 12:11 PM #1
    Ayisha
    Ayisha is offline Registered User
    Join Date
    Apr 2011
    Posts
    1

    Dynamic sql query

    Hi! I'm making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference.

    The scenario let's say is...in a form the user can search for records thru 1) university name or 2) between 2 dates 3) through application ids... They can do each of this individualy or 1 n 2 together or 1 n 3 etc. Now instead of writing the sql query for each combination, do you think there is a way i can put in a flag value n get wateva the user wants to search frm n pass that to the where clause?

    Thank you so much!
    Reply With Quote Reply With Quote
  2. 04-25-2011, 02:05 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    It's possible to pass as parameter, but you still need to build that parameter.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules