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.

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

Leave a Reply

Cancel reply

Related Posts

  • How to Uncover Hidden Game in Microsoft Excel 2000 1
    How to Uncover Hidden Game in Microsoft …
  • Making a Folder Invisible Without Hiding
    Making a Folder Invisible Without Hiding
  • Edit Audio Files and Create Your Own Ringtone with AUDACITY
    Edit Audio Files and Create Your Own …
  • VeriShow – Multimedia Live Help and Web Meeting Platform
    VeriShow – Multimedia Live Help and Web …

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

Recent Comments

  • Vivek Kumar on 10 Local SEO Services Tips that Deliver Better Results
  • Khushi Patel on The Ultimate Guide to Magento Hosting

Categories

Always Remain in Touch

  • Archives
  • Disclaimer
  • Privacy Policy
  • Featured Comments
Copyright © 2021 Tech-Wonders.com