If the inhouse DB file is not keyed, you can check to see if there is a logical 
built over it by using F14.  This should bring up a list of the logicals on the 
file or the file itself.  It lists the key fields used.  Once
you have selected a keyed file, you can use the F6 key to position to a 
specific record using the key fields that function key provides.

Good luck.

Paola Groeber
Former MAPICS Business Analyst for CRM applications
Also DBU Guru for over 12 years  :^)
pgroeber@bellsouth.net


aldg wrote:

> Hi Mapics group:
>
> I am trying to edit an inhouse created DB file using DBU.
>
> When I bring up the file and try to go to a specific record using the F1-KEY 
>command, I get an error message, "Function key not allowed."
>
> The DBU help screen for that command says:
>
> "CMD 1-KEY.  Allows a starting key selection on logical or keyed physical 
>files.  If the file has a single record format, the current key is displayed.  
>Partial keys may be used.  Not valid for non-keyed physical files."
>
> What is the difference between a "keyed" and "non-keyed" DB file?
>
> When we create inhouse DB files using Query/400, is the resulting file 
>automatically a "non-keyed" DB file?
>
> Is there any way to convert a "non-keyed" DB file into a "keyed" DB file?  If 
>there isn't a way to do this, I do I use DBU to go directly to a specific 
>record on a very large DB file?
>
> I look forward to your good assistance on this matter.
>
> Regards,
> Al Gershen
> Grants Pass, OR
> aldg@mail.rvi.net
> Aldg's Photos at:
> http://communities.msn.com/AldgsPhotos/
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.