Thanks all. I got it working.
Madhavi
From: Greg Woodhouse <[EMAIL PROTECTED]>
Reply-To: hardhats-members@lists.sourceforge.net
To: hardhats-members@lists.sourceforge.net
Subject: RE: [Hardhats-members] look up not working for STATE file
Date: Thu, 16 Jun 2005 13:43:18 -0700 (PDT)
Use FIND^DIC. In the STATE file, the abbreviation (field 1) is indexed
by the "C" cross-reference, so searching on this index only gives:
>>D FIND^DIC(5,,"@;.01;1","P","MA",,"C",,,"ROOT")
>>ZW ROOT
ROOT("DILIST",0)=1^*^0^
ROOT("DILIST",0,"MAP")=IEN^.01^1
ROOT("DILIST",1,0)=25^MASSACHUSETTS^MA
--- Madhavi Bagepalli <[EMAIL PROTECTED]> wrote:
> Is there a way to make fileman do just a single lookup, instead of
> multiple
> lookup?
>
> >From: "Holloway, Thomas (EDS)" <[EMAIL PROTECTED]>
> >Reply-To: hardhats-members@lists.sourceforge.net
> >To: <hardhats-members@lists.sourceforge.net>
> >Subject: RE: [Hardhats-members] look up not working for STATE file
> >Date: Thu, 16 Jun 2005 16:21:08 -0400
> >
> >It's working just fine. You get all entries that either start with
> MA
> >*OR* have the abbreviation MA. FileMan is doing a multiple cross
> >reference look up.
> >
> > tjh
> >
> >
> >-----Original Message-----
> >From: [EMAIL PROTECTED]
> >[mailto:[EMAIL PROTECTED] On Behalf Of
> >Madhavi Bagepalli
> >Sent: Thursday, June 16, 2005 4:10 PM
> >To: hardhats-members@lists.sourceforge.net
> >Subject: [Hardhats-members] look up not working for STATE file
> >
> >Hi all,
> >
> >I am trying to inquire into the STATE file using the ABBREVIATION
> field.
> >I
> >get different results when I use "MA" and "TN" when asked for STATE
> -
> >here
> >is what I get
> >
> >Select OPTION: iNQUIRE TO FILE ENTRIES
> >
> >OUTPUT FROM WHAT FILE: STATE//
> >Select STATE NAME: MA
> > 1 MAINE ME ME
> > 2 MANITOBA MB MB
> > 3 MARSHALL ISLANDS MH MH
> > 4 MARYLAND MD MD
> > 5 MASSACHUSETTS MA MA
> >CHOOSE 1-5:
> >
> >Select STATE NAME: TN TENNESSEE TN
> >ANOTHER ONE:
> >
> >I get Tennessee state info when I use "TN" abbreviation. But, not or
> >Massachusetts. I verified if the AABREVIATION field has a cross
> >reference
> >and it does. My question is why is the cros reference not working
> for
> >look
> >ups?
> >
> >Thanks,
> >Madhavi
> >
> >_________________________________________________________________
> >Don't just search. Find. Check out the new MSN Search!
> >http://search.msn.click-url.com/go/onm00200636ave/direct/01/
> >
> >
> >
> >-------------------------------------------------------
> >SF.Net email is sponsored by: Discover Easy Linux Migration
> Strategies
> >from IBM. Find simple to follow Roadmaps, straightforward articles,
> >informative Webcasts and more! Get everything you need to get up to
> >speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> >_______________________________________________
> >Hardhats-members mailing list
> >Hardhats-members@lists.sourceforge.net
> >https://lists.sourceforge.net/lists/listinfo/hardhats-members
> >
> >
> >-------------------------------------------------------
> >SF.Net email is sponsored by: Discover Easy Linux Migration
> Strategies
> >from IBM. Find simple to follow Roadmaps, straightforward articles,
> >informative Webcasts and more! Get everything you need to get up to
> >speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
> >_______________________________________________
> >Hardhats-members mailing list
> >Hardhats-members@lists.sourceforge.net
> >https://lists.sourceforge.net/lists/listinfo/hardhats-members
>
> _________________________________________________________________
> Don?t just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration
> Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Hardhats-members mailing list
> Hardhats-members@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hardhats-members
>
"The most profound technologies are those that disappear."
--Mark Weiser
====
Greg Woodhouse
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee®
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
