Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for RAD Studio 10.4 (Delphi Win64) » Using ElevateDB » Setting Ranges on Tables |
begin with MyTable do begin { Set to the natural order, which in this case is the primary key } IndexName:=''; { Set a range from customer 100 to customer 300 } SetRange([100],[300]); end; end;
begin with MyTable do begin { Set to the CustomerName index } IndexName:='CustomerName'; { Set a range to find all customers with a name beginning with 'A' } SetRangeStart; ColumnByName('CustomerName').AsString:='A'; { This causes the range to only look at the first column in the current index } KeyColumnCount:=1; SetRangeEnd; { Note the padding of the ending range values with lowercase z's to the length of the CustomerName column, which is 20 characters } ColumnByName('CustomerName').AsString:='Azzzzzzzzzzzzzzzzzzz'; { This causes the range to only look at the first column in the current index } KeyColumnCount:=1; ApplyRange; end; end;
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |