Start a new topic

Variables in SQL: given values for the "substitute variables windows"

[This topic is migrated from our old forums. The original author name has been removed]

Hello, I want to make an INSERT statement using variables, so that I get the "substitute variables windows" to type in the values to insert in my table. For some variables, the allowed values can be enumerated, for example like 'NORTH', 'SOUTH', 'WEST', 'EAST'. Can I declare such an enumeration to a variable, so DbVis checks for correct values or even gives me a drop down in the "substitute variables windows"? Is there any feature, that can do the trick? Thanks in advance. I use DbVis Personal 8.0.7.
1 Comment

[This reply is migrated from our old forums.]

Re: Variables in SQL: given values for the "substitute variables windows"
Eha, This is currently not possible but I will add your vote for the feature enhancement. Thanks! Regards Roger