Search results for query: *

In Forms I fill non database datablock (some protocol computing... more 100 records). Can i create reports based on this datablock? or can i get values of datablock as parameters in reports?

i want to use on-line chart in form... i try to use Microsoft Grath 2000 object. but...how i can define data source in this object?

thanks sem. In other words, i need to use "insert_record" built-in? Block chk_inv exist already...then :date_rev:=dt1; select sum(amount) into :sum_42301_rur from delta.lim... select sum(rez) into :sum_42301_val from delta acl.. go_block(chk_inv); insert_record; post; It's correctly way?

how can i avoid error "frm-40405..."? i have next text: system.message_level:='10'; synchronize; .... INSERT INTO DELTA.chk_inv@DELTA_DBL (date_rev, sum_42301_rur,sum_42301_val,chk_42301.... COMMIT; go_block('chk_inv'); clear_block(no_validate); execute_query; Why? After second...

Hm.. How I can use lexical variable in this example? I try as follow blk_id:=find_block('OVD'); ss:='SELECT iovdacc,dovdcrt,dovddbt... FROM igg.ovd a,... WHERE iovdacc=iaccacc and ... order by dovdcrt desc'; set_block_property(blk_id,QUERY_DATA_SOURCE_NAME,SS); go_block('OVD')...

I have follow text: cursor ovd_open ( ind varchar2) is SELECT iovdacc,dovdcrt,ccusname... FROM igg.ovd a,... WHERE iovdacc=iaccacc ... order by ind; begin list_id:=find_item('LIST_DR'); if :list_dr='LIST314' then tt:=' dovdcrt desc '; ELSIF :list_dr='LIST315' THEN tt:=' ccusname'...

hm... 8.1.7.4 version...

i write follow instruction : CURSOR DL (dt1 DATE,dt2 DATE) IS select ipcrcard, dpcrsdt, dpcrfdt, ipcracc, f.ccknname, h.cognsname, case when cognsname is null then 'natural person' else cognsname end,ccusname,cncrhtp from dfc, trm..... but show error: "encountered symbol CASE, when...

sorry, i make this operation first time (...not enough experience). How i can perform this operation correct? if only i see any example... thanks.

On the form i've got data block as tabular list. I want delete record and then to stay on the next record... go_block('card_cnt'); n_rec:=to_number(:system.trigger_record); delete from card_cnt where id:=:card_cnt.id; clear_block(NO_VALIDATE); execute_query...

thank's, Sem. it need write full path to report's file....

I correct this..but now reports not response.. Reports background engine type that unable open 'vyp_par.rep Error while opening or saving a document. What is this? if i run this report without parameters repid := find_report_object('VYP'); v_rep := RUN_REPORT_OBJECT(repid); all ok. ...

I try to run report with parameters from my form. In my report i define four user parameter: acc - number(25) cur - char(3) date1 - data ('DD.MM.RR') date2 - data ('DD.MM.RR') Trigger "when-mouse-click" PushButton in my form: declare repid REPORT_OBJECT; v_rep VARCHAR2(100)...

thanks, bookouri...! creating procedure solve problem...

I select "Pre block" trigger and type: if :fc.rc=3 then :fc.resp:='Invalid Merchant'; elsif :fc.rc=55 then :fc.resp:='Invalid transaction'; elsif :fc.rc=75 then :fc.resp:='Invalid PIN'; end if; but :fc.resp is empty on the form... What do I make wrong?

i write this code in item "Calculation formula " of property palette (item "resp"). I get error "Encountered the symbol "IF" when..." :fc.resp - calculation field coupled with :fc.rc follow conditions: if :fc.rc = 1 then :fc.resp='Invalid merch' elsif...

I need define calculation field (:fc.resp) with condition: if :fc.rc=1 then :fc.resp:='Invalid merch' elsif.... end if. but this expression generate error in property palette. I try to use function "decode" and get the same result... Where i wrong?

Thanks...Dim. of course, about Forms... (rather List item, than Tlist object...refuse) sorry, once more

Sorry, may be stupid questions... How I can get current value Tlist objects? Elements in Tlist i fill in property palette...

1. As i fill data block from procedure, i set follow: Query data source type - None Database data block -Yes Query allowed - Yes 2. Error: FRM-41003 - this function cannot be perform here.