RE: [RBASE-L] - Peculiar Cursor Behavior

2017-07-07 Thread Dan Goldberg
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-07-07 Thread Stuart Hellman
<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

Re: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Albert Berry
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Buddy Walker
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Stuart Hellman
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Stuart Hellman
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

2017-06-28 Thread Stuart Hellman
: 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

Re: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Albert Berry
, 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. >

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Buddy Walker
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Dan Goldberg
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Stuart Hellman
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Buddy Walker
: 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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Dan Goldberg
, 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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Stuart Hellman
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-28 Thread Stuart Hellman
@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

Re: [RBASE-L] - Peculiar Cursor Behavior

2017-06-27 Thread Buddy Walker
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-27 Thread Dan Goldberg
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-27 Thread Stuart Hellman
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

RE: [RBASE-L] - Peculiar Cursor Behavior

2017-06-27 Thread Buddy Walker
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