Hello,

In a customed Overview session I created, I usually used query.extend functionality to filter and defined session table records.

function build_query()
{
query.extend.select(" whinh431.item, whinh431.shpm ")
query.extend.from("whinh431")
query.extend.where( "whinh431.shpm =" & quoted.string("SHO000121"))
}

how can use Embbeded SQL to shape the data of my session where would I insert this code so it is the one that is used:

select
whinh431.item, whinh431.shpm
from
whinh431
where
whinh431.shpm = "SHO000121"
selectdo
endselect


Regards,

Eric

Few questions..

1) Is this a new customize session?
2) What is the main table of session?