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
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

[RBASE-L] - RE: PROJECT Puzzle

2017-06-27 Thread Claudine Robbins
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

RE: [RBASE-L] - Peculiar Cursor Behavior

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

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

[RBASE-L] - RE: PROJECT Puzzle

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

[RBASE-L] - Peculiar Cursor Behavior

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