> Take a look at EXECSCRIPT() > Before EXECSCRIPT() I used to get the count of lines in a memo field, then read the lines of code in a memo field one at a time and execute them from within my main .prg(s) with &<line of code> until I had processed the last line. I could not handle DO CASE/ENDCASE, IF/ENDIF, or other nesting blocks, but for one off quick coding it worked well.
Once I discovered EXECSCRIPT() (Ed Leafe pointed it out to me) my entire world changed. I could, without any practical limitations, put any valid Fox code in a memo field and execute the entire block of code via EXECSCRIPT(memofieldname). My apps then began to become far more database-centric, where I could tickle out different behaviors with changes in the memo field code without recompiling my core apps. Very cool in my little world where I needed a lot of flexibility for my automated data translation processes, where the source data structure can change from one dealership to another. I never liked the idea of having this kind of custom code in simple .prgs that could be called, as the code in a memo field is less likely to be messed with by a novice. Quick, dirty, simple... Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Charlie Coleman > Sent: Thursday, May 01, 2008 9:30 AM > To: [EMAIL PROTECTED] > Subject: Re: Simple two step query possible in one? > > > > At 09:28 PM 4/30/2008 +0000, Mark Stanton wrote: > > > Is there a reason why it needs to be done in one step? > > > >Because it's in an overnight batch driven from an SQL statement > stored in > >a table. > > Come to think of it, if you're using VFP, you're got a huge amount of > flexibility over SQL. > > Take a look at EXECSCRIPT() > > It's a shame so many are hand-cuffing themselves to those > antiquated SQL DB > Server systems. > > ;-) > > -Charlie > > > [excessive quoting removed by server] _______________________________________________ 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.
