Michael have you tried this: Replace: select * into TABLE &memrand2 from &memrand3 where; payment.acct_id=memacct_id
with: select * into TABLE (memrand2) from (memrand3) where; payment.acct_id=memacct_id It could be the macro substitution that is taking a long time Also you could construct the select statement into a string and then exec() it Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Michael Madigan Sent: 04 September 2013 09:13 To: Pro Fox Email List Subject: Why would this be faster in IDE? If I run this code in a command button while inside the development package it runs quickly If i run it stand alone using the runtime support files, it runs really, really slow. Just this code Any idea why? memacct_id=ALLTRIM(debt.acct_id) memrand3=SYS(2003)+'\payment' memrand2="c:\foxprow\"+SUBSTR(SYS(2015),1,8) SET SAFETY off select * into TABLE &memrand2 from &memrand3 where; payment.acct_id=memacct_id SELECT payment DELETE ALL APPEND FROM &memrand2 SET SAFETY on SELECT debt thisform.refresh [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
