Toad World® Forums

Want to use Visual Query Builder and "In Clause" Variables?

Hi - a Toad Data Point user recently asked me how they could create a variable in the visual query builder that would take more than one string as a response.... in other words how could they use variables with an IN CLAUSE (specifically with strings). It is not an easy thing to do in the VQB (Visual Query Builder) and there are definite improvements we have planned to make it easier in the future --- but I did make this short (and casual :slight_smile:) video with some effective approaches.

Btw - if you find this kind of quick tutorial helpful, let me know if there are other topics you would like to see.

Very interesting technique. I'll have to see if I have a use case for it.

You did not show the drop down list for In values or Load from file option. Does that mean these are not working? You inferred that some portion was not working but I'm not sure what part and what versions this applies to.