SQL CURSORS

Sal . smclean17 at hotmail.com
Wed Feb 8 19:47:21 CST 2006


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&referral=hotmailtagline&url=http://shoppingau.ninemsn.com.au/compIntro.aspx?compId=195



More information about the powerh-l mailing list