Search results for query: *

Sybase does not allow parameterized SQL statements. Therefore, I must build my SQL statement using Global variables. I'm new to DTS and I found the link below. What do you do with this ActiveX Script Task after it is built? I understand the code until you get to: "Get reference to the...

I found the answer. Sybase cannot be parameterized. I will have to build a stored procedure and pass the parameters. gmctrek

I have a DTS package with a 'Transform Data Task' that copies data from Sybase to MS SQL. I use an SQL statement that has global variables (?) for the date range. Select * from table where date >= ? and date <= ? (parameter 1 is begin date and parameter 2 is end date) I get an error message...

Yes. It is a type. The date can "change." My database load job (DTS package - SQL Server) is scheduled to run on Saturday after the main job stream. If the main job stream has a delay, it could be Sunday be my job runs.

I'm new to CR, but I've been programming for over 17 years. I'm told that CR11 has dynamic parameters, but I have CR10. No chances of an upgrade. My report has a parameter filed called ?ReportDate. This date will be every Saturday of the year, but can chance with delays in processing. I...

I have the same problem. We use Outlook. I found the steps below, but they do not tell you that the ID file must be on the workstation with Domino Adminstrator loaded on it. I've tried to recertify them on the server, but I recieve errors. When I copy the ID file(s) to my C drive (in my...

Hi, I'm new to CR. I'm re-engineering my mainframe system from DB2/COBOL to MS SQL and Crystal Reports 10. I want to know what is the best method (ease of programming, flexablity in programming, etc.) for viewing my reports. I have the option of using Crystal Enterprise or MS Visual Studio...

Hi, I'm trying to auto number a column/field on a subform which will populate a column on my table. My project is a Personality Test Database. I need to record each person's 133 test answers. My table has the following columns: Assessment_ID unque ID Question_Num (1-133) Answer...

HELP! I'm a mainframe/DB2 programmer. I'm just learning Microsoft SQL Server. I need to pull data from the Microsoft SQL Server and send it to the mainframe. My questions: 1) What tool will I edit/test/run my SQL with? 2) How will I transfer the data from the Microsoft SQL Server to the...

What is the highest version of Crystal Reports that allows a user to save down to Version 8.5 formatting? We're using a program here at my work that is unable to work with versions higher than 8.5. Thanks