XE Who's who (phone) search

Frosty the Coder

Legendary Poster
XE Who\'s who (phone) search

An XE site wants to be able to key a PHONE# (or leading characters of
a phone#) and bring up matching Who's Who records.

The specs suggest using the P01800 (Addr Book Name Search) via a
form interconnect and forcing the phone# (or leading digits) into the QBE.
However, this app is NOT based on a bsvw that has the phones available
to it and that prevents the QBE.

I also looked at P0111S (Who's Who Search Select), this does not
have phone#s available to it.

There IS a bsvw (V0111C) which is made up of F0111 and F0115,
but I can't seem to find a Search/Select based on this.

IS there an existing JDE Search/Select, or bsfn that allows for a
PHONE SEARCH, or do I need to code custom to create this


Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP13


Legendary Poster
Re: XE Who\'s who (phone) search

Hi Gene,
I think so that not a complicated task to create a new BSVW for your need and create a custom form (APPL) based on it as Search and Select or Find/Browse to accomplish the task exactly you wish if you have a minimum experience in BSVW and FDA designer tools.
Maybe you will need to define a new index over the phone number in F0115 for better perfomance.


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)