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!

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

Search results for query: *

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

Part and Inventory Search

Back
Top