Connect by .qry passing its parameter to CR's 
Author Message
 Connect by .qry passing its parameter to CR's

Hello all,

I have a qry that uses a connect by in its sql;

SELECT
ROWNUM,
LEVEL,
PART_NO,
PART_REV,
SUB_PART_NO,
SUB_PART_REV,

from IFSAPP.ENG_PART_STRUCTURE  
CONNECT BY
PRIOR SUB_PART_NO = PART_NO
AND PRIOR SUB_PART_REV = PART_REV
START WITH PART_NO = 'K76046'
AND PART_REV='16'

I want to put this into A CR using

START WITH PART_NO = &PART_NO AND &PART_REV

Is this possible with SQL designer passing the results of the qry to CR



Tue, 17 Aug 2004 23:50:26 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Newbie: Passing Parameters to a passthrough qry pt 2

2. Passing Parameters to stored parameter queries using VB 5's Data Controls

3. CR in VB.NET - Passing Parameters at Runtime

4. Passing date parameters from vb to cr -- again!!!

5. problem: passing parameters from CR to MS-Access-database

6. Problem with passing parameters to CR containing Stored Procedure

7. Help with passing parameters to CR

8. using VB app for passing parameters to CR 8

9. Passing parameters from VB to CR ...

10. Passing Date Parameter from VB to CR V7

11. How to Passing Parameters to CR?

12. Passing Parameters to CR

 

 
Powered by phpBB® Forum Software