Precisely Speaking
May 21, 2012, 07:38:33 PM
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: So what's news with you? Tell us about it in "Getting To Know You"!
Home
Help
Calendar
Login
Register
Precisely Speaking
>
Training and Education
>
SB+ Programming Questions
>
Multi-value Add/Delete
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Multi-value Add/Delete (Read 238 times)
adewitt
Professional
Posts: 42
Multi-value Add/Delete
«
on:
October 05, 2011, 12:38:46 PM »
I have two attributes that are multi-value.
Whenever I add, insert or delete values in each attributes I want the after process to maintain a file that is a crossreference. So, whenever I add or insert I want to add a record containing the value to the crossreference and when I delete the value I want to delete the record from the cross reference.
I'm sure I have read that there are variables that I can use to tell me whether it's an add (insert) or a delete allowing me to go to correct subroutine in my after process. Can someone tell me where I can find information on those variables?
Thanks.
Logged
precisonline
President/Chief Technologist
Administrator
Rock Star
Posts: 1532
Re: Multi-value Add/Delete
«
Reply #1 on:
October 05, 2011, 02:01:05 PM »
There is a process slot that is called when a row is removed from a mv'd list. Press F3 on the C (Control/Dep/Read prompt) and the process slot can be found there. As to figuring out if someone added a row with Ctrl-Ins, there isn't any such thing to my knowledge. You could restrict the multivalue set using CI (instead of just C) which would prevent people from inserting rows in the middle, then they could only add rows to the end. Anything added (as checked in the Process After on the field) would be something new. You could also compare @RECORD<x,@CNT> to @ORIG.REC<x,@CNT> to see if the value had been changed.
Logged
-Kevin
Accidents "happen"; success, however, is planned and executed.
adewitt
Professional
Posts: 42
Re: Multi-value Add/Delete
«
Reply #2 on:
October 06, 2011, 06:02:04 AM »
Thanks.
Logged
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Getting To Know You
=> Announcements
=> Big Thoughts / Cool Ideas
=> Rants & Raves
-----------------------------
Application Support
-----------------------------
=> Red Leaf
=> Activant/Prelude Support
=> Summit Support
=> Avante Support
=> PRC Support
-----------------------------
Training and Education
-----------------------------
=> Connect!
=> U2 Programming Questions
=> SB+ Programming Questions
=> Web Programming Questions
=> Business Intelligence / MITS
=> PC / Hardware / Miscellaneous Support
Loading...