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!

Search results for query: *

  • Users: cdm1221
  • Content: Threads
  • Order by date
  1. 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...
  2. cdm1221

    CR Version question (EASY)

    What version of CR came before 8.5?
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. cdm1221

    Simple Select Statement

    Can someone tell me why I get an error (ORA-00911: invalid character) for the following statement: strQuery = &quot;SELECT A.SEQ_GMT FROM _SMDBA_._PERSONNEL_ A WHERE A.CODE = &quot; & user Set rs1 = conn1.Execute(strQuery) I believe it's because of the period in the table name. Does anyone...
  8. cdm1221

    Using Left Outer Join and USER to select fields

    I'm trying to avoid using a stored procedure, but I'm attempting the following SQL query in CR 8.5: SELECT A.X FROM A, B WHERE A.Y = B.Y (+) AND B.Z=user However, everytime I enter this into Database-->Show SQL Query, it changes it and returns: SELECT A.X FROM A WHERE...
  9. cdm1221

    Write an SQL expression using SELECT and USER()

    Hi all! I'm using a very large Oracle DB, and want to create a report using multiple tables from this DB. However, whenever I try to create an SQL expression using SELECT, FROM, WHERE, etc. it gives me the following error: &quot;ODBC error: [MERANT][ODBC Oracle 8 Driver][Oracle 8]ORA-00911...

Part and Inventory Search

Back
Top