Glad you figured it out. Sometimes it is something simple overlooked.
Dan Goldberg
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Stuart Hellman
Sent: Friday, July 7, 2017 9:05 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
For
<mailto:rbase-l@googlegroups.com>
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
Stu
Would it be possible to show us final vWhere variable with the actual values.
Buddy
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of
and OPEN
> return a 0 (zero). The FETCH doesn’t want to cooperate.
>
> I appreciate the input.
>
> Stu
>
>
> From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
> Buddy Walker
> Sent: Wednesday, June 28, 2017 10:20 AM
> To: rbase-l
On Behalf Of
Stuart Hellman
Sent: Wednesday, June 28, 2017 12:58 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
Buddy,
It would look something like this:
WHERE Quote# = ‘123456’ AND Window = 1 AND CostType = ‘A' AND T2.SnapShotID =
9 AND T1.Master
Berry
Sent: Wednesday, June 28, 2017 10:49 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Peculiar Cursor Behavior
The indicator variables are set at the time of the fetch. The values are 0 and
1 indicating whether or not the value retrieved is a null. I just declare the
variables like this
perate.
I appreciate the input.
Stu
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Buddy Walker
Sent: Wednesday, June 28, 2017 10:20 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
Stu
Would it be possible to show us fi
: RE: [RBASE-L] - Peculiar Cursor Behavior
You do not have to do a cursor for indicators. Just use the select into command.
SELECT T1.MasterPart#, T1.Length, T2.UMMult into vQPart# INDICATOR vInd1,
vLength INDICATOR vInd2, vUMMult INDICATOR vInd3 +
FROM &vTable T1, SnapPartMast T2 &vW
, 2017 12:27 PM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
>
> Shouldn’t you have Indicator in your fetch command? I think the variables
> that hold the indicators should be different as well.
>
ENDIF
From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Tuesday, June 27, 2017 9:28 AM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
Subject: RE: [RBASE-L] - Peculiar Curso
nd3 = -1 then
Goto EndLoop
Endif
Dan Goldberg
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Stuart Hellman
Sent: Wednesday, June 28, 2017 7:43 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
Buddy & Dan,
I’m using the indic
s to me that
something behind the scenes of the cursor, something isn’t right.
Stu
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Buddy Walker
Sent: Wednesday, June 28, 2017 9:26 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
St
: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg
Sent: Tuesday, June 27, 2017 12:27 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
Should
, June 27, 2017 12:44 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Peculiar Cursor Behavior
I would try this. Right before you open the cursor put in return. Now at the R
prompt look at your vWhere and try manually typing the vWhere with the browse.
Maybe that will tell you what is ha
PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Peculiar Cursor Behavior
I would try this. Right before you open the cursor put in return. Now at the R
prompt look at your vWhere and try manually typing the vWhere with the browse.
Maybe that will tell you what is happening.
Buddy
Sent
@googlegroups.com] On Behalf Of
Dan Goldberg
Sent: Tuesday, June 27, 2017 12:27 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
Shouldn’t you have Indicator in your fetch command? I think the variables that
hold the indicators should be different as well.
FETCH
I would try this. Right before you open the cursor put in return. Now at the R
prompt look at your vWhere and try manually typing the vWhere with the browse.
Maybe that will tell you what is happening.
Buddy
Sent from my iPhone
> On Jun 27, 2017, at 1:11 PM, Stuart Hellman wrote:
>
> ENDIF
ult INDICATOR
vInd3
Dan Goldberg
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Stuart Hellman
Sent: Tuesday, June 27, 2017 10:11 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
There are different sets of tables used for differ
m [mailto:rbase-l@googlegroups.com] On Behalf Of
Buddy Walker
Sent: Tuesday, June 27, 2017 9:28 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Peculiar Cursor Behavior
Stuart
Is it possible for you to show the complete browse and declare statements.
Buddy
From: rbase-l@googlegroups.com
Stuart
Is it possible for you to show the complete browse and declare statements.
Buddy
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Stuart Hellman
Sent: Tuesday, June 27, 2017 8:51 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Peculiar Cursor Beh
19 matches
Mail list logo