SQL CURSORS

[Ken Langendock]

Sal, I'm sorry if the syntax below is not completely accurate but if I
remember correctly I had the same problem linking to a cursor with a
value.

I rewrote the code to put the linkage in the cursor. Give this a try,
it's how I made all my cursors work. One extra note, I never do any
linking in QUIZ, I do all my linking in QTP and simply report the
contents of the subfile in QUIZ.

Ken

SQL DECLARE INV_PROD CURSOR FOR &
    SELECT * FROM PROD_WHSE_M, &
             INVENTORY, &
             PROD_M &
       WHERE INVENTORY.PROD = PROD_WHSE_M.PROD &
         AND INVENTORY.WHSE = PROD_WHSE_M.WHSE &
         AND PROD_WHSE_M.PROD = PROD_M.PROD &
         AND INVENTORY.INV_PROD = :PROD OF bulkarea

ACCESS *$SUBDIR/bulkarea &
       LINK TO INV_PROD


-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Sal .
Sent: February 8, 2006 8:47 PM
To: powerh-l at lists.sowder.com
Subject: SQL CURSORS


Hi,

I'm new to powerhouse, wondering if someone can help me with this error.
i 
declared a cursor in Quiz, but then when i try to access it, i get the
error 
"wasn't found in the data dictionary".


>
>SQL DECLARE INV_PROD CURSOR FOR &
>SELECT * FROM PROD_WHSE_M, INVENTORY, PROD_M &
>WHERE INVENTORY.PROD = PROD_WHSE_M.PROD &
>AND INVENTORY.WHSE = PROD_WHSE_M.WHSE &
>AND PROD_WHSE_M.PROD = PROD_M.PROD
>
>ACCESS *$SUBDIR/bulkarea LINK PROD TO INV_PROD
*E* The file INV_PROD wasn't found in the data dictionary.

Thanks

Sal

_________________________________________________________________
Win a romantic $10,000 holiday for two! 
http://ninemsn.com.au/share/redir/adTrack.asp?mode=click&clientID=151&re
ferral=hotmailtagline&url=http://shoppingau.ninemsn.com.au/compIntro.asp
x?compId=195

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.