That's also possible, I've never referenced a field name with extra characters so I don't know if it works.
--- On Thu, 6/9/11, Jerry Wolper <[email protected]> wrote: > From: Jerry Wolper <[email protected]> > Subject: Re: [NF] Great presentation on commenting (or not commenting) your > code > To: "ProFox Email List" <[email protected]> > Date: Thursday, June 9, 2011, 4:32 PM > > We have a program that is nearly > 20 years old. In a SQL statment I > > have a line that should read > > > > Where Orig_princ - princ_paid + > adj_princ>50 > > > > but for how long, I don't know, it said > > > > Where > Orig_princ-princ_paid_adj_princ>50 > > ... > > Had I put in database name prefixes, the > compiler would have caught > > the syntax error. Instead, it evaluated > princ_paid_adj_princ to > > zero. I don't know why it didn't call that out > as an undefined > > variable, but it didn't. > > Wasn't it just looking at the first ten characters, which > just happen > to be princ_paid? > > -Jerry > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/profox > OT-free version of this list: http://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. > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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.
