Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 using the Lookup method to return values from multiple columns


How do I use the Lookup method to return values from multiple columns?   

    The result is a variant array -- one index to the array for every column specified in the KeyValues parameter:

    procedure TForm .Button Click(Sender: TObject);
    var
      MyResults: Variant;
      MyKeyFields, MyKeyValues: String;
      MySearchForValue: Integer;
    begin
      MyKeyFields := 'CustNo';
      MySearchForValue :=  35 ;
      MyReturnColumns := 'Company;Addr ';
      MyResults := Table .Lookup(MyKeyFields, MySearchForValue, 
                                MyKeyValues);
        if not VarIsNull(MyResults) then
          ShowMessage('Company: ' + MyResults[0] + '   Address: ' + 
                    MyResults[ ]);
      {  With DBDemos data this returns
        "Company: Sight Diver   Address:   Neptune Lane" }
    end;
    

     



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use