RE: [U2] UV: Indexing I-Descriptors

2004-09-20 Thread Chuck Mongiovi
In order to get the customer name we translate into the address book. Now Hence, you've got two unsynchronized indexes. That's the problem noted. I don't believe U2 has an internal function to resolve this situation. First off, I know that IBM doesn't support translates in indexes .. I know

Re: [U2] UV: Indexing I-Descriptors

2004-09-17 Thread Karl L Pearson
On Fri, 2004-09-17 at 10:40, Glenn Herbert wrote: Exactly how does the SELECT fail? 0 items returned? hang? crash? Zero items... In this application, one person purchases based on invoiced items. however, if this particular item isn't working, quotes go into the purchasing screen, thus causing

Re: [U2] UV: Indexing I-Descriptors

2004-09-17 Thread Karl L Pearson
On Fri, 2004-09-17 at 11:10, Karjala Koponen wrote: Karl, TRANS I descriptors are dangerous to index. This should work fine when field 5 of BOHDR exists when the record you're going from is written and field 5 of BOHDR does not change. I don't know whether the I descriptor will be

Re: [U2] UV: Indexing I-Descriptors

2004-09-17 Thread gerry
] To: u2-users [EMAIL PROTECTED] Sent: Friday, September 17, 2004 02:11 pm Subject: Re: [U2] UV: Indexing I-Descriptors On Fri, 2004-09-17 at 11:10, Karjala Koponen wrote: Karl, TRANS I descriptors are dangerous to index. This should work fine when field 5 of BOHDR exists when the record