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...
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...
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...
rosemaryl or synapsevampire...
My SQL expression editor does not seem to like the select statement. It continues to return "illegal character" or "invalid column name" errors.
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 "VALUE" into DBOffset from "_SMSYSADMIN_"."SMSYSFLAGS"
where "NAME"...
rosemaryl,
Can you clarify what you mean here:
"Make sure that you grant execute to Public so that users won't have an issue running."
Thanks.
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 "SELECT dbo.functionname(parameters)", but CR still threw an invalid charater at the start of the dbo object. Does the...
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...
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?
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...
Okay I threw two double quotes around the table name and now the "ORA-00942: table or view does not exist" error appears. Do you think that fixed it or caused a new error?
BTW, thanks for replying to me.
Tried that too, and tried some iSQL suggestion to use \" 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???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.