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
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
