dbDisplayLookUpList without SQL problem

[John Lim]

According to the docs, I can use key values instead of an SQL statement for dbDisplayLookupList.

<b>Syntax 2</b>
Obj.dbDisplayLookupList=&#34;(;|)LookupKey|Size|Ke y1|Val1|Key2|Val2; ...Repeat&#34;

<b>Example</b>
X.dbDisplayLookUpList=&#34;(;|)User;ReportsTo|9|1| One|2|Two|3|Three|4|Four|5|Five|6|Six|7|Seven|8|Ei ght| 9|Nine;&#34;


I don&#39;t understand the &#34;User;ReportsTo&#34; -- isn&#39;t there an error in this example? Whenever I try to use this syntax, I get an error message telling me that it is invalid SQL -- this means that it isn&#39;t recognising Syntax 2.

My code for column pr_stocklevel is given below
<pre>
m += &#34;(;|)pr_stocklevel|3|0|No Stock|1|Low Stock|2|In Stock;&#34;
</pre>

Thanks in advance for any help.

[Frank Kwong]

please send a request to support to obtain a newer version with this problem fixed..


FK


------------
John Lim at 5/19/00 6:08:19 AM

According to the docs, I can use key values instead of an SQL statement for dbDisplayLookupList.

<b>Syntax 2</b>
Obj.dbDisplayLookupList=&#34;(;|)LookupKey|Size|Ke y1|Val1|Key2|Val2; ...Repeat&#34;

<b>Example</b>
X.dbDisplayLookUpList=&#34;(;|)User;ReportsTo|9|1| One|2|Two|3|Three|4|Four|5|Five|6|Six|7|Seven|8|Ei ght| 9|Nine;&#34;


I don&#39;t understand the &#34;User;ReportsTo&#34; -- isn&#39;t there an error in this example? Whenever I try to use this syntax, I get an error message telling me that it is invalid SQL -- this means that it isn&#39;t recognising Syntax 2.

My code for column pr_stocklevel is given below
<pre>
m += &#34;(;|)pr_stocklevel|3|0|No Stock|1|Low Stock|2|In Stock;&#34;
</pre>

Thanks in advance for any help.