In the stock table, when deleting selected record(s) by using the 'Clear Selected Lines Only' method, the selected rows are cleared of data except for the 'Vendor Stock Number' column which is overwritten with the "Vendor Stock Number" value of what ever row was active (with the cursor) just before the "Clear Selected Lines Only" was selected.
To reproduce this use the following data in a stock table. Note that all other fields are not affected, so I will not include data for the other columns in order to keep the example simple. Using the "Stock Number" column and the "Vendor Stock Number" column is enough to view the problem.
Fill the table with some sample data like:
- "Stock Num"| "Vendor Stock Num"
________1 | Apple
________2 | Bannana
________3 | Carrot
________4 | Dill
________5 | Eggplant
________6 | FriginMess
________7 | Grapes
The Rows are cleared except for data in the "Vendor Stock Number" column. Not only didn't it clear the data in the last column but the three rows that had records 3,4,5 now show "FriginMess" in their "Vendor Stock Number" column.
After the "Clear Selected Lines Only", this is what the table looks like:
- "Stock Num"| "Vendor Stock Num"
________1 | Apple
________2 | Bannana
_________ | FriginMess
_________ | FriginMess
_________ | FriginMess
________6 | FriginMess
________7 | Grapes
This error can be reproduced and is consistent in its behavior.
I have reproduced this on two different computers; Win2k and WinXP.
I have also created different "store names" to rule out corrupt data files.
Also tested using 6.38 beta2 with same results.
This only occurs when using the menu item "2.Clear selected lines only".
It does not seem to be a problem with the "Delete Selected Lines and Condense" as the selected rows are removed.
At the surface, this is just a "quirky thing" but you may want to make sure nothing is lurking below that may affect data integrity of the stock table or in your code that may be calling this somewhere else with similar results that can't be seen at the UI.
If anyone else can reproduce this please chime in,
thanks Dale,
Bruce