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 <da...@flexipol.co.uk> 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:profox-boun...@leafe.com] 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: 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: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAFuU78fNoWdgQAz+bF=pzqtyj1v5tzk_bym6mm+s0mtsr3a...@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.
