+1 Although I generally only apply HN naming convention to variables only and skip the convention on tables and fields. At most on fields, I'll use a prefix to designate the type of table such as "xref_" for cross reference lookup tables, etc.
Paul H. Tarver Tarver Program Consultants, Inc. Email: [email protected] -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, July 31, 2017 7:16 PM To: [email protected] Subject: Re: GETFILE() Returns Empty String in Some Cases On 2017-07-31 16:04, Ken Dibble wrote: > GAAAAAHHH!!! That's it!! > > Not a PRIVATE declaration, the variable is declared LOCAL. > > But in application mode there is a field in an open table with the > same name as the variable. I applied the "essential m-dot" to the > variable, and that fixed it. That "variable with same name as a field name" has screwed me in the past more than once. That's why I like my "outdated" variable declarations as pcFilename because I definitely don't conflict with MyTable.cFilename. That works for me. Sorry for the purists who see that as horrible. lol [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.

