dgFail

2018-02-16 Thread Bob Sneidar via use-livecode
Hi all. Given: on mouseUp put the dgDataOfIndex [1] of group "dgPODetail" into aDetailRecord put printKeys(aDetailRecord) into tPrintKeys set the numberFormat to "0.00" put aDetailRecord ["poitemqty"] * aDetailRecord ["poitemunitprice"] into tExtPrice put tExtPrice * (aDetailReco

Re: dgFail

2018-02-16 Thread Bob Sneidar via use-livecode
LC Business Version 8.1.9 Mac OS X 10.13.3 > On Feb 16, 2018, at 09:40 , Bob Sneidar wrote: > > Hi all. > > Given: > > on mouseUp > put the dgDataOfIndex [1] of group "dgPODetail" into aDetailRecord > put printKeys(aDetailRecord) into tPrintKeys > set the numberFormat to "0.00" > put

Re: dgFail

2018-02-16 Thread Bob Sneidar via use-livecode
Also printKeys() is a sqlYoga function. If you don't have it remove those lines and breakpoint at end mouseUp to see the contents of the two array keys. > On Feb 16, 2018, at 09:41 , Bob Sneidar wrote: > > LC Business Version 8.1.9 Mac OS X 10.13.3 > >> On Feb 16, 2018, at 09:40 , Bob Sneidar

Re: dgFail

2018-02-16 Thread Bob Sneidar via use-livecode
I think I just figured it out. Remember our discussion about numberFormat? Remember how the SC variable watcher does not honor the numberFormat?? Well when I call findIndex instead of getting 1, I get 1.00!!! CRAP!!! So now I have to reset numberFormat before calling any DG functions! Bob S