Hi everybody,
I have very strange situation. I insert record into view, then requery(). Form shows, what view doesn't have records. However, underlaying table has a new record, which I just inserted. Even if I try to open this view in command window, it comes up empty. The record is definitely in the table. What cound be wrong here?
My code:
lnCustomerID=oJC.CustID
select CustomerInfo
requery()
set step on
if reccount()=0
insert into CustomerInfo (CustomerID, Modidate) values (m.lnCustomerID, datetime())
thisform.dotableupdate()
requery()
endif
===========================
lnCustomerID=6, I deleted this record from underlaying table few times and pack it. Each time the record was inserted correctly, but the view appears empty.
Here is the view SQL:
SELECT Customerspecific.*, Customer.company;
FROM stats!customerspecific INNER JOIN jobcontrol!customer ;
ON Customerspecific.customerid = Customer.custid;
WHERE Customerspecific.customerid = ?m.lnCustomerID
Could somebody help me here? I'm struggling with this problem more than hour now :(
If it's not broken, fix it until it is.
My Blog