Given ANY 'KEY' string value generated by a CapeTool function, you can query for the value of ANY parameter.

The result will be passed back as a range object.

For any parameter queried which is not a range object parameter, a range object of size 1x1 will be returned holding the queried value.

You simply provide the 'KEY' string and the name of the parameter used within the function that created the 'KEY'. Thus if you used the FloatingRateBond() function and later on wanted to know the value entered for the 'IndexKey' parameter, simply enter the key value returned from the FloatingRateBond() function here, along with the string 'IndexKey' (without the single quotes) for the ParamName parameter and the value entered during the construction of the FloatingRateBond() function will be returned as a range object containing a single cell.

This function has a slight processing overhead compared to the QueryLongDB(), QueryDoubleDB(), QueryStringDB() and QueryRangeDB() functions.

However you can query for any parameter regardless of parameter type.

Variant CTQueryDB.QueryAnyTypeDB( _
String Key, _
String ParamName)

=CT.DB.QueryAnyTypeDB(
Excel String Cell Key,
Excel String Cell ParamName)

static CTRangeDataCPP QueryAnyTypeDB(
std::string Key,
std::string ParamName);

CTRangeData CTQueryDBSA.QueryAnyTypeDB(
System.String Key,
System.String ParamName);

The C# example below contains all the sub-function calls leading up to this function call. As a result, the example can contain a lot of code.

The VB.NET, J#, C++.NET, Java, Excel VBA, Visual Basic 6 (via COM) and C++ examples below contain function code stubs for the calls leading up to this function call. However, the function call for this function is displayed.
You can easily reproduce the stub functions code from the C# example.