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 Mike Lewis 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: cli
  • Order by date
  1. cli

    Dat format problem using Crystal Reports 8.5 & Oracle 8i

    Hi, Thanks for suggestion, have tried that and set the format there but it still has the same problem ! It seems logical that it is something in Crystal Reports itself, do you know of any where else that you set default data types in crystal reports ? Thanks, Cli
  2. cli

    Dat format problem using Crystal Reports 8.5 & Oracle 8i

    Hi, When I select the date in both machines in a sql plus session it looks the same. If I execute the store procedure on both machines just from a sql pus session it runs fine and inserts correctly. If I call the store procedure from the crystal reports in the secong machine it falls over...
  3. cli

    Dat format problem using Crystal Reports 8.5 & Oracle 8i

    Hi , Thanks for your suggestion. I am now not convinced it is an oracle setting but think that I am now closer to a soltion. The error I am getting is ODBC error: [MERANT][ODBC ORacle 8 driver][Oracle 8]ORA-06550;line1,column8; PLS--00306: wrong number or types of arguments in call to...
  4. cli

    Dat format problem using Crystal Reports 8.5 & Oracle 8i

    Hi, I am using Oracle 8i and crystal reports 8.5. I have several reports which are populated by procedures from on the database. These procedures substring a date for use in if statements and concatenates it back together for a parameter. For some reason this works fine on my machine but not...
  5. cli

    oracle sql question

    Hi, I would appreciate any help with this please ! I am trying to make the sql below more dynamic SELECT TB_NAT.CL_NAT, SUM(DECODE(TB_BAT.DE_STATUS,'JR',1,0)) AS JR, SUM(DECODE(TB_BAT.CL_GENDER_CODE,1,1,0)) MALE, SUM(DECODE(TB_BAT.CL_GENDER_CODE,2,1,0)) FEMALE FROM tb_BAT, TB_NAT WHERE...
  6. cli

    dynamic sum decode

    Hi, I would appreciate any help with this please ! I am trying to make the sql below more dynamic SELECT TB_NAT.CL_NAT, SUM(DECODE(TB_BAT.DE_STATUS,'JR',1,0)) AS JR, SUM(DECODE(TB_BAT.CL_GENDER_CODE,1,1,0)) MALE, SUM(DECODE(TB_BAT.CL_GENDER_CODE,2,1,0)) FEMALE FROM tb_BAT, TB_NAT WHERE...
  7. cli

    sql if table exists drop table using srw.do_sql !!!

    just found my mistake ....syntax i am afraid !! would still be interested to know why it is not a good idea to create tables from triggers thanks !!
  8. cli

    sql if table exists drop table using srw.do_sql !!!

    Hi, thanks a million for this suggestion... I have tried this and if the table isn't there this piece of sql runs fine, but if the table is there it still doesn't drop...it doesn't seem to execute the drop command also why is it a bad idea to create a temp table in the before report trigger...
  9. cli

    sql if table exists drop table using srw.do_sql !!!

    Hi, would totally appreciate help..new to sql I am tyring to check if a table exists from trigger in oracle reports before creating it. My code complied fine but has an error saying command not ended properly when irun it. code: ******************************************************...
  10. cli

    sql SUBTRACTING TWO SUMS

    Hi , Have tried this but unfortunately it gives the same answer as select sum (table1.column1 - table2.column2) from table1, table2; for some reason doing the way you suggested subtracts before it sums... any other ideas ???
  11. cli

    sql SUBTRACTING TWO SUMS

    HI ! I am trying to subtract the sum of two different columns on two different tables from each other. If I write my sql as: Select sum(table1.column1- table2.column2) from table1, table2; I get the wrong answer it subtracts the columns before summing them. So now I have created a stored...

Part and Inventory Search

Back
Top