![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for Delphi 7 » Using DBISAM » Setting Ranges on Tables |
begin with MyTable do begin { Set to the primary index } IndexName:=''; { Set a range from customer 100 to customer 300 } SetRange([100],[300]); end; end;
begin with MyTable do begin { Set to the CustomerName secondary index } IndexName:='CustomerName'; { Set a range to find all customers with a name beginning with 'A' } SetRangeStart; FieldByName('CustomerName').AsString:='A'; { This causes the range to only look at the first field in the current index } KeyFieldCount:=1; SetRangeEnd; { Note the padding of the ending range values with lowercase z's to the length of the CustomerName field, which is 20 characters } FieldByName('CustomerName').AsString:='Azzzzzzzzzzzzzzzzzzz'; { This causes the range to only look at the first field in the current index } KeyFieldCount:=1; ApplyRange; end; end;
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |