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