I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and dynamic variables, then pass the resulting string to SQLEXECUTE. Very convenient when creating large query strings.
Paul H. Tarver -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, June 27, 2019 2:43 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating Am I missing something about TEXT/ENDTEXT where it just mashes up a string for you for whatever transpires within the loop? What do you do with that output or the textmerge when you are done with it? On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Steve Ellenoff and I were talking the other day about the beauty of > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > Hi VFPers > > > > I have asked this question on foxite too with very little feedback, so > > I am asking it here too. > > > > If you have to summarize the 1 or 2 features of VFP that you will feel > > is a step backwards when migrating to .NET or any other platform as a > > move forwards. > > > > Looking forward to your replies. > > > > Two things that was highlighted on Foxite: > > > > 1. Macro-compilation > > 2. Evaluate(<script>) > > > > From a X# perspective the FOX release already has support for: > > > > 1. DBFCDX and readonly access for VFP specific FieldTypes (AutoInc, > > etc) with full support planned in the foreseeable future; > > 2. WITH/ENDWITH, TEXT/ENDTEXT (partially implemented); > > 3. Macro-compilation; > > 4. Script engine that can make full use of the .NET framework. > > > > XBase greetings, > > > > Johan Nel > > FOX Member: Friends of XSharp > > https://xsharp.info > > George, South Africa > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00e301d52d24$446e9cb0$cd4bd610$@tpcqpc.com ** 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.