Re: DBU: Locating a Record Number of a DB File that's Keyed

I usually use the MAPICS dspfile utility for tracking down a records
RRNs. Just "dspfile poitem" and start scrolling, or if you know anything
about what data may be in the particular record it has a handy scan
function.

-Jim 

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Al Gershen
Sent: Tuesday, May 09, 2006 8:40 AM
To: Mapics Mailing List
Cc: Al Gershen
Subject: [MAPICS-L] DBU: Locating a Record Number of a DB File that's
Keyed

Hi group:

How do you locate a particular record number using DBU in a Keyed
Physical DB File, such as POITEM.

In DBU's Help, it says, in part:

------

Record#.  The relative record number of the record displayed.  If the
file is in arrival sequence, you may use this field to retrieve a record
by it's relative record number.  If the file is keyed, this field is
used for display purposes only.

------

POITEM is a Keyed DB File and I can't figure out how to locate a
particular Record in that file.

For example, using DBU, how would I locate Record No.
75,296 in that DB file?

Your comments would be appreciated.




Regards,
Al Gershen
Cost Accountant Lead
ECS Composites
Grants Pass, OR
aldg3@xxxxxxxxx

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com _______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.