User bio
404 bio not found
Member since Apr 27, 2017
Posts:
Replies:
You need to use the $NAME function set the global variable into local variable to process global names extended global reference dynamically. There is no problem with setting global name in local variable if it's belongs from the current namespace. Use indirection( @ ) operator to do $query,$order,$data string functions and get values from it(Suggest to use $NAME for current namespace global as well) .
USER>set GlobalVar=$NAME(^["IRISMYDEV"]TEST) USER>zwrite @GlobalVar ^["IRISMYDEV"]TEST("a")="Test" ^["IRISMYDEV"]TEST("a","b")="66739,34774" ^["IRISMYDEV"]TEST("a","b","c")="Apple\Orange-Peach#ball\1#0#1#1" USER>set sub=$query(@GlobalVar) for quit:sub="" write sub,! set sub=$Query(@sub) ^["IRISMYDEV"]TEST("a") ^["IRISMYDEV"]TEST("a","b") ^["IRISMYDEV"]TEST("a","b","c")
by using this you can take the values. Check last global reference by using the $zreference function.
Have you tried to pass the provider as a host variable in the query
SELECT ID FROM TestTable WHERE ProviderName = :PROVIDER AND IDType= 'BPI'
Open Exchange applications:
Followers:
Following:
Global Masters badges:







You could add $char(13,10) or $$$NL ( this also refer $c(13,10) ) macro to make a new line
$$$LOGINFO("object: 'This is a try'"_$$$NL_"this is the second line with an example parameter: "_$get(x)_$$$NL_"this is the third line with an example parameter: "_$get(y))