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
Shouldn’t you have Indicator in your fetch command? I think the variables that
hold the indicators should be different as well.
FETCH QteDetail + <--Here is where the 406 error code is returned in my
error variable
INTO vQPart# INDICATOR vInd1, vLength INDICATOR vInd2, vUMMult INDIC
Dan,
Your comment leads to an eye-opener. When I PROJECT my view, the two fields I
use in the ORDER BY become NOTE fields instead of TEXT which may partly account
for the extreme processing delay.
I also note that when creating a TEMP table, R:BASE strictly enforces field
definitions and const
There are different sets of tables used for different processes, so that is why
the WHERE clause is a variable
SET VAR vTable = 'QuoteDetail'
SET VAR vWhere = ('WHERE Quote# = .vQuote# AND Window = .vWindow ')
SET VAR vWhere = (.vWhere & 'AND CostType = .vPrimAlt')
SET VAR vWhere = +
(.vWh
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
Sounds like you need to report it.
BTW, I avoid project commands as it locks the table. I create the temp table
and insert.
Dan Goldberg
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Claudine Robbins
Sent: Monday, June 26, 2017 11:55 AM
To: rbase-l@googlegroups.
Need some expert advice on a cursor problem I’m having.
The situation is a large form in which is using about 10, one at a time.
Nothing “exotic” is going on with the cursor in question. All of them work
except one. Data is being retrieved from 2 tables. The cursor is dropped,
declared, opened
7 matches
Mail list logo