Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ohsillyme

  1. ohsillyme

    Date formats within Oracle 10G

    Oh one more thing. I have added other prompts to this same query. The input values of these are not dates, but they work just fine. I have removed them and hard-coded their values temporarily to ensure they don't conflict with 'my PRECIOUS' date prompt. I wonder if there is some kind of glitch...
  2. ohsillyme

    Date formats within Oracle 10G

    Hi.. Yes, it does work if I hard-code it, but since the users do not have SQL access, I was trying to empower them a bit. thx!
  3. ohsillyme

    Date formats within Oracle 10G

    Hi blom0344 - I have also tried that format. What I hadn't tried was the @variable. @Prompt has worked in the past for me using other types of values and simple dates, but not this time. I just tried the '@variable', but no 'workie'. :( I get the same response. Thanks for your response! :)
  4. ohsillyme

    Date formats within Oracle 10G

    Hi Steve! Thanks for the response. I started off with 'D' and moved to 'A' because I was getting the 'no data to fetch' message. I don't know what format it expects. I've tried every possible combination I can think of. At this point, I am assuming that it just doesn't like the prompt...
  5. ohsillyme

    Date formats within Oracle 10G

    Hello... Help! :( (Using Business Objects Full Client 6.52 and Oracle 10G - REAL-TIME data) I am having trouble with my prompt. :( I keep getting 'no data to fetch'. (ORDERS.ORDER_DT Between @Prompt('Start Date','a',,mono,free) AND @Prompt('END Date','a',,mono,free) ) I can get it to work...
See more

Part and Inventory Search

Back
Top