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

    Export report to PDF - error

    Thanks, that was it.
  2. cdm1221

    Export report to PDF - error

    I've written an executable in VB6 to export a CR 8.5 report to PDF. It works fine on my machine where the VB6 project lies. However, when I try to run the executable on another machine it throws the following error: -214719854(800473d2): The remaining text does not appear to be part of the...
  3. cdm1221

    CR Version question (EASY)

    thanks!
  4. cdm1221

    CR Version question (EASY)

    What version of CR came before 8.5?
  5. cdm1221

    Run VBScript from ASP using IIS

    Two part question: 1) I have a main computer running XP and IIS. I have a bunch of sites downloaded to it. One ASP page is trying to add tasks to the windows task scheduler. If I run the page over the web from the actual server machine, it will add the task to the scheduler. However, from a...
  6. cdm1221

    Trying to pass text from one ASP to another (hidden)

    In your action attribute of your form tag add welcome.asp. I'm not sure but you may need a submit button somewhere in there as well.
  7. cdm1221

    ASP, VBScript, & IIS

    I have two test IIS servers. I'm running the exact same asp file on both. Test.asp code: --------------------------------------------------------- <HTML> <HEAD> <TITLE></TITLE> </HEAD> <BODY> <% Dim wShell Set wShell = CreateObject("WScript.Shell") wShell.run "cmd.exe /c C:\test.vbs" Set...
  8. cdm1221

    UDF slows down reporting

    Thanks everyone! This can be difficult when you have to go through a DBA to do everything!
  9. cdm1221

    UDF slows down reporting

    (SELECT dbo.TESTFCN()) - expecting a FROM stmt (SELECT &quot;_SMDBA_&quot;.TESTFCN()) - doesn't like &quot;
  10. cdm1221

    UDF slows down reporting

    rosemaryl or synapsevampire... My SQL expression editor does not seem to like the select statement. It continues to return &quot;illegal character&quot; or &quot;invalid column name&quot; errors.
  11. cdm1221

    PLS-00201 Error

    Same error. Does it have something to do with permissions?
  12. cdm1221

    PLS-00201 Error

    I'm writing a simple stored function: CREATE OR REPLACE FUNCTION GET_GMTOFFSET RETURN number AS DBoffset number(10); UserOffset number(10); BEGIN DBOffset:=0; UserOffset:=0; select &quot;VALUE&quot; into DBOffset from &quot;_SMSYSADMIN_&quot;.&quot;SMSYSFLAGS&quot; where &quot;NAME&quot...
  13. cdm1221

    UDF slows down reporting

    rosemaryl, Can you clarify what you mean here: &quot;Make sure that you grant execute to Public so that users won't have an issue running.&quot; Thanks.
  14. cdm1221

    UDF slows down reporting

    Thanks rosemaryl! I will try this and get back to you. Hopefully everything will work!
  15. cdm1221

    UDF slows down reporting

    Yes, I understand. However, apparently there are already functions in my database. But I don't see them in CR8.5. I tried calling them using some sql syntax like &quot;SELECT dbo.functionname(parameters)&quot;, but CR still threw an invalid charater at the start of the dbo object. Does the...
  16. cdm1221

    UDF slows down reporting

    I'm using Oracle, and CR8.5..I was under the impression that the sql SELECT statements were not valid in SQL Expressions. So, you're saying that with the Oracle UDF (created with VB), the UDF will show up in the SQL Expression list of functions, and I will be able to use the select statement...
  17. cdm1221

    UDF slows down reporting

    That is true, but I wasn't sure how to do that. I created the UDF in Visual Basic to be used in CR 8.5. The UDF functions go into the database and select a single value from the database. Is it possible to add this UDF DLL to the database, if so how? And, how would I access the functions in CR?
  18. cdm1221

    UDF slows down reporting

    I've created a DLL with user defined functions that I need. The record selection formula as well multiple fields in my report use two of these functions. The report runs ridculously slow (10+ min on a DB of 75000 records). Now I've read that if you use a function in the record selection...
  19. cdm1221

    Simple Select Statement

    Okay I threw two double quotes around the table name and now the &quot;ORA-00942: table or view does not exist&quot; error appears. Do you think that fixed it or caused a new error?
  20. cdm1221

    Simple Select Statement

    BTW, thanks for replying to me. Tried that too, and tried some iSQL suggestion to use \&quot; before the table name and before the period. But, that doesn't work either in the quotations - throws a VB compilation error. Any other suggestions???

Part and Inventory Search

Back
Top