Fred The help says
PRETEXT eExpression Specifies a character string to insert before each line of the text merge contents between TEXT...ENDTEXT or a numeric expression. -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Fred Taylor Sent: 13 March 2013 16:17 To: [email protected] Subject: Re: Calculating differences between rows. - Code Sample What do you mean - "when the pretext expression is numeric" ? Fred On Wed, Mar 13, 2013 at 9:15 AM, Paul Newton <[email protected]>wrote: > There is nothing in Help about a 255 limit when the pretext expression > is numeric ... > > Paul Newton > > > I'd offer a quick comment that the semicolons are not necessary if > > you use the PRETEXT 15 clause, plus you're that much more ready and > > not having to rewrite this code if you send it against a remote RDBMS > > server. > > > > > As long as your final SQL statement is not longer than 255 characters, > then the PRETEXT 15 is OK. > > > Fred > > > --- StripMime Report -- processed MIME parts --- multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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.
