Now, I see. The limit is on the PRETEXT eExpression itself, not on the TEXT/ENDTEXT content. Thanks.
Fred On Wed, Mar 13, 2013 at 9:24 AM, Paul Newton <[email protected]>wrote: > 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/cajcbksrtcj0gvaqnv0ez7rsn+s5jm68eszr4fuexf04dteo...@mail.gmail.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.
