S
Simon L. Prinsloo
Guest
1) It would definitely be nice to get insight over the bracketing information. For instance, the selected index may look like a good index, but still bracket too wide (e.g. only the first component instead of the first three). 2) Indicate when the lock state of a record changes, what it changes to and why. Examples: REPEAT: PROMPT-FOR Customer.CustNum. FIND Customer EXCLUSIVE-LOCK USING CustNum. DISPLAY Customer.Name. UPDATE CreditLimit. FIND CURRENT-CUSTOMER NO-LOCK. FOR EACH Order OF Customer: DISPLAY Order.Total - Order.Paid. END. END. Line 3: LOCK Customer EXCLUSIVE, Explicit Line 7: LOCK Order SHARE, Implicit Line 9: RELEASE Order, Implicit Line 19: RELEASE Customer, Implicit. DO TRANSACTION: FIND CURRENT Invoice EXCLUSIVE-LOCK. UPDATE Invoice.Terms. END. Line 2: LOCK Invoice EXCLISIVE, Explicit Line 4: LOCK Invoice SHARED, Implicit downgrade PROMPT-FOR Item.ItemNum. FIND Item USING ItemNum. DO TRANSACTION: UPDATE OnHand. FIND CURRENT Item NO-LOCK. DISPLAY Item.OnHand Item.BackOrder Item.OnOrder. END. Line 2: LOCK Item SHARED, Implicit Line 4: LOCK Item EXCLUSIVE, Implicit upgrade Line 9: LOCK Item NO-LOCK, Explicit Due to the read on line 5, this is now explicit.
Continue reading...
Continue reading...