Tech-Wonders.com

Menu
  • Apps
  • How To
  • Gadgets
    • Mobile
  • Software
  • Technology
  • Sitemap
  • Contact Us

Tech-Wonders.com » Software

Ordering the Record in FoxPro

Ordering the Record in FoxPro:-

Records in a table are arranged in the same order in which they are entered. This arrangement will not be desirable for all applications, specially when the records are to be accessed according to the values in the specified data field. In a table, data can be kept in a required order using one the two methods.

  1. Sorting
  2. Indexing

In the Sorting, the data is physically copied in the desired order to a new table. Whereas in indexing, a separate file is used to provide a reference as to how the record in the original table should be arranged. Syntax is as follow:

SORT on field name to new file name
SORT on stuname to Stu
use Stu ↵
List ↵
SORT on stuname /d to stu (here d = descending order)

Types of Indexing:-

There are two types of indexing

  1. Compound Indexing
  2. Single Indexing file

The Compound Indexing can store many indexes in a single file. The indexes are represented in the same manner as in the single index. In addition this index is given special name TAG. The compound index file have an extension of .CDX

The Single Index file stores a single index file based on a single index expression or key. A Single file has an extension .IDX

Single Indexing file is used for indexing an field name to new file. Set order to new file name.

Seek command is used to determine if the seek seek command was successful and the function found can be used, the function returns a logical value true or false.

Index an stuname tag kanti
Set Order to kanti
Seek “Kanti”
Disp ↵ displays kanti details

Delete single index file command is used to delete file X.IDX whereas Compound delete command deletes compound index files.

Modifying the table structure is also important as there are times when the structure of a table is required to be satisfied, a new field need to be added, or existing fields needed to be deleted. Existing field values also be changed. A field can be moved from one position to another by dragging the field sector, thereby changing the sequence of the fields in the table. Modi command is used display the table structure and modify it like adding new fields an so on.

Tweet
Share
Linkedin
Whatsapp
Reddit
Email
Prev Article
Next Article
Tags:FoxPro Microsoft database software

Leave a Reply Cancel Reply

Ezoic | Increase your site revenue | AI for your ads

Recent Posts

  • How to Convert Apple HEIC to PDF File (5 Best Ways)
    How to Convert Apple HEIC to PDF File (5 Best Ways)
  • Sales Compensation Software: The Key to a Successful Sales Team
    Sales Compensation Software: The Key to a Successful Sales Team
  • Top Objective-C Interview Questions (2023)
    Top Objective-C Interview Questions (2023)
  • Proven Ways to Promote Your Podcast Show & Gain More Listeners
    Proven Ways to Promote Your Podcast Show & Gain More Listeners
  • How Technology is Changing Care for Senior Assisted Homes
    How Technology is Changing Care for Senior Assisted Homes

Categories

  • Apps
  • Big Data
  • Blog
  • Books and Reviews
  • C Programming Language
  • Cars
  • Certifications
  • Chemistry
  • Computers
  • Data Warehousing
  • Ecommerce
  • Electrical
  • Electronics
  • Engineering
  • Entrepreneurs
  • Facebook
  • Featured
  • FinTech
  • Fuzzy Logic
  • Gadgets
  • Games
  • Gmail
  • Google
  • Google Plus
  • Health Tech
  • How-to Topics
  • Infographics
  • Instagram
  • Internet
  • JavaScript
  • Jobs
  • LinkedIn
  • Marketing
  • Mathematics
  • Microsoft
  • Mobile
  • Numismatics
  • Online Earning
  • Pinterest
  • Plagiarism
  • Programming Languages
  • Python Programming Language
  • Real Estate
  • Road Transport
  • Salesforce
  • Science and Technology
  • Security
  • SEO
  • Social Media
  • Social Networking
  • Software
  • SQL
  • Swift Programming Language
  • TikTok
  • Travel
  • Troubleshooting Tips
  • Twitter
  • Web Designing and Development
  • Websites
  • Windows
  • WordPress
  • YouTube Tips and Tricks

Tech-Wonders.com

Technology Blog

About the Admin

RamaRao Bobby Hi there! I am RamaRao Bobby, Founder and Editor-in-Chief of
Tech-Wonders.com, Kakinada’s Top Technology Blog.

I am an avid Dog Lover and Tech Enthusiast. Read More

  • Archives
  • Disclaimer
  • Privacy Policy
  • Featured Comments

Recent Comments

  • Bharat Watane on Best Top 10 Marathi Websites and Blogs
  • Shree Dnyanopasana on Best Top 10 Marathi Websites and Blogs
  • Angela Bordio on 6 Online Resources for Improving Your Job Search
  • Deekshitha on Here’s All You Need To Know About Machine Learning And Why AI Is The Future
  • Akshay Sharma on Scaling Your Cloud Services When Employees Work From Home

Always Remain in Touch

Subscribe

Copyright © 2023 Tech-Wonders.com