please give one example to use subsection

disable.fields("table.field")

how to use the following select example in Baan

select substr(clno,2) from client_master
here what function should be used in place of substr

Reeta,

Here is an example -


if form.dev.apr = tcyesno.no then
enable.fields("form.sbm.req")
else
disable.fields("form.sbm.req")
endif


There is no direct function in BaaN equivalent to substr() as in Oracle. You can refer to the following link for more details for partial string matching and you can use the selectbind or wherebind options in the BaaN SQL, or check the "like" operator please refer to the tools manual for more details.

wildcards in SQL (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=5905)

To the best of my knowledge, enable and disable.field commands are supported in Baan V only.

You are right Lisa, but I dont know why Reeta asked that Q when her Baan version is BAAN 4C.