Hi
All three of your declares are against the same table all invoked at the
sometime with different and possibly conflicting logic. I hope the
perspective update statements aren't going to update the customer.
Wait...
In looking at you declares again the first declare is a distinct, I just
fought this on a similar situation where it would actually exit rbase all
together. The only way to solve the problem is to create a temp table and
load it with the first declare data and then run the subsequent declares
against the new temp table.
There is something with the distinct on the first declare with subsequent
declares against the same table.
Ben Johansen
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Ken Godee
Sent: Friday, April 27, 2001 10:25 AM
To: [EMAIL PROTECTED]
Subject: Re: Infamous I> prompt (Code)
I've dotted all my Vars, added indicator vars to fetch statements
all vars intialized outside of whiles, set whileopt off, increased files
from 5 to 30 still blows out to "I>" prompt (runs under
trace/debugger). If anyone wants to take a minute and peak at the
code and see if there is anything I'm missing, I've attached the
code ( not sure if list server excepts attachments) the show vars
are just for testing program.
