Hi All

Can I use query.extend.where in BAAN IVc

Thanks
MilindV

Hi,

Check this link:
http://www.baanboard.com/baanboard/showthread.php?p=146538

I hope it helps

- George

Hi All

Can I use query.extend.where in BAAN IVc

Thanks
MilindV

Hello,

maybe you can use something like:

sql.id1=sql.parse("Select dhlus051.* From dhlus051 "& where1&" and "&
" dhlus051.ccty between :ccty.f and :ccty.t and "&
" dhlus051.crep between :crep.f and :crep.t and "&
" dhlus051.citg between :citg.f and :citg.t and "&
" dhlus051.cuno between :cuno.f and :cuno.t and "&
" dhlus051.creg between :creg.f and :creg.t and "&
" dhlus051.cbrn between :cbrn.f and :cbrn.t and "&
" dhlus051.csgp between :csgp.f and :csgp.t "&
" order by "& orderstring)
returnwert1=sql.exec(sql.id1)
| Selectdo:
While sql.fetch(sql.id1)=0

..................................


Regards

query.extension = "tccom020.suno >=" & """100000"""

Regards,

Kozure

query.extension = "tccom020.suno >=" & """100000"""

Regards,

Kozure


As he said you can use this predefined variable, but it only works on before.program section