does foxpro allow scripts like the begin..end in oracle 3

[inncoggnitto]

I want to wrap up a bunch of append from and update statements into a script so that they run all at once.

the help for fp does not list begin as a function.

 

[JimWWinter]

Check out help for DO WHILE.

Regards,
Jim

 

[alvechurchdata]

I want to wrap up a bunch of append from and update statements into a script so that they run all at once

I think perhaps Jim has gone one step too far for you. The Fox equivalent of a script is a program. If you put all your commands into a file named myprog.prg then you can run them with DO myprog.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[inncoggnitto]

i am not sure that would work in command sql window

i tried this

begin
update adjust_2 set bi_prev_qt = 0;
update adjust_2 set bi_prev_pr = 0;
update adjust_2 set bi_add_qt = 0;
update adjust_2 set bi_add_pr = 0;
update adjust_2 set bi_ttl_qt = 0;
update adjust_2 set bi_ttl_pr = 0;
end

and i get 'command encountered unrecognized word or phrase'.

not sure what to use in the do while ###

 

[inncoggnitto]

so, geoff

if i save this*************
update adjust_2 set bi_prev_qt = 0;
update adjust_2 set bi_prev_pr = 0;
update adjust_2 set bi_add_qt = 0;
update adjust_2 set bi_ttl_qt = 0;
update adjust_2 set bi_ttl_pr = 0;
****************
as myprog.prg and call from the command line

do myprog.prg it should run?

does foxpro use the ; at the eol like oracle and other sql?

 

[alvechurchdata]

You should be writing the commands in a program, not in the Command Window.

If you type [TT]MODIFY COMMAND[/TT] in the Command Window then the editor will open and you can type your commands:

update adjust_2 set bi_prev_qt = 0
update adjust_2 set bi_prev_pr = 0
update adjust_2 set bi_add_qt = 0
update adjust_2 set bi_add_pr = 0
update adjust_2 set bi_ttl_qt = 0
update adjust_2 set bi_ttl_pr = 0

No begin or end, no semi-colons.

Save your program as myprog.prg then type [TT]DO myprog[/TT] in the Command Window to run it.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[alvechurchdata]

as myprog.prg and call from the command line
do myprog.prg it should run?

We seem to have interleaved messages here.

All I'd add is that you may get a message from Fox asking you where it can find the adjust_2 table.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Stella740pl]

You can either save this as a program and call it, as you said, from the command line, it should run all at once.

Or, alternatively, you can just put your commands in the command window, just the

update adjust_2 set bi_prev_qt = 0
update adjust_2 set bi_prev_pr = 0
update adjust_2 set bi_add_qt = 0
update adjust_2 set bi_add_pr = 0
update adjust_2 set bi_ttl_qt = 0
update adjust_2 set bi_ttl_pr = 0

not begin-end; select with your mouse all the lines at once, right-click on the selection, and choose Execute Selection from the menu that appears. Done.

As for semicolon, Foxpro doesn't require it at the end of the line, only if you have to continue the command on the next line you put semicolon to show that this is not the end.

 

[inncoggnitto]

way cool. thanks to both of you.

it worked in an instant.

merry christmas and happy holidays from texas (whichever you prefer)

 

[alvechurchdata]

merry christmas and happy holidays from texas

Glad it worked and thanks for the kind thoughts. I may be greedy but I intend to have both a merry christmas and a happy holiday.

Geoff Franklin

http://www.alvechurchdata.co.uk