>Notice that send updates = .t. and update type is 1
I'm don't understand the significance of this.
>Download the EView from the files section and it will make your life in VIEWS much easier.
Will do.
>I use Mere Mortals, an adaptation of CodeBook.
Good, I use Visual FoxExpress, also based on CodeBook, so we speak the same dialect of VFP.
>The difference I see is that I use a child view differently than you. I am not linking all the child records to all the parents. I am more C/S in that you only return childs on a parent. Change a parent, requery() the child.
>
>This is important in large transaction environments IMHO. So add a vp_ to that view query! " and AITEM.custno = vp_custno"
Seems like I am doing the same thing. I have a global app pointer to the parent account record (goApp.iACCNTS) and the requery() gets only the child records for that parent record.
create sql view lv_AITEMS as ;
select dtoc(AITEMS.tEffective) as dEntered, ;
ITEMS.cItem_Code as cCode, ITEMS.cShort, ;
iif(AITEMS.nDaysDue=0,space(10), ;
dtoc(ttod(AITEMS.tEffective)+AITEMS.nDaysDue)) as dDue, ;
AITEMS.yAmount, AITEMS.lClosed, 000000.00 as yBalance, AITEMS.tEffective ;
from MASS1!AITEMS, MASS1!ITEMS ;
where AITEMS.iITEMS = ITEMS.iITEMS ;
and AITEMS.iACCNTS = ?goApp.iACCNTS ;
and (AITEMS.lClosed = ?goApp.lSeeClosed ;
or AITEMS.lClosed = .f.) ;
order by AITEMS.tEffective
I may have some question for you later if you would be so kind.
Peter
Peter Robinson ** Rodes Design ** Virginia