![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio XE7 (C++ Win32) » Using DBISAM » Setting Ranges on Tables |
{ // Set to the primary index MyTable->IndexName=""; // Set a range from customer 100 to customer 300 MyTable->SetRange(ARRAYOFCONST((100)), ARRAYOFCONST((300))); }
{ // Set to the CustomerName secondary index MyTable->IndexName="CustomerName; // Set a range to find all customers with // a name beginning with 'A' MyTable->SetRangeStart(); MyTable->FieldByName("CustomerName")->AsString="A"; // This causes the range to only look at // the first field in the current index MyTable->KeyFieldCount=1; MyTable->SetRangeEnd(); // Note the padding of the ending range // values with lowercase z's // to the length of the CustomerName // field, which is 20 characters MyTable->FieldByName("CustomerName")-> AsString="Azzzzzzzzzzzzzzzzzzz"; // This causes the range to only look at // the first field in the current index MyTable->KeyFieldCount=1; MyTable->ApplyRange(); }
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 ? ![]() |