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

View this thread on the Works forum...