Sorry Lew, I just assumed SQL.... I rarely use standard VFP DBF functions these days!
Personally I used to use len() function ... old habits die hard I guess! Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Lew Schwartz Sent: 30 June 2014 17:43 To: ProFox Email List Subject: Re: Column Width in an Age of Varchar The docs say set ansi applied to sql only, but I'm using many of the old dbf functions. -Lew Schwartz On Mon, Jun 30, 2014 at 11:58 AM, Dave Crozier <[email protected]> wrote: > Depends on whether you have Set Ansi ON or OFF > > CLEAR > CREATE CURSOR Dummy (name c(10)) > INSERT INTO Dummy VALUES ("Tommy") > SET ANSI OFF > SELECT * FROM Dummy WHERE name="Tom" INTO CURSOR result > ?"With ANSI",SET("Ansi"),_tally && shows 1 > SET ANSI ON > SELECT * FROM Dummy WHERE name="Tom" INTO CURSOR result > ?"With ANSI",SET("Ansi"),_tally && shows 0 > > Dave > > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Lew > Schwartz > Sent: 30 June 2014 16:52 > To: ProFox Email List > Subject: Column Width in an Age of Varchar > > Is the accepted wisdom for locates, seeks, replaces, ect... now > > padr(cExpression, fsize(cFieldName)) > > as opposed to using len() above, as I think many of us did previously > > ?? > > > -Lew Schwartz > > > --- 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.
