Subject Re: ApplyLocate error From Ruth Bromer <ruth@treklite.com> Date Wed, 17 Jul 2019 14:34:06 -0400 Newsgroups dbase.getting-started Ken,  never mind.  I got the 'if' statement working.  I've got other errors, but hopefully I can get them straightened out. Ruth On 7/17/2019 2:26 PM, Ruth Bromer wrote: > I'm not clear on testing in the IDE. Makes sense to be able to go in and > fix things without having to go through the whole process before being > able to make a change. > > However, I know that the input is good. > > It's the 'if' statement to determine of there is an existing record that > just needs quantity to be updated, or if a record needs to be added to > the output table.  I'm in a fix here and I just can't get it to work > even though it works with Mervyn's original program. > > The issue is that I am ordering shirts of colors for myself that I > didn't offer to others and the only way to put them in the input is to > go into the table and add the records at the end, then resort.  The main > difference in what Mervyn has as input is that it is a huge file with a > lot of other fields.  My input is just what I need for the report to the > silk screener who wants my order ASAP. > > Ruth > > On 7/17/2019 1:36 PM, Ken Mayer wrote: >> On 7/17/2019 6:26 AM, Ruth Bromer wrote: >>> Ken, >>> >>> I had put an msg command in the program and all the fields are there >>> and correct.  I guess that's the same as the ? >>> >> >> Yes, it will definitely do the trick, although I was assuming you >> would be testing it in the IDE, so the ? would display the information >> in the Command Window. This would allow you, if there was an error, to >> spend some time examining it, making changes in the code, and go back >> and forth, which you wouldn't be able to do using the msgbox() function. >> >> Just a coding technique from many years of working with the software. >> >> Ken >> >