Answer / guest

No.

System.effective_date system variable is read only True/False

1 Answers  

---

Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;

2 Answers   TCS,

---

Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 Answers  

---

What is trigger associated with the timer?

2 Answers  

---

What are the two repeating frame always associated with matrix object?

1 Answers  

---

What are the differrent types of windows?

1 Answers  

---

What is a canvas in oracle forms?

0 Answers  

---

Why oracle forms required?

0 Answers  

---

What is the difference between $$DATE$$ & $$DBDATE$$

1 Answers  

---

how will the report recognize the parameter

1 Answers  

---

What is the difference between keystartup and pre-form ?

1 Answers  

---

HI GURUS, WHAT IS THE PURPOSE OF LEXICAL PARAMETER IN REPORT DEVELOPMENT.

2 Answers   Cap Gemini,

---