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
---
_______________________________________________
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/CAFuU78fTPRpJso3QJ8sX9cUxANu_6X_L1Cb6TmxoPgH1KPGfMQ@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.
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-bounces@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/18725B8CD2D5D247873A2BAF401D4AB22A5223E0@EX2010-A-FPL.FPL.LOCAL
** 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.
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 <DaveC@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-bounces@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_aw@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.
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:profox-bounces@leafe.com] 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 <DaveC@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-bounces@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/18725B8CD2D5D247873A2BAF401D4AB22A522562@EX2010-A-FPL.FPL.LOCAL
** 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.