passing date to data report

Posted on 2006-04-18
Last Modified: 2010-05-01
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.
Question by:soodsandeep
    LVL 69

    Accepted Solution

    Hi soodsandeep,

    This is explained in


    Author Comment

    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.

    LVL 69

    Expert Comment

    by:Éric Moreau
    >>then it does not work properly.

    why? any error message?
    LVL 69

    Expert Comment

    by:Éric Moreau
    is your date format ok?

    Author Comment

    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.
    LVL 69

    Expert Comment

    by:Éric Moreau
    what would be the syntax in Oracle?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
    If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now