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.
