Forum Discussion

NisHera's avatar
NisHera
Valued Contributor
11 years ago

DBTable defined with project variables

I need to store some values in TC DB_Table. to be used in next test item.

I'm selecting values from SQLServer database

My selction is something like 




SELECT DISTINCT [My_Values]


   FROM [My_View]


   where YEAR ='2014' and ( WEEKNO BETWEEN 'X' and 'Y')



What I would like is to pass values for 'X' and 'Y' at run time.

Is it possible to pass project variable to select DB_Table values?



or is there easy way?

1 Reply

  • TanyaYatskovska's avatar
    TanyaYatskovska
    Icon for Alumni rankAlumni
    11 years ago

    Hi Nishnatha,


     


    TestComplete doesn't allow modifying the query from script. We have a corresponding suggestion in our DB - I've increased its rating based on your request.


    A similar question has already been discussed on the forum. You can refer to this thread - it contains several suggestions.