PUM-Prodat-SQL
5 years agoNew Contributor
Database connection
Hey guys,
I like to centralize the database connection string to switch fastly between 2 databases.
Does anybody knows how to do this?
I could imagine a solution like creating a string variable containing the connection string at the project suite level in testcomplete and using this variable value to create a dbtable variable at the test items level.
Is this possible in testcomplete?
You can use a function that returns differents ConnectionString with a CASE/OF.
function YourFunction(WichConnection: string): OLEVariant;
begin
case WichConnection of:
'A': result := ConnectionStringA;
'B': result := ConnectionStringB;
end;
end;