Add new record - browse problem

[Kenneth Brody]

On 8/25/2010 11:55 AM, Richard Kreiss wrote:
> I have an @key function which checks for a record before displaying a
> browse.  If the record doesn't exist, the user is prompted to add the first
> record.  If (Y)es then a system command takes them to the file to add a
> record.
>
> My problem is on return, I have:
>
> If:
> Then: lv="CC"&master_code&"99"; sleep "500";goto show_br
>
> Lv is the lookup value with the display in descending order.
>
> When the browse is executed on return from the goto,  I get the no record
> found message. The program then ends.  When the @key function is then
> initiated again, the new record appears.
>
> Any suggestion on how to eliminate this problem would be greatly
> appreciated.

Well, the sleep does nothing except cause a 1/2 second delay, so I don't 
know why it's there.  (Please don't tell me that you're using some O/S or 
network software that is broken, and won't see data written by another 
program until some delay after the write has occurred.  And if you are using 
such a broken system, tell us what it is so we can avoid it.)

Without seeing any of the code actually related to the SYSTEM command or the 
lookup, nor what actually gets added via the SYSTEM comand, all I can say is 
that the lookup key doesn't find any records, and that includes whatever 
record was just added via the SYSTEM command.

-- 
Kenneth Brody