Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-29 Thread Perry Taylor
That and the expense of their usage. Perry Taylor Zirmed, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, July 26, 2013 1:32 PM To: U2 Users List Subject: [U2] [UV] Do you avoid

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-29 Thread Bill Haskett
I must say, I use triggers in UD with no problems. When converting from D3 to UD I had a hard time getting them to work. However, with useful suggestions from several on this list I was able to get them working properly. They turned out to be a bit more robust than the D3 triggers. I've

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-29 Thread Israel, John R.
We use this same concept. The triggers themselves are globally cataloged, but all they do is check a table then based on the file in question, call a 2nd locally (DIRECT) subroutine. Debugging is simple for us and never clobbers the live code when developing in a test environment on the same

Re: [U2] [UD] BASIC Code Failing

2013-07-29 Thread Tony Gravagno
From: Charlie Noah 1. If POLREC6 is null, an empty value won't be inserted... 2. INSERT sometimes doesn't like delimited source 3. If POLREC6 has multivalues itself... Charlie, you present a valid discussion of a failure with the Insert statement, but that might not be the problem at