if indexseek(InvLinesCursor.Product_ID, .t., 'product', product_id')However, I tried it anyway and when I save the code it tells me "Function Name missing". I suspect I'm missing a delimiter of some sort.
>set deleted on >Select * from InvoiceDetail Where Invoice_ID = InvoiceHeader.Invoice_ID ; > into cursor InvLinesCursor >scan && we are scanning invLinesCursor, not invoiceDetail table > if indexseek (InvLinesCursor.Product_ID, .t., 'product', product_id') > * product found > select product > Replace UseSeason with m.currentseason > else > * product not found...error processing here > * referential integrity is supposed to prevent this > endif >endscan >