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 HamerProject Leader
KCS - Total Human Resource Solution Providers
PAYROLL SOFTWARE PROVIDER OF THE YEAR 2001 & 2002
Personnel/Payroll/T&A/Integrated Software & Bureau Services
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
To unsubscribe, e-mail: email@example.com
For additional commands, e-mail: firstname.lastname@example.org