sysa

hi,,

i have created a command under my dateEnvironment connection. the command has a sql query. please tell me how to change that sql query at runtime or how to use parameters with that query.

thanx.

anhmytran

Without your code, it is difficult to help.
By the way, what does the word "command" mean?

Cogen

Are you wanting to change the SQL query, or do you just want a parameter added to it? If you want to change it, then it might be better just to add an additional command object.

I'm not going to go into full detail on how to have a parameter in an SQL query, but here is a start ...

... in your SQL query, use the "?" key to identify a parameter
example ...
SELECT * FROM AccountLog WHERE StudentID = ?

... you mentioned that your using a dataenvironment, so click on the properties of the specific command object your talking about, and you will need to set the parameter properties on the parameters tab.

... when you call the command object, pass the parameter with it
example ... desomething.command_obectname parameter_value

Well, I hope that help a little at least.

sysa

ah! man this forum is great.
Thanks cogen. i did what you said and its working fine now.

anhmytran, by the word command i meant the Command that you create under a dataEnvironment where u can write SQL queries and can use that command to get a resultset.

w'll be back soon..

Cogen

I would have to agree with you ... this is a great forum.