Start a new topic

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

anonymous

started a topic over 12 years ago

[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

Roger Bjärevall

said over 12 years ago

[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

How can we help you today?

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

anonymous

Roger Bjärevall