• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 148
  • Last Modified:

passing date to data report

Hello Experts !!
Please, i have problm.
i am trying to get a parameterised data report by passing date from form.
but it is not working. i am using dataevnironment.
In data environment what datatype of argument i have to select ?
secondly in dataenvironment when i right click command1 to see its properties, in parameters tab and then in parameter properties there are two lists for datatypes, one labeled Data type and second labeled Host Data Type. What is difference between both ?  
Please help.
thanks.
0
soodsandeep
Asked:
soodsandeep
  • 4
  • 2
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
Hi soodsandeep,

This is explained in http://support.microsoft.com/kb/244779/en-us

Cheers!
0
 
soodsandeepAuthor Commented:
hello emoreau !!
yes it was right
but still one problem persists.
if i write :
select * from emp where hiredate=?
then i works but if i use :
select * from emp where hiredate<?
then it does not work properly.
can you help. please.
Thanks.

0
 
Éric MoreauSenior .Net ConsultantCommented:
>>then it does not work properly.

why? any error message?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Éric MoreauSenior .Net ConsultantCommented:
is your date format ok?
0
 
soodsandeepAuthor Commented:
emoreau !
i think there is not error in date format. had it been some error, how could i get the correct output in first query : select * from emp where hiredate=?

i think the problem is due to how oracle compares dates ?
please look into.
Thanks.
0
 
Éric MoreauSenior .Net ConsultantCommented:
what would be the syntax in Oracle?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now