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
WhatsApp submit Email
Prev Article
Next Article
Tags:FoxPro Microsoft database software

Leave a Reply Cancel Reply

Recent Posts

  • The Top 5 Things You’ll Need as a New Homeowner
    The Top 5 Things You’ll Need as a New Homeowner
  • Advanced SEO Tips for WordPress Website to Rank On Google
    Advanced SEO Tips for WordPress Website to Rank On Google
  • How Does a Cellular Signal Booster Work?
    How Does a Cellular Signal Booster Work?
  • How to Find the Best Crypto Gambling Sites: A Guide for Players
    How to Find the Best Crypto Gambling Sites: A Guide for Players

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

RamaRaoBobby 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

  • Poonam on Best Top 10 Marathi Websites and Blogs
  • Jeff Stewart on Best Web Hosting Services to Publish a Blog or Website
  • Jack on How to Unlock Your AT&T iPhone Using Unlock Phone Codes
  • Gavrielle Curry on Major Procurement Issues: How to Fix Them With Technology
  • Pranav Pawar on Best Top 10 Marathi Websites and Blogs

Always Remain in Touch

Subscribe

Copyright © 2022 Tech-Wonders.com