Hi,
I have a shared table which has all compaines data.
now i need data to be displayed accoridng to login company.
It shouldn't show other company's data.
I tried query.extend.where option.but not working..
suggestion plz..

Try Skip.io

query.extend.where should work. Which code have you used and where (session script, DAL)?

extend query used in before.program. and the code is..

company = get.compnr()
| query.extend.where("tdjsl100.comp = :company ")

tdjsl100 is the customized table. shared table is standard table tfgld110.i am sending data from shared table to cust table.
when i want to display form cust table, It should display login company wise details.

If the main table of the session is tfgld110 use

company = get.compnr()
query.extend.where("tfgld110.cono = :company")

Regards,
Sai prasad

I already tried this..its giving error and logging out from baan.

Hi,
try this, hopefully it works

company = get.compnr()
query.extend.where("tfgld110._index1 ={:company}")

I think both r almost same here..
its ok...somewat coming now but error has some other consequenses.
Thnq for all..

try with declaring company as a extern variable.. and then try

can you provide me the error messge which u r geeting while using

company = get.compnr()
query.extend.where("tfgld110.cono = :company")