Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio 11 (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 PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |