CapeTools QueryDB

CapeTools QueryDB

Welcome | Documentation format | QuantTools Groups | QuantTools Categories | Licence

http://www.QuantTools.com

In total there are 16 functions present within the CapeTools QueryDB category of functions.

General Description

Functions to write a range or ranges of data (Excel range or the API version of a range) to an XML file and to read these back in again.

Functions to write a range or ranges of data (Excel range or the API version of a range) to memory and to read these back in again.

Given ANY object generated string-key generated via a CapeTools function, you can query for a parameter value or the list of parameter names and types that were used when the function was called.

Functions to list or delete created objects via the object generated string-keys.

Function list.

DeleteAllObjects - Purges all user objects created within the library.
DeleteObject - Given ANY 'KEY' string value generated by a CapeTool function, you can request for the object to be marked for deletion from memory.
QueryAnyTypeDB - Given ANY 'KEY' string value generated by a CapeTool function, you can query for the value of ANY parameter.
QueryDoubleDB - Given ANY 'KEY' string value generated by a CapeTool function, you can query for the value of ANY double (numeric double) parameter.
QueryFunctionParamsDB - Given ANY 'KEY' string value generated by a CapeTool function, you can query for the list of parameter names and types (two-column output).
QueryLongDB - Given ANY 'KEY' string value generated by a CapeTool function, you can query for the value of ANY long (numeric integer) parameter.
QueryRangeDB - Given ANY 'KEY' string value generated by a CapeTool function, you can query for the value of ANY range object parameter.
QueryStringDB - Given ANY 'KEY' string value generated by a CapeTool function, you can query for the value of ANY string parameter.
ReadXLRange - Reads an Excel range from a XML file.
ReadXLRange2 - Reads a range object from an XML file that contains multiple range objects (Up to 15 range objects) written via the function WriteXLRange2().
ReadXLRange3 - Reads a range object from an XML file that contains several serialised range objects (Up to 7 range objects) written previously via the function WriteXLRange3().
RetreiveAllObjKeys - Retrieves a list of all the user object keys created within this library.
WriteXLRange - Writes a single range object to a XML file.
WriteXLRange2 - Writes a series of range objects to a single XML file (Up to 15 range objects).
WriteXLRange3 - Writes a series of range objects to a single XML file (Up to 7 range objects).
XLRangesToMemory - Stores a series of XL ranges to memory under a single handle.