[RBASE-L] - Re: BROWSE Window View Wierdness

[Bruce Chitiea]

Alistair: Typo during message creation.

James: Code to follow

Bruce

-------- Original Message --------
Subject: [RBASE-L] - Re: BROWSE Window View Wierdness
From: "Alastair Burr" <adbb...@virginmedia.com>
Date: Tue, August 07, 2012 4:28 pm
To: rbase-l@rbase.com (RBASE-L Mailing List)

Different view names = different views or typo???

 

vwGoodToGo

vwGoodView

 

If one is a copy of the other how did you copy? Updated one but not the other???

 

It’s always going to be R:Base that knows better! You just have to find the problem...

For me, I’d bet that the views are not exactly the same if it’s not a typo.

 

Regards,

Alastair.

 

 

 

From: Bruce Chitiea

Sent: Tuesday, August 07, 2012 10:02 PM

To: RBASE-L Mailing List

Subject: [RBASE-L] - BROWSE Window View Wierdness

 

All:

RBase xTreme 9.1(64) Latest
Windows7 Local SU

A successfully-created view successfully generates its full data set
when I type:

    SELECT * FROM vwGoodToGo

...  at the R>Prompt. The same view fails to display the full set
(details below) when I either:

    a) Type at the R>prompt: BROWSE * FROM vwGoodView, or:
    b) Select [Open View] from the Database Explorer.

The BROWSE window opens in WINDOW_STATE NORMAL, with no error evident. I
can close the window with no error evident.

An attempt to maximize the window results in two errors (in order):

    'Invalid Cursor State (2645)'
    'The requested _expression_ does not exist (2144)'

... and the only rows visible are those which initially appeared within
the NORMAL browse window.

No other view (so far) elicits this response.
Again, the view generates correctly as a SELECT statement.
Regarding Error (#2144) the one computed column performs flawlessly in
'SELECT world'.
I've vacuumed the entire view creation process; nothing burps.

Any thoughts?

Bruce