How do I access a case from the non-external dictionary

[TudorPopescu]

Hello,

How do I access a case from the non-external dictionary. I have the HBS_REGISTRY_DICT dictionary. I want to access with the function loadcase, forcase, but it is not received, I get the error Invalid function call (external dictionary name expected). Who can help me ?

[aaronw]

When accessing an external dictionary you must add the external dictionary to the project (File > Add Files). Then when you call a function, provide the dictionary name (e.g., HBS_REGISTRY_DICT). If you have any questions take a look at the simple application that I attached which does a look up using an external dictionary.

[TudorPopescu]

About this I know, but I would like to access the data of a case of the same dictionary. For example, 1 case is already finished and completed, the 2nd case is currently being completed. Is there any way to access the data of case 1 from case 2?

[htuser]

@TudorPopescu,

Is there any way to access the data of case 1 from case 2?

it's possible. But, the easiest way is to use SQLQuery (https://www.csprousers.org/help/CSPro/s ... ction.html).
Actual SQLQuery function have some limitations, among others:
a) Can't put the resulsets in an array having more than two or three dimensions;
b) No direct way to put resulsets in a mixed type array (hashmap);
c) Don't support scalar for strings;
But, the new CSPro 8.0 .Sqlite.exec is overcoming most of these limitations.
Hope this help!
Best

[aaronw]

I misread your question. You can try SQLQuery as htuser suggests. Another approach is to load the case from the menu, write the case to external dictionary, open new case, access previous case data using the loadcase function.