You can only keep a single DBMS connection open at any time. How do you want to select the particular database connection that should be open at a specific moment? Is it ok to use a specific variable out of a set of (apparently) 500? For example:
Today i'm using ODBC connection.i, have more then 500 connections in a different QVW .(i have more then 500 different customer - each customer have a different DB in a different server - each one have a different QVW)
Each day i need to add another connection in the ODBC. (New Customer)
I want to make it hand-free. so when a new customer is created in the DB i will have the connection details. (there is a table in the DB contain all the customers and their connection details.
I want to make connection string that uses variables with the connection details.
Imagine that your Connection String Table is called 'ConnectionStringTable' and its layout consists of a field DBName and a corresponding field DBConnectionString. Then you can simply define a huge range of variables like this:
FOR i = 0 to NoOfRows('ConnectionStringTable') - 1
LET DBName = peek('DBName', i, 'ConnectionStringTable');
LET DBConnection$(i) = peek('DBConnectionString', i, 'ConnectionStringTable');
LET DBConnection$(vDBName) = peek('DBConnectionString', i, 'ConnectionStringTable');
LET DBName =;
You now have 1000 variables at your disposal to select from, either using a sequence number or a Database name.