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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I get the first five documents in the view?

Status
Not open for further replies.

plasma80

Programmer
Mar 4, 2002
9
US
I need to get the first five documents in the view using formula language. I know I can get it thru script but I'm tryin to grab the data from first five documents using dblookup. is that possible?
 
No. @DbLookup will gather info from all documents that correspond to the key criteria passed in the function declaration.
I would suggest either reviewing the view selection criteria, creating another view to do the lookup, or refining the key criteria of the function.
 
temp := @dbcolumn("":""; "":""; "myview"; 1);
first5 := @subset(temp; 5);
first5
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top