Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

@DbLookUp takes only first content of my key field

Status
Not open for further replies.

emreerhan

Programmer
Jul 7, 2003
1
TR
Hi,
I want to take all documents from names.nsf which are shown in server/Holidays view of a server.
I created a field(its type is dialog list) called CountryName. This field takes Country(HolidayGroup) names from server/Holidays view.This is my key field.

Firstly I want to take their Start Date that was shown in the view's second coloumn.My formula was:

gcc := @DbLookup( "Notes" : "NoCache" ; "server-name" : "names.nsf" ;"Holidays";CountryName; 2) ;
@If (@IsError( gcc ) ; "" ; @Unique(@Text( gcc )) )

In CountryName field I selected three country. And I saw that it works properly.
Then I want to take "RepeatUntil" field that was not replaced in the view. My code was:

gcc := @DbLookup( "Notes" : "NoCache" ; "server_name" : "names.nsf" ;"Holidays(view's name)" ;CountryName ; "RepeatUntil") ;
@If (@IsError( gcc ) ; "" ; @Unique(@Text( gcc ))

I saw that this works for only first element of CountryName Field.I can't take other country's RepeatUntil dates.
Can you Help me?

Emre Erhan

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top