PhysicalInv is being called from the Main procedure and Main doesn’t open any files except a configuration and security file. When I start the application, the only thing I’m doing is opening PhysicalInv so I know no other procedure is opening the ID database.
I mentioned the “Record Not Available” error because that is the error I get when a Next() is performed on the View the second time PhysicalInv is opened.
The Filename/Owner never changes once the application is initialized.
I put a Status(ID) in the BRW1::Reset Procedure (see below) and it returns 66 (Read/Write + Denynone) in all cases.
BRW1::Reset ROUTINE
IF NOT BRW1::ActiveInvisible THEN
** IF NOT** ?List{PROP:Visible} THEN
** ** BRW1::LoadPending = True
** ** EXIT
END
END
** ** BRW1::LoadPending = False
** ** CLOSE(BRW1::View:Browse)
CASE BRW1::SortOrder
OF 1
** ** IF BRW1::UsingAdditionalSortOrder THEN
** ** BRW1::UsingAdditionalSortOrder = False
** ** BRW1::View:Browse{PROP:Order} = '+UPPER(ID:id_id)'
** ** END
** ** SET(ID:key_id)
OF 2
** ** IF BRW1::UsingAdditionalSortOrder THEN
** ** BRW1::UsingAdditionalSortOrder = False
** ** BRW1::View:Browse{PROP:Order} = '+UPPER(ID:id_altno),+UPPER(ID:id_id)'
** ** END
** ** SET(ID:Key_Altno)
OF 3
** ** IF BRW1::UsingAdditionalSortOrder THEN
** ** BRW1::UsingAdditionalSortOrder = False
** ** BRW1::View:Browse{PROP:Order} = '+UPPER(ID:id_mfgno),+UPPER(ID:id_id)'
** ** END
** ** SET(ID:Key_MFG_No)
OF 4
** ** IF BRW1::UsingAdditionalSortOrder THEN
** ** BRW1::UsingAdditionalSortOrder = False
** ** BRW1::View:Browse{PROP:Order} = '+UPPER(ID:id_class),+UPPER(ID:id_typ),+UPPER(ID:id_id)'
** ** END
** ** SET(ID:Key_class)
OF 5
** ** IF BRW1::UsingAdditionalSortOrder THEN
** ** BRW1::UsingAdditionalSortOrder = False
** ** BRW1::View:Browse{PROP:Order} = '+UPPER(ID:id_id)'
** ** END
** ** SET(ID:key_id)
END
IF ERRORCODE()
**StandardWarning**(Warn:ViewOpenError)
END
** ** OPEN(BRW1::View:Browse)
IF ERRORCODE()
**StandardWarning**(Warn:ViewOpenError)
END
IF Message(Status(id)) Then .
SET(BRW1::View:Browse)
