I have writen follwoing query in my program script .

select sum(whinh270.qoro)
from whinh270 where whinh270.orno=:whinh220.orno
group by whinh270.orno

But while compiling i am getting following error

Error SQL: SQLState HYL06: select item 1 must be bound explicitly (302)

Please help me to resolve this issue.

Regards
King1980

Hi,

The group by variable "whinh270.orno" must be selected in the select query.

Regards,
Amit

Hi,

Query shld be :

select sum(whinh270.qoro) :var
from whinh270 where whinh270.orno=:whinh220.orno
group by whinh270.orno

declare some variable to var to store that value

Thanks Chaitanya,

It's working fine.


Regards
king1980

Hi,

Query shld be :

select sum(whinh270.qoro) :var
from whinh270 where whinh270.orno=:whinh220.orno
group by whinh270.orno

declare some variable to var to store that value

i got same error....it's working...
Thnak you:)