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 Chriss Miller 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: *

  • Users: jwray100
  • Content: Threads
  • Order by date
  1. jwray100

    Reading from a text file

    I'm familiar with writing to a text file (i.e. .csv). I think I learned the method from this forum. I have a need to read from a text file, but I'm not sure of the best way to go about doing this in a RS macro. The requirement is to have some semi-static, non-ADP DB data for use in the report...
  2. jwray100

    DECODE wildcard

    Is it possible to use wildcards in a SQL derived field with a DECODE statement to approximate a "LIKE". For example: DECODE("REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWHOMEDEPT", '%AH', ( NVL( SUM(DISTINCT "REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWGROSSPAYA") , 0 )), 0 ) to return the gross pay...
  3. jwray100

    Comments/Remarks in derived fields

    Is it possible to add comment/remarks in SQL derived fields? I'm looking for the character(s) to use like the character (' I think) used to remark out lines in RS Macros. Thanks, Joel Ray Ronile, Inc.

Part and Inventory Search

Back
Top