some advice again

again thank you for all you help on previous items. again, i have hit the
WALL!!
in your eyes i am not doing anything tough, i just cant seem to think past it.

please advise.

ok, I open a table, get data from it and place it into a new one.
Now I will open the New table, add to fields to it…(2 fields manually) no
big deal..
Open a third table…scan it for the 2 fields, I need and place them in the
proper place. My code is below.

It keeps telling me I have no table open but I do (I thought)


clear all
set default to f:
USE f:\foxpro25\lagers\dbases\lagchk.dbf IN 0 shared
copy to f:\foxpro25\lagers\dbases\forauditors.dbf for checkdte >=
ctod('06/01/04') and checkdte <= ctod('06/01/05')
use f:\foxpro25\lagers\dbases\forauditors.dbf shared
use f:\foxpro25\lagers\dbases\fulagmas.dbf in 0 shared
select 0
set order to PADL(agency,6,"0")+PADL(dpt,3,"0")+PADL(employee,6,"0")
go top
scan
if !eof()
if fulagmas.agency = forauditors.agency and
fulagmas.dpt = forauditors and fulagmas.employee = forauditors.employee

replace forauditors.brthdt with
fulagmas.brthdt, forauditors.benprgflg with fulagmas.benprgflg

endif

endif

endscan







.

Relevant Pages

  • Re: Yellow line
    ... That hit the line. ... It was very tough. ... Vinnie S. ... then you could see it hit the very top of the edge of the wall. ...
    (alt.sports.baseball.ny-yankees)
  • gforth: SDL/OpenGL Graphics Part X
    ... Ray casting is fast because it utilizes some geometric constraints. ... The basic idea of raycasting is as follows: the map is a 2D square ... value (= a wall with a certain color or texture). ... If it is inside a wall (hit) ...
    (comp.lang.forth)
  • Re: A1GP...
    ... >>there is a tractor and marshall access gap in the wall. ... >>> similar to how Greg Moore hit the wall in his fatal accident, ... >>> that it may have hit at an angle where the rear of the car took the ...
    (rec.autos.sport.f1)
  • Re: Fit person start squash - what should I focus on
    ... >I have just started playing squash so I am pretty ... try and get back to the T on the court after each shot you hit. ... there are really 2 goals that a squash serve has. ... to end up fairly close to the back wall. ...
    (rec.sport.squash)
  • Re: [OT] Bye Guys!
    ... no man would ever have hit me more than once - I would have been out of there before he could turn around to land a second blow! ... Husband is so annoyed that his food is not right that he gets hold of his wife by the neck and throws her against the wall. ... (Of course he had no idea how to replace it, so I had to - with him anxiously hovering, afraid there "might be some current left" in the wires, even though I'd pulled the master switch first!) ... However, he knew if he ever hit me, I'd be gone faster than he could say "please stay", so he confined the temper tantrums to mere "sound and fury" and an occasional assault on inanimate objects. ...
    (rec.pets.cats.anecdotes)