I have a view that looks like this:
SELECT Inv_type.inv_type_name, Invoice.grpid, Invoice.plnid,;
Invoice.bill_date, Invoice.rx_amt, Invoice.claimfee_amt,;
Invoice.rebate_amt, Invoice.comms_amt, Invoice.misc_amt, Invoice.amt_due,;
Invoice.orgid, Invoice.inv_key, Inv_type.inv_type_key,;
Invoice.carrier_id, Invoice.account_id, Invoice.group_id;
FROM ;
invoice Invoice,;
inv_type Inv_type;
WHERE ( ( ( Inv_type.inv_type_key = Invoice.inv_type_key;
AND Invoice.group_id LIKE ( ?lcGroup_ID ) );
AND Invoice.carrier_id LIKE ( ?lcCarrier_Id ) );
AND Invoice.account_id LIKE ( ?lcAccount_ID ) );
AND Invoice.inv_key NOT IN (SELECT Invoice.inv_key FROM Acctrecv,Invoice Where Acctrecv.inv_key = Invoice.inv_key AND Invoice.group_id LIKE ?lcGroup_ID AND Invoice.Carrier_ID Like ?lcCarrier_Id AND Invoice.Account_ID Like ?lcAccount_ID);
ORDER BY Invoice.group_id, Invoice.bill_date DESC
....My problem is that 99% of the time when I requery() this view it works just fine...but sometimes I get an error when I try to Requery() that says "Base table fields have been changed and no longer match view fields. View field properties cannot be set." Now I know what this means so I've tried to recreate the view a zillion times, but I still have the same problem. I don't understand why most of the time it works and sometimes it doesnt...I mean if the table fields dont match the view fields then the stupid thing should work any of the time, right? I'm at a total loss here & my client would kinda like to run their report...does anyone have a clue as to what the problem is here?
ICQ 10556 (ya), 254117