niblOr


Hi, I've just started work as a data processor and we're using VFP. I have a list of commands that I am to use regularly but I'm not too sure what their exact uses are. I'll give the list of commands and it would be great if some one could explain what each of them do.

set

defa

to

modi

stru

copy

zap

reca

index

select

brow

go

disp

pack

dele

pack

repl

use

thanks...




Re: VFP Commands

Lakshmi N


set defa to

this command will take u to directory that u specify.

eg. set defa to c:\workdir

this will take u to c:\workdir

modi stru will allow u change the structure of a table

eg. u have a table employee.dbf and field empid c 5

now u want to make it c 10 then u can use modi stru

copy command makes a duplicate of your dbf

zap is euvivalent to delete al and pack.

i.e. zap will remove all records of your dbf

recall will recall records marked for deletion.

index will create a index file

eg. index on empid tag empid additive

select (selects a work area)

brow (allows you view, change, add, delete, edit records of your table)

go takes your record pointer to a particular record

go 1001

display (displays current record)

delete (delets (marks a record for deletion) a current record)

pack (physcially removes records marked for deletion)

replace command used to replace values in a table

eg. repl all grade with 'A' for net >= 10000

use followed by filename opens a dbf

use without any filename closes the open dbf

u are asking for entire foxpro to be taught here. it is very difficult. so pls go through some books or MSDN help so that u know basics atleast.







Re: VFP Commands

niblOr

Oh right, well thank's for your help!




Re: VFP Commands

Cindy Winegarden

Hi!

Unfortunately, someone has given you the 4-letter "abbreviations" for the commands, which are much less self-explanatory than the full names. You can find all of these commands in the Help which comes with VFP.