Can you empty a good db and load the errant db data and run it ok? -----Original Message----- From: Ben Petersen <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, December 11, 2001 11:32 PM Subject: Re: Out of Dynamic Space for View
As the saga continues... I unloaded the structure from the troubled DB and loaded data from a DB that hasn't had problems with this view. Now the error occurs after about 60 rows are returned rather than 20, but that isn't really significant. The view structure ends with a union that looks like this: union sel Id,0,0,0,Null,0,null,0,null,0,null, + 0,null,0,null,0,null,0,null,0,null,null + from Table whe ID not in (sel ID from receipts) Running this on its own is fine, running the more elaborate part of the view by itself is fine, using the entire view as part of another view is fine so long as this view isn't referenced in the where clause... I just can't have it the way I need it, apparently. This view only references two tables, one in the primary part of the view, one in the union. I've checked the structure of those two tables against the structure of the Database that works fine and they are identical. tia, Ben Petersen > -----Original Message----- > From: Ben Petersen <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Tuesday, December 11, 2001 11:31 AM > Subject: Out of Dynamic Space for View > > > Hi all, > > I have an app currently running at four sites. In bringing up the fifth a > view failed. It's based on two other views and a table, each of > which I can "Select" from with no problem. > > The view crashes with "out of dynamic space" after displaying 19- > 20 rows from a "select *" query. > > If, in the view definition, I leave one particular view off of the _where > clause_ but leave all other references to that view in the definition, I > don't get the error that the view tosses otherwise. > > I've redefined the view, unloaded the database and structure and > reloaded them again. Other client DB's present no problem on my > machine running the same cmd files. I'm stumped. > > My client is running win98, I'm running NT4, and I've tested under > RBW61.a and RBW6.5+ > > tia, > > Ben Petersen > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
