At 2007-12-01 07:04, Lew wrote: >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)
This was my first thought also - but why then would it work using macro substitution? >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >Behalf Of Joe Yoder > >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? > >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 ****************************** * Dan Olsson * <mailto:[EMAIL PROTECTED]> * <http://www.dolittle.se> _______________________________________________ Post Messages to: ProFox@leafe.com 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.
