Savelists with Spaces (Banded Report Writer) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"Banded Report Writer" author:"Donald Bakke" author:"bshumsky"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Savelists with Spaces (Banded Report Writer) ====
=== At 25 NOV 2022 03:43:30PM Donald Bakke wrote: ===
 
 
<QUOTE>
The [b]RTI_BRW_GenerateReport[/b] routine has an [i]overrideListID[/i] argument. We've noticed that if the name of the savelist has a space in it this causes problems for the BRW, at least with programmatic data sources. Instead of seeing the query appear with a valid syntax like this:


<code>
WITH KEY = "MyKey"
</code>


We see:


<code>
0 = 1
</code>


This is also the same result if we pass in a non-existent savelist name. I suspect the space is causing a parsing problem on the backend and an invalid savelist ID is created.



This is with OI 9.4. Haven't tested with OI 10.



[url=mailto:dbakke@srpcs.com]Don Bakke[/url]

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]
</QUOTE>
----

=== At 25 NOV 2022 07:42PM bshumsky wrote:  ===

<QUOTE>
<QUOTE>The [b]RTI_BRW_GenerateReport[/b] routine has an [i]overrideListID[/i] argument. We've noticed that if the name of the savelist has a space in it this causes problems for the BRW, at least with programmatic data sources. Instead of seeing the query appear with a valid syntax like this:


<code>
WITH KEY = "MyKey"
</code>


We see:


<code>
0 = 1
</code>


This is also the same result if we pass in a non-existent savelist name. I suspect the space is causing a parsing problem on the backend and an invalid savelist ID is created.



This is with OI 9.4. Haven't tested with OI 10.



[url=mailto:dbakke@srpcs.com]Don Bakke[/url]

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]</QUOTE>



Hi, Don.  I haven't looked into this yet, but I do recall that when a savelist name has a space in it, we treat it as <filename><space><listname> - that is, we allow you to save and restore the savelist from a table other than SYSLISTS.  That's possibly why the list isn't getting found (and saved?) - the "first word", which is expected to be the table name, probably doesn't exist as a valid table...?



- Bryan Shumsky

[url=https://www.revelation.com]Revelation Software, Inc.[/url]

</QUOTE>

----

=== At 25 NOV 2022 08:01PM Donald Bakke wrote:  ===

<QUOTE>
<QUOTE>
<QUOTE>The [b]RTI_BRW_GenerateReport[/b] routine has an [i]overrideListID[/i] argument. We've noticed that if the name of the savelist has a space in it this causes problems for the BRW, at least with programmatic data sources. Instead of seeing the query appear with a valid syntax like this:


<code>
WITH KEY = "MyKey"
</code>


We see:


<code>
0 = 1
</code>


This is also the same result if we pass in a non-existent savelist name. I suspect the space is causing a parsing problem on the backend and an invalid savelist ID is created.



This is with OI 9.4. Haven't tested with OI 10.



[url=mailto:dbakke@srpcs.com]Don Bakke[/url]

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]</QUOTE>



Hi, Don.  I haven't looked into this yet, but I do recall that when a savelist name has a space in it, we treat it as <filename><space><listname> - that is, we allow you to save and restore the savelist from a table other than SYSLISTS.  That's possibly why the list isn't getting found (and saved?) - the "first word", which is expected to be the table name, probably doesn't exist as a valid table...?



- Bryan Shumsky

[url=https://www.revelation.com]Revelation Software, Inc.[/url]</QUOTE>



Hi Bryan - Perhaps that is the issue but I can't even get that to work with a SYSLISTS key without a space. That is, if I pass in "SYSLISTS <savelist>" and <savelist> has no space, it isn't pulling from the savelist.



[url=mailto:dbakke@srpcs.com]Don Bakke[/url]

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=366B9BF75AECB54681FEB12C1BC4D2D8|View this thread on the Works forum...]]