Select home_phone into :t_phone from cust_prof ...
Shujaat H. Siddiqui heeft geschreven in bericht
<3720CFCA.7284_at_dataprompt.com>...
>I tried to do WHEN-VALIDATE-ITEM on the home_phone text item, and build
>a trigger. But for some reason it is keep giving me error:
>The trigger goes like this:
>
>select home_phone from cust_prof
>where :customer.home_phone = cust_prof.home_phone;
>if SQL%NOTFOUND then
>call d:\orawin\form45\cust_pr.fmd',No-Hide,NO_QUERY,DO_REPLACE);
>end if;
>
>But it gives me error on "from" part.
>
>I will appreciate it if someone could help me out please.
>
>My email address is s_shujaat_at_hotmail.com.
>
>Thanks for your help in advance.
Received on Fri Apr 23 1999 - 16:10:12 CDT
