John,

What's probably happening is that your TableUpdate() on lvWorkOrder_Weigh is updating your lvWorkOrder_Weigh_b view. You need to then issue a TableUpdate() on lvWorkOrder_Weigh_b to get it into the table.

I assume you're seeing the update of the first record when adding the second because you're using row buffering on lvWorkOrder_Weigh_b and the access of the first view lvWorkOrder_Weigh is moving the record pointer and firing an update for you.

Dan


>I have two local views:
>
>The first one (lvWorkOrder_Weigh_b):
>
>SELECT Workorder_weigh.key, Workorder_weigh.id,;
> Workorder_weigh.teditstamp, Workorder_weigh.ceditby,;
> Workorder_weigh.taddstamp, Workorder_weigh.caddby,;
> Workorder_weigh.nroll, Workorder_weigh.nweight_roll,;
> Workorder_weigh.nskid, Workorder_weigh.nweight_skid,;
> Workorder_weigh.cseals, Workorder_weigh.cdiameter,;
> Workorder_weigh.cwidth, Workorder_weigh.nslip,;
> Workorder_weigh.ngmmeter, Workorder_weigh.nimpact,;
> Workorder_weigh.ndyne, Workorder_weigh.nopacity, Workorder_weigh.cqcby,;
> Workorder_weigh.cworkorderid, Workorder_weigh.cstatus,;
> Workorder_weigh.dstatus_date, Team.ccode AS cteamcode,;
> Workorder_weigh.cteamid, Workorder_weigh.coperatorid;
> FROM imaflex!workorder_weigh LEFT OUTER JOIN imaflex!team ;
> ON Workorder_weigh.cteamid = Team.id;
> WHERE Workorder_weigh.cworkorderid = ?saleorder_items.cworkorderno;
> AND EVALUATE(?pcFilter) = .T.;
> ORDER BY Workorder_weigh.taddstamp DESC
>
>The second one (lvWorkOrder_Weigh) :
>
>SELECT Lvworkorder_weigh_b.*, Employee.ccode AS cemployeecode,;
> Employee.cfname, Employee.clname;
> FROM imaflex!lvworkorder_weigh_b LEFT OUTER JOIN imaflex!employee ;
> ON Lvworkorder_weigh_b.coperatorid = Employee.id;
> ORDER BY Lvworkorder_weigh_b.taddstamp DESC
>
>When adding a record to lvWorkOrder_Weigh and sending a TABLEUPDATE() to the WorkOrder_Weigh table, the record is not saved. If I add a second record the first addition is saved into the table...
>If I add a third record the second addition know gets saves, and so on....
>
>How do I keep these views and send a proper update the table properly?
>
>I need two views because I need to display the employee name as well as the team for every record of workorder_weigh = > (lvWorkOrder_Weigh)