add records issue

[Richard D. Williams]

I have see this may times.
The most common cause is there is a screen with no updateable fields. 
You know, all fields have a !.
Then on a menu selection of by looking at that screen during 
Inquire,Update,Add and the user presses "3 - Add records".

Filepro goes immediately inot an update mode, but since no fields are 
available for the cursor, the input table is executed.
Since you're in update mode, another records is adding, there you go. 
You have an endless loop.

I have recently seen this is another way.  The input table had this line;
@wef2 if: @ID eq "root"
        then: end

             if:
        then: escape;end

I deduced the original programmer wanted to keep a user from updating 
this record.
So, whenever any user, except "root", when to a record aand pressed "U - 
Update", BAM!.
Endless loop of adding records.

The solution for the first case is add this line at the top of the input 
table;
if     : @SN eq "5"        (any screen with no available data fields)
then: exit

The solution for the second case is to take a new approach;

@keyU if: @ID ne "root"
        then: end
             if:
        then: screen;end

This also works;
@wef2 if: @ID eq "root"
        then: end

             if:
        then: exit

Hope this helps,

Richard D. Williams


On 4/12/2022 6:09 PM, Cesar Baquerizo via Filepro-list wrote:
> Hi,
>
>   
>
> Has anyone experienced Adding Records, and then fp just continues to add
> blank records over and over again. Break Break needed to get out of it.
>
>   
>
> Yes old version. SCO Unix 6, fp 04.05.00
>
>   
>
> I know it's old. Just trying to find out if anyone has seen this.
>
>   
>
> Thanks
>
>   
>
> Regards
> ---------------------
>
>
>
>
>
>
> ********************************************************************
>
> This message and any attachments are solely for the intended recipient. If
> you are not the intended recipient, disclosure, copying, use or distribution
> of the information included in this message is prohibited. If you received
> this message in error, please notify the sender and permanently delete.
>
>   
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20220412/a3dd0a68/attachment.html>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image001.png
> Type: image/png
> Size: 20179 bytes
> Desc: not available
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20220412/a3dd0a68/attachment.png>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>