Subject | ib_query with left join invalidaterownum() problem |
---|---|
Author | james_027 |
Post date | 2004-11-11T01:05:50Z |
I have ib_query containing the following sql ...
SELECT M.*,
(select description from account_titles_details d where d.id =
m.expense_type) as Account_Title,
D2."InvNo"
FROM CHECKVOUCHER_DETAILS M LEFT JOIN "invoice" d2 on d2.id = m.doc_id
What I want to achieve here is that after posting a new record I want
the new record to immediately display the d2.InvNo column. My problem
is that after the post the d2.InvNo value is not display until the
ib_query is close and open. What I did is to perform
ib_query.invalidaterownum(ib_query.recno) or ib_query.refresh but Iam
getting an error saying ambiguous field name between table
checkvoucher_details and table invoice ID.
Has anybody come across this kind of situation? Any tips?
Thanks.
Regards,
James
SELECT M.*,
(select description from account_titles_details d where d.id =
m.expense_type) as Account_Title,
D2."InvNo"
FROM CHECKVOUCHER_DETAILS M LEFT JOIN "invoice" d2 on d2.id = m.doc_id
What I want to achieve here is that after posting a new record I want
the new record to immediately display the d2.InvNo column. My problem
is that after the post the d2.InvNo value is not display until the
ib_query is close and open. What I did is to perform
ib_query.invalidaterownum(ib_query.recno) or ib_query.refresh but Iam
getting an error saying ambiguous field name between table
checkvoucher_details and table invoice ID.
Has anybody come across this kind of situation? Any tips?
Thanks.
Regards,
James