Binding a result of a query to a textbox variable
From: Mike Phillips <philm_at_twsot.com>
Date: 1999/10/06
Message-ID: <%pGK3.12019$w8.246170_at_wbnws01.ne.mediaone.net>#1/1
Date: 1999/10/06
Message-ID: <%pGK3.12019$w8.246170_at_wbnws01.ne.mediaone.net>#1/1
Hi,
I am trying to insert into a textbox, the value returned by a query. I am
using:
where :employee.txt_company = company.companyname;
:company.txt_company is a textbox value that contains the name of the
company that user entered.
"FRM-40735 PRE-INSERT Trigger raised unhandled exception, ORA-06502"
What is this message ? How can I assign the result of the query to a
textbox variable?
SELECT company.companyid into :employee.companyid from company
Based on that name, I want to search the company table for the ID of this
company and display that
ID onto :employee.companyid textbox. But the code gave me the following
error:
Thanks,
Mike
Received on Wed Oct 06 1999 - 00:00:00 CEST