When using a UNION command, make sure that IDQUOTES are
set to '`', that is single reversed quote.
Example:
CONNECT dbname
SHOW CHAR
SET IDQUOTES=`
Then, try the same UNION command to create view.
Good Luck!
Very Best Regards,
Razzak.
P.S. More COMPLEX views are used without any problem.
R:BASE 2000 (ver 6.5++), Build:1.842xRT03 and higher ...
At 11:48 PM 12/11/01 -0000, you wrote:
>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,
>>
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
================================================
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
