Trying to create a new SQL Storage map on existing cache Global in the following format - ^MYGLO("R",rec)=data where the 'data' is built using $zel. e.g. $zel(data,1)="p1", $zel(data,2)="p2" etc... and the ^MYGLO("R",123)=data.
I'm having 2 issues. First, using the SQL Storage map wizard, I cannot figure out how to convey data in $zel format in the "Delimiter" field.
.png)
Second, since I couldn't figure that out, I tried to use the "Use Retrieval Code" option and entered the following line for the P1 property:
.png)
but get an error when compiling saying I cannot reference another field:
.png)
So my 2 questions are:
1. How to convey data in $zel format
2. What to add as the main rec ID if using the "Retrieval Code" option
Thank you
