السلام عليكم ورحمه الله وبركاته


لدي جدول وفيه
-SLNO
- STKCD
-QTY


وعملت فورم للجدول ولكن أريد أن أضيف من جدول أخر عمود STKDESC

أريد حل لو سمحتم

لو العمود المراد اظهارة هو وصف لكود موجود فى عمود فى الجدول الرئيسى
يمكنك استخدام الزناد post-query
على مستوى ال block
بدلالة الرمز الموجود فى الجدول الرئيسى

Hi..
I think this column you want to add is adecription for STKCD column in your block.
1)so,,create a new field on your block and click f4 on it to define it's properties.
2)put these properties..
Name = STKDESC
Item Type = Display Item
Data Type = char
Maximum length = 250
Data Base Item  = No
Visible  = Yes
Canvas = (your canvas)

3) on STKCD field create a new trigger,,,(When-Validate-Item) :
begin
select STKDESC 
into      :stkdesc
from    stkdesc_table
where  stkdesc_id = :STKCD;
Exception
when no_data_found then
message('item not defined');
raise form_trigger_failure;
when others then 
message('w-v-i  '||:system.trigger_item||sqlerrm);
raise form_trigger_failuire;
end;

and put the same code on post query trigger on data block level BUT 
change the exception segment to :
Whe No_data_found then
null;
when others then
message('p-q  '||:system.trigger_item||sqlerrm);

GOOD LUCK

جزاك الله خير وجعله في ميزان حسناتك

شكراًً لك اخي عمار

Sir

First i define my block my block is stt_mqd there is colum stkcd we have another master table there is stkcd and stkdesc column, want when i run query my module show stock descreption in stkdesc.

I insert one desplay item in my stt_mqd block and write code as you given before.

but he is given error like this
"frm-40735 post-query trigger raised unhandled exceptin ora-00904" how i can resolve to this

i will be highly appriciate to if you kindly send me resolotion in rush

rgds

Mohammad

Hi..your problem arrises because you are not writing the correct field and block name .
-- correct your triggers like this .
and put instead of master_table the name of the block that has the stock description


on STKCD field create a new trigger,,,(When-Validate-Item) :
if  :stt_mqd.stkcd is not null then
begin
select STKDESC 
into      :stkdesc
from    master_table
where  stkcd  = :stt_mqd.STKCD;
Exception
when no_data_found then
message('item not defined');
raise form_trigger_failure;
when others then 
message('w-v-i  '||:system.trigger_item||sqlerrm);
raise form_trigger_failuire;
end;
end if;

on post-query on the block(stt_mqd):
if  :stt_mqd.stkcd is not null then
begin
select STKDESC 
into      :stkdesc
from    master_table 
where  stkcd  = :stt_mqd.STKCD;
Exception
when no_data_found then
:stkdesc := null;
when others then 
message('post_query  '||:system.trigger_item||sqlerrm);
raise form_trigger_failuire;
end;
end if;

GOOD LUCK

جزاك الله خير ياعمار و زادك الله علم

وأعتذر عن التأخير

أشتغلت معاي فقط في QUERY !!!


ولكن عند أدخال المعلومات لايظهر شئ وعند عمل QUERY يظهر DESC ؟؟