Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem on Refresh after append blank on Master Table.
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00096459
Message ID:
00096635
Views:
14
Thanks Barbara and Ryan,
Finally, as I cannot erase any refresh procedure coding. I fix this problem by:
SELECT Master
APPEND BLANK
GO -1
THISFORM.REFRESH
GO -1
This can ensure the new record is LOCATED b4 use!
Since I need user to 'complete add' (Update before add next),
the recno will be always -1 and then a certain no after tableupdate!
I use buffering 5 because it allow user to UNDO more than one record, but I
need to ensure the adding new record is one-by-one.
So, I change the add_new button to complete_add caption and also the coding
according to this caption! ^_^;

As I have some activate and refresh coding, trace step by step becomes problem.



>Justok,
>Is your problem that the form shows another record, not the appended record? If so, then check if you have SET RELATION TO..... In your refresh, you may be SELECTing the parent record in the relation, and then the child record will be automatically set to the FIRST record, not the one you just appended. Follow the record #s in DEBUG to see if/when they change.
>
>HTH
>Barbara
>
>>First of all, all table are already set the buffer mode to 5.
>>
>>I donno why if I code:
>>
>>Select Master
>>append blank
>>Thisform.Refresh
>>
>>
>>The FOrm will go to an OLD Record and try to overwrite the
>>old record.... the Recno is about Reccount-1 or Reccount-2 !!
>>
>>WHile the Recno() for Blank record is '-1'!
>>
>>Is it because there is a fix link on Order and Orderline??
>>but it work well when append blank in orderline.
>>
>>Why Recno is changed when refresh after append blank in Order ??
>>
>>?_?'
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform