Explain function of FOXPRO command "RECALL,PACK,REPLACE,LOCATE,LIST,CHANGE,DISPLAY"?

Answer 1

recall --> recalls records marked for deletion
i.e.
dele all (delets all records)
recall all (recalls all records)

pack --> physically removes the record from dbf marked for deletion
i.e.
use customer
dele all
pack

nothing will be left in the dbf just like a dull brain

replace --> u can update values

replace all basic with 10000

replaces all records with 10000 in basic field

locate ---> locate finds a record
i.e.
use customer
locate for city = 'SA'

the record pointer moves the record wherre 'SA' is found in city
continue
will move to the next matching record

if no matching record found then end of locate scope will come

list

lists out all the records of the currently opened dbf

list off

lists out all the records of the currently opened dbf without recno()

display

displays the current record

there are so many commands in foxpro.

also u can give condition in the above commands

i.e. u can say dele for name = 'SMART'


u are so sweet. u are asking entire foxpro to be taught in yahoo answers.

Answer 2

Ruma....pay attention please...

RECALL
recoverS records marked for deletion
exampl: recall for custno = "ABC"

PACK
destroys all records marked for deletion. These
record can not be recovered anymore.
example: pack nothing else!

REPLACE
allows updates a field with a value
example: replace custno with "ABC"

LOCATE
Searches for a record that acomplish a condition.
If records is not found, End of File flag is on.
example: locate for custno = "ABC"

LIST
Displays table or environment information without pausing the main Visual FoxPro or user-defined window.
example: list custno, company, email, phone, state

CHANGE
Displays fields for editing.
example: change field custno, company, phone, email, state for state = "FL"

DISPLAY
identical to LIST.

Now, you should install foxpro and look for more information of each command. Each one is a world: syntaxes, applications, related commands, etc...

hope that helps you dude! good luck!

Answer 3

Go to MSDN for a list of all foxpro commands.

Here is a direct link to help.

http://msdn2.microsoft.com/en-us/library/dd5f4hyy(VS.80).aspx

Search under the "Commands" option...

This will explain these better than I can, and list nice examples.

Answer 4

What's the magic word.......?