Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where did my last item go???
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00064393
Message ID:
00064433
Views:
24
>I created a typical invoice form with line-item (e.g. child recs) in a grid. The form is using optimistic buffering and the grid's populated with parametized local view. With the help of few great UT saviors, it now works great.
>Only one problem: when I add a new invoice, for example, that includes 4 line-item entries to the view, after I save the new invoice and requery the view, the last item (4th item) is not displayed in the grid. If I had 2 line-items, it would show only 1 etc. If I move an invoice rec up or down and come back to the just added invoice, all the line-items show correctly. What's going on? I know I don't have to refresh the form/grid since it already shows the correct data but I'm just curious why it would always leave the last rec out???
>
>TIA
>John.

When you move off a newly added record, TableUpdate() is automatically executed. I would look at the problem being in your Save routine. You should be executing a TableUpdate() on the table that contains your line-items. i.e., make sure a TableRevert() is not being executed from any other method before TableUpdate(). YOu may also (if the LineItem table is not the currectly selected alias) have to include the table name in the TableUpdate(.t.,.t.,"LineItem") command.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform