{{tag>category:"OpenInsight 32-bit" author:"Arsath Ahammed"}}

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


==== Sorting Multivalued Columns - Explosion (OpenInsight 32-bit) ====
=== At 17 JUL 2011 05:49:53AM Arsath Ahammed wrote: ===
 
 
<QUOTE>
Hi,

I find that in Open Insight the 'SELECT table BY.EXP column' does not work. Using By alone creates bizarre results for Multi-valued columns. There was a small help section in OI which did not give any solution to this problem.   



I want each multivalue to appear as a row, What I am getting is a mixture of single value and multivalue data. My select statement looks like this, Is there a different sort method for multi-valued columns?



vStmt = "SELECT ESTBOQ":thisboqno:" BY BRES_CODE WITH BRES_CODE EQ '":brescode:"'":@fm



vStmt: = "LIST ESTBOQ":thisboqno:" DESC1 SNO QUANTITY BQTY BRATE BUAMT BASIS FLAG"



results = Select_Into( vStmt, "EDT" )

x=set_Property(@WINDOW:'.EDT','LIST',results)



Thanks

Arsath
</QUOTE>

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