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.
Re: URGENT - SQL Query in DataEnvironment
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
Re: URGENT - SQL Query in DataEnvironment
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.
Re: URGENT - SQL Query in DataEnvironment
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