Help!!! Frequency question

Hi.

I am generating a report that will display some data, and then delete that data from the database. In order to do this correctly, I am trying to utilize the After Report feature. I have the SQL written, and it should be correct, because it is the same SQL as the previous version of this report. However, it keeps telling me that the variables are in the wrong frequency. Here is the code I am trying to use:   DELETE SHIP_LABEL_REQUEST
   WHERE CONTRACT_NBR = :CONTRACT_NBR

     AND DO_NBR = :DO_NBR
     AND CATEGORY_CODE = :CATEGORY_CODE
     AND PRODUCT_NBR = :PRODUCT_NBR
     AND SERIAL_NBR = :SERIAL_NBR
     AND LAST_TRANS_USERID = :USERNAME;

Here is the error I get when I run the form: REP-1316: After Report Trigger references column 'CONTRACT_NBR' at wrong frequency.

Should I be refencing the group that CONTRACT_NBR and the others are coming from? If so, how do I do that? If not, do you have any idea how I would do this?

Thanks for the help!
Kristen

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 19 1999 - 14:07:58 CDT