>Naomi,
>
>Two separate threads of thought here...
>
>1) If the project.ahcProj.project REPLACE statement fails, I don't think the one for Building will execute. Could that one be failing somehow? Can you separate them into two separate REPLACE statements and see if that works?
>
>2) Try this instead:
>
>REPLACE lastbldg WITH control.lastbldg + 1 IN control
>=tableupdate(.t.,.t.,'Control')
>
>INSERT INTO Building ;
>(Project, Building, kybuilding, state, status, dstatus, unitCount) ;
>VALUES ;
>(ahcProj.project, m.lnNewNO, control.lastbldg, 'NY', 'A', date(), 1)
>
>
>and then continue with checking IF m.lnNewNO > 1 AND ...
>
>HTH.
Thanks, Evan. I found that before thisform.updStatus.ProjStatC(ahcProj.project)
everything is correct and then Building is changing to 1 (I assume the record pointer changes). I need to investigate what exactly is happening here. The updStatus is a custom based class placed on the form.
If it's not broken, fix it until it is.
My Blog