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 qwerty123987

  1. qwerty123987

    Switch Statement Help

    Hey, can anyone tell me what I need to do to make the following syntax legal This statement will work. Batchnumber[x] is a string array that either has a 5 character text string, or a single space in each element {IVC.IVC_BATCH_NO} in switch ( {?Report Type} = "P&quot...
  2. qwerty123987

    Using Running Total Fields in Formulas?

    Unless I don't understand the problem, I think you just need to this: "1" + totext({RunningTotalField1}) + "blah blah description"
  3. qwerty123987

    Default values for a date parameter

    Hey, I have a date parameter and I want to have a default value that is always 1 year prior to the current date. However, from what I know, I can only set the default values for a parameter to be a constant value (i.e. I can set the default date to be July 17, 2001, but this value will never...
  4. qwerty123987

    dbms_output

    I had tried that, and it also fails. It gives an error of: The following error has occurred: ORA-06550: line 17, column 22: PLS-00307: too many declarations of 'TO_CHAR' match this call ORA-06550: line 17, column 1: PL/SQL: Statement ignored
  5. qwerty123987

    dbms_output

    At the bottom of this code are tow dbms_output statements. The second one always fails with this error message "The following error has occurred: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.DBMS_OUTPUT", line 64 ORA-06512: at line 17" Does anyone know why...
See more

Part and Inventory Search

Back
Top