Mike, As I said, it was my fault having "on error *" and if your routine had returned anything not integer then it would have thrown an error!
Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of [email protected] Sent: 11 August 2015 13:25 To: ProFox Email List <[email protected]> Subject: RE: VFP9SP2 pop-up box for nearly everything On 2015-08-11 04:41, Dave Crozier wrote: > Mike, > I'd also give the line: > llOK = this.ExecuteSQL(lcSQL) = 1 > > a look as I think the this could cause you problems if the ExecuteSQL > is returning back a boolean value > > Personally, even though I use it occasionally I am not a fan of in > line assignments and would split it up into two separate assignments. > > In fact VFP seems to return weird results when comparing Boolean > values to integer values, Try the following: > > ncount=9 > ? ">",(ncount=9),">" > > And then > > ncount=.T. > ? ">",(ncount=9),">" > > Look at the output .... the second "?" returns back nothing after the > initial "<" Hi Dave! ExecuteSQL is my function that does the SQLEXEC and returns an integer. [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.

