SQL CURSORS

[Darren Reely]

Try one of these. Sorry, I really don't have the time to check this coding.

ACCESS *$SUBDIR/bulkarea &
LINK to inv_prod where (inv_prod.prod = :prod of bulkarea)

ACCESS *$SUBDIR/bulkarea &
LINK to inv_prod where (inventory.prod = :prod of bulkarea)


Sal . wrote:
> 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 
> 
>