Hi All,

I have an SDO that will be used to provide data to many screens within our application.

The design-time query is:

for each empset no-lock, first empbasic where empbasic.empno = empset.empno no-lock indexed-reposition.

This obviously has 2 buffers: empset and empbasic.

For most users running the application the query is modified at runtime using assignQuerySelection and it works fine:

for each empset no-lock where empset.useridf = 'userloginname',

first empbasic where empbasic.empno = empset.empno no-lock indexed-reposition.

When an 'admin' type user runs the application the query needs to be:

for each empbasic no-lock indexed-reposition.

I need to remove the empset buffer before adjusting the query.

Is this possible?

Has anyone done something similar?

I know using a static container, I could use the parameterize as variable, but I am using an independent window (DynObjc) for the obvious benefits.

Can Parameterize as variable be used in a dynamic container?

Regards,

Colin Hamer

Project Leader

KCS - Total Human Resource Solution Providers

PAYROLL SOFTWARE PROVIDER OF THE YEAR 2001 & 2002

(Pay Magazine)

Personnel/Payroll/T&A/Integrated Software & Bureau Services

http://www.kcsplc.com

Whitecliff House, 852 Brighton Road, Purley, Surrey CR8 2BH

Tel: +44 (0)20 8660 2444. Fax: +44 (0)20 8668 8196

This message is intended for use only by the individual entity to which

it is addressed and may contain information that is privileged and

confidential.

To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org

For additional commands, e-mail: dev-help@icf.possenet.org