Alastair,
You can use code following example to set up your parameters in
DataEnviroment.
Don't forget to put names of the parameters when you setting up a command.
I prefer to use stored procedure in DE - it set's up parameters
automatically.

Private cm1 As New Command
'de1 - DataEnv.
 	set cm1 = de1.Commands("CommandName")
      cm1.Parameters("ParamName").Value = ParamValue
	 cm1.Execute

Good luck!
Eva
-----Original Message-----
From: avance@c... [mailto:avance@c...]
Sent: Tuesday, April 24, 2001 6:34 AM
To: professional vb
Subject: [pro_vb] Data Environment and Data Reports


Hi,

I have a data environment set up along with connection and a command (select
query).  The query is set to bring back all results as I wish to filter it
on call to the report.

That's where the problem is:  I can't figure out how to amend the where
clause of the query.  I can use the rs.filter method - but this is too slow.
Does anyone know how to do this?  I can't even find any documentation about
passing in parameters dynamically.

I tried playing around with Parameter queries, etc. but it didn't work
either.

I'm using VB6 and Oracle.

Alastair.


____________________________________________________ Confidentiality Advice:
This e-mail transmission may contain confidential or legally privileged
information that is intended only for the individual or entity named in the
e-mail address. If you are not the intended recipient, please reply to the
sender, so that Galen Holdings PLC can arrange for proper delivery, and then
please delete the message from your inbox. 

If you have received this e-mail transmission in error, you are hereby
notified that any disclosure, copying, distribution, or reliance upon the
contents of this e-mail is strictly prohibited. Thank you. 

This e-mail is from a company belonging to Galen Holdings Plc. 

Registered Office: Seagoe Industrial Estate, Craigavon, Northern Ireland,
BT63 5UA.  Registration Number: NI25836