Start a new topic

Allow the use of user variables in file parameters

Hej


I am aware that I have to use an outdated version of DbVis. I feel, however, that this is a valid use case for the latest one.


I have tried the following code in a script.

 

@echo Run the test query from "${_base_dir||H:/repos/git_nix/IWH_Code_Repository__REGRESSION_TESTS/l_invest_auftrag/||String||noshow}$";
   @run ${_base_dir}$/test_query_001.sql;

which results in

File parameter can only use System variables. File parameter: ${_base_dir}$/test_query_001.sql

I would appreciate if user/custom variables got supported.


Having said that, I also feel it would be nice, one could set variable to values directly and have to take detours by @echo, for example. Possibly, this could be done like

 

@set variable ${_base_dir||H:/repos/git_nix/IWH_Code_Repository__REGRESSION_TESTS/l_invest_auftrag/||String||noshow}$;

 

Varma hälsningar


Thiemo


Hi Thiemo,


This is unfortunately not yet supported. 

We have a task improve the variables and I will lift this up to be prioritized.



Thanks for the suggestion

Ove


1 person likes this

 Allowing user variables in file parameters would greatly enhance flexibility and customization. It’s a feature many would find valuable!


1 person likes this
Login or Signup to post a comment