Tech-Wonders.com

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

Tech-Wonders.com » How-to Topics

How to Search for Data in FoxPro

Searching for Data in FoxPro:-

The locate command searches the table for the first record, that matters the criteria specified. The locate command option searches sequentially from the top to the end of the table until it finds first record that satisfies the criteria. For example,

Locate for stuname = “Raju” displays Raju in the record pointer.
?found()
T (True)
Disp ↵

StunoStunameFeeCourse
3Raghu2300PGDCA

Continue command can be used to find next occurrence of the condition specified.

Delete command is required when unwanted or obsolete records are to be removed from the table. The desired record is marked for deletion, which sets an internal flag stored in each record in the table. Then the table is packed and marked records are physically removed. For example,

Delete for recono() = 9 displays stuname Ashik of 9 number
List ↵
Pack ↵
Delete for course = “PGDC” ↵
deletes Ashik from the specified course.
List ↵
Recall all ↵
to remove delete. The delete records are manually liable within a table

List ↵
Recall Record 2 ↵
recalls 2nd record only.

Zap command is used to delete all records in a table.

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 Phone Monitoring Can Be Used for Employee Productivity Tracking
    How Phone Monitoring Can Be Used for Employee Productivity Tracking
  • Best Tips for Hiring Globally
    Best Tips for Hiring Globally
  • R&D Tax Credit Software: Research and Development
    R&D Tax Credit Software: Research and Development
  • Top 2023 Security Considerations for the Modern Office
    Top 2023 Security Considerations for the Modern Office
  • Why Cryptocurrency is the Future of Investment: How to Get Started
    Why Cryptocurrency is the Future of Investment: How to Get Started

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