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
---
©2007 Joe Yoder |
