URGENT - SQL Query in DataEnvironment

Subject Urgent - DataReport / DataEnvironment
Category Database
Posted by HanneSThEGreaT on 9/25/01 at 07:36 pm
Rating not rated


Hello.
I created a Data Environment, included the fields I want to print on the Data Report. I used an SQL statement to retreive the fields to print, as one would normally do. My question is: how can I modify that SQL statement to print (Example)all the payments which is less than $100, instead of All the payments?
If this question is unclear please let me know
Please help this is very urgent
Thanx




F. T. W.

Is your question concerning how to write the quiery if so then it is very simple:

"Select * from MyTable where Payment < 100 "


Valery Iskarov Nikolov
Software Dynamics

Hello vin, thanx for the help. I've got a few question though.
1) Where do I have to put this in? In the DataEnvironment itself?
2)
What if I want the user to select the amount they want to print(Example) less than 200, or = 200?

Thanx

F. T. W.

I am not very familliar with DataEnvironment kind of projects, but generally you have to choose command type to be "adCmdText" and in the text property you should supply your sql query. If you want to change it at run time you can do it by changing the text property value like this

DataEnvironment1.Commands(1).CommandText = "Select * from MyTable Where MyMoney < 100"




Valery Iskarov Nikolov
Software Dynamics