Ok, disregard :) Finally I realized the reason. Took me 1h. :(((
In the customer table I just don't have CustID=6. Since I use Inner join, I got 0 result.
The mystery now is explained.
>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