• Are parameters permitted on SQL Server 2000 views

    I think the answer to this is NO, but is there a way to create a view that accepts input parameters? I created the view hard coding in something that now needs the flexibility that a parameter would provide, but I've never seen a parameter on a view - Is it possible? Thanks

    CO Bill120 pointsBadges:
  • Prompting failed with unexpected error in Crystal Reports 11.5

    On refresh get error message, "Prompting failed with the following error message: 'Unexpected Error'. Error source: prompt.dll Error code: 0x80043800 I tried opening and saving all parameter fields. Any ideas?

    WTFH15 pointsBadges:
  • how to reference one Oracle 6i rpt param value from another param?

    I am trying to validate that two report parm dates are nomore than 2 years apart, how can I reference the from date while validating the to_date

    Dwatters5 pointsBadges:
  • How to create a parameter based on previous parameter.

    How to create a parameter based on previous parameter. Good Day, I am fairly new to CR and I was wondering if there was any way to accomplish the following? I am looking to create a parameter based on a previous parameter. I am using CR v.XI. Simple Example: Parameter #1: Run Report BY: (a)...

    Forpeekaboo5 pointsBadges:
  • Call RPGLE Program from RPG Program

    I have an RPG program. In that program I want to CALL a RPGLE program and pass parameters to it. What I need to know is there some parameter in the compile that I need to do to do this? I get errors when I try to compile the RPG normally.

    SoccerDave5 pointsBadges:
  • Creating a stored procedure in SQL

    I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need to make a parameter required !

    I want to code a *cmd with four parameters. 1. I want all of them to be required ( i.e. pressing enter without typing anything should issue a error message "Parameter BLABLA required") 2. I want to check at a *cmd level , not at the *pgm level behind the command if the entered parameter contains a...

    Iordache65 pointsBadges:
  • Truncating parameters!

    I haev a 6 position alpha variable that has a value of '12345 ' (a trailing blank). When I submit a job that does a CALL to a pgm with that variable as a parm, the submitted job has the value of that parm as '12345' with no trailing blank. Both pgms declare the variable as 6 *CHAR. I know there are...

    JeffWilson20 pointsBadges:
  • Can a command button macro run a make-table query with an auto-inputted parameter value?

    I want to run a make-table query with a parameter, using a command button click event on a form showing a single record. The parameter value needs to be inputted automatically using the value of a control in the current record of the same form. Can this be done with a macro event? If so, what does...

    Shdrc5 pointsBadges:
  • Send Error

    Task 'grottola@optonline.net - Sending' reported error (0x80070057) : 'Could not complete the operation. One or more parameter values are not valid.' I've checked addresses over and over. They all come from my contacts that I've used forever. So I'm not sure where to look to solve this problem....

    Mgrottola5 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:
  • Scope identity on a stored procedure in SQL

    I have created the following stored procedure in SQL: CREATE procedure [dbo].[sp_trip_number] @Table_Name nvarchar(100), @Trip_Number int output as begin set nocount on begin transaction DECLARE @DynamicSQL NVARCHAR(1000) DECLARE @New_Trip_Number int SET @DynamicSQL='INSERT INTO ' +...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Definition of the withGrant parameter in SQL

    When giving permissions to database users in SQL, what does the withGrant parameter do?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Parameters in RUNRMTCMD?

    Can I pass parametes in a runrmtcomd?

    J07285 pointsBadges:
  • How to access and use subform data/calculations

    Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form...Then the main form does a couple calculations on those amounts...But I need to access that information...

    OBI Girl85 pointsBadges:
  • Parameter structure COBOL vs RPG

    We have a COBOL program which can select up to 42 lines. The parameter structure is: 01 PARM PIC X(1024). 03 ID PIC X(4). 03 SELECTED OCCURS 42. 05 ITEM PIC X(4). 05 DESCRPT PIC x(20). I need to call this pgm in RPG. How do I best define the parameters without defining each individual field.

    r.otto810 pointsBadges:
  • ILE RPG call to ILE COBOL passing large array

    Our RPG program calls the COBOL program with a large linkage made up of an external file record format occurring 999 times. The COBOL program loads 121 of the occurrences with data. The RPG program, however, appears to start processing with the following occurrence 122 even though the COUNT index...

    toddio0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following