Your array will have been created as a local memvar within the script, so it won't be around when the script
finishes. Play around with the parameters idea then
local myarray[1]
execscript(cScript,@MyArray)
HTH
-----Original Message-----
From: profox-bounces .AT. leafe .DO.T com [mailto:profox-bounces@leafe.com] On Behalf Of Joe Yoder
Sent: Friday, November 30, 2007 6:39 PM
To: profox .AT. leafe .DO.T com
Subject: Execscript glitch?
I just coded an SQL select statement using execscript and found it won't create an array. If I substitute
"cursor" for "array" all is well. _Tally after code execution reports the correct value so the SQL apparently
runs but does not create the array. When I use macro substitution the array is created as expected. Does
someone have an explanation for this behavior?
TIA - Joe
Here is the code:
?EXECSCRIPT('select CNT(*),' + m.fldstr +;
" DISTINCT FROM (m.InTbl) WHERE desthop > 0 and not INLIST('out'," +;
m.fldstr + ' ) GROUP BY ' + m.fldstr + ' INTO array Rarray')
?_tally
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
©2007 Lew |
