Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for RAD Studio 10.4 (C++ Win64) » Using ElevateDB » Setting Ranges on Tables |
{ // Set to the natural order, which in this case // is the primary key MyTable->IndexName=""; // Set a range from customer 100 to customer 300 MyTable->SetRange(ARRAYOFCONST((100)), ARRAYOFCONST((300))); }
{ // Set to the CustomerName index MyTable->IndexName="CustomerName; // Set a range to find all customers with // a name beginning with 'A' MyTable->SetRangeStart(); MyTable->ColumnByName("CustomerName")->AsString="A"; // This causes the range to only look at // the first column in the current index MyTable->KeyColumnCount=1; MyTable->SetRangeEnd(); // Note the padding of the ending range // values with lowercase z's // to the length of the CustomerName // column, which is 20 characters MyTable->ColumnByName("CustomerName")-> AsString="Azzzzzzzzzzzzzzzzzzz"; // This causes the range to only look at // the first column in the current index MyTable->KeyColumnCount=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 |