OraFAQ Forum: Forms » Transfer data from forms6i to excel & image item (merged)

Home » Developer & Programmer » Forms » Transfer data from forms6i to excel & image item (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Transfer data from forms6i to excel & image item (merged) [message #80017]

Fri, 02 August 2002 06:58

sivaprakash
Messages: 1
Registered: August 2002

Junior Member

Hi,
Is there any possibility is there to transfer data from forms 6i to Excel.If so please inform me as soon as possible.
Advanced Thanks,
sivaprakash

Report message to a moderator

Re: Transfer data from forms6i to excel [message #80021 is a reply to message #80017]

Fri, 02 August 2002 22:11

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Use DDE package. Some help is also provided in Forms.
You need to poke the application and then write to excel.

HTH.

ManishM.

Report message to a moderator

Re: Transfer data from forms6i to excel [message #80027 is a reply to message #80017]

Sun, 04 August 2002 09:13

Swamy
Messages: 78
Registered: June 2002

Member

If you want to transfer data to Excel through Forms, you can use TEXT_IO package. This is same like UTL_FILE. For the output file you need to give extension as XLS.

Report message to a moderator

Re: Transfer data from forms6i to excel(if u have better solution then plz mail it to me [message #80101 is a reply to message #80017]

Sun, 11 August 2002 20:48

neeraj sharma
Messages: 4
Registered: January 2002

Junior Member

AppID  PLS_INTEGER;
C1onvID  PLS_INTEGER;
rc  varchar2(8);
rc1  varchar2(8);
Buffer1   VARCHAR2(550);
Buffer2   VARCHAR2(550);
ConvID1  PLS_INTEGER;
m_file varchar2(20);
p_file varchar2(100);

BEGIN
  m_file := 'c:abc.xls';
  p_file := 'c:progra~1micros~1officeexcel.exe '||' '||m_file;
  AppID := DDE.APP_BEGIN(''||p_file||'',DDE.APP_MODE_MINIMIZED);  
  ConvID1 := DDE.INITIATE('EXCEL', ''||m_file||'');

go_block('sale_detail');
i:=3;

C := 'R' || LTRIM(RTRIM(TO_CHAR(I))||'C'||LTRIM(RTRIM(TO_CHAR(J))));
DDE.APP_FOCUS(AppID);  
DDE.poke(ConvID1,RC,np,DDE.CF_TEXT,1000);
j:=j+1;
RC := 'R' || LTRIM(RTRIM(TO_CHAR(I))||'C'||LTRIM(RTRIM(TO_CHAR(J))));
DDE.APP_FOCUS(AppID);  
DDE.poke(ConvID1,RC,np1,DDE.CF_TEXT,1000);
j:=j+1;
RC := 'R' || LTRIM(RTRIM(TO_CHAR(I))||'C'||LTRIM(RTRIM(TO_CHAR(J))));
DDE.APP_FOCUS(AppID);  
DDE.poke(ConvID1,RC,np2,DDE.CF_TEXT,1000);
j:=j+1;
RC := 'R' || LTRIM(RTRIM(TO_CHAR(I))||'C'||LTRIM(RTRIM(TO_CHAR(J))));
DDE.APP_FOCUS(AppID);  
DDE.poke(ConvID1,RC,np3,DDE.CF_TEXT,1000);
j:=j+1;
RC := 'R' || LTRIM(RTRIM(TO_CHAR(I))||'C'||LTRIM(RTRIM(TO_CHAR(J))));
DDE.APP_FOCUS(AppID);  
DDE.poke(ConvID1,RC,np4,DDE.CF_TEXT,1000);
j:=j+1;
RC := 'R' || LTRIM(RTRIM(TO_CHAR(I))||'C'||LTRIM(RTRIM(TO_CHAR(J))));
DDE.APP_FOCUS(AppID);  
DDE.poke(ConvID1,RC,np5,DDE.CF_TEXT,1000);
j:=j+1;

this works as i have created reports in excel thru this code in forms.

Upd-mod: Add 'code' tags.

[Updated on: Wed, 01 February 2006 23:00] by Moderator

Report message to a moderator

image item [message #157254 is a reply to message #80017]

Wed, 01 February 2006 05:16

visuvasanelson
Messages: 3
Registered: February 2006
Location: CHENNAI

Junior Member

Hi,
Is there any possibility is there to transfer image type (database item) from Forms6i to word application using DDE commend.
so please inform me as soon as possible.
Advanced Thanks,

Report message to a moderator

Re: Transfer data from forms6i to excel [message #157256 is a reply to message #80101]

Wed, 01 February 2006 05:19

visuvasanelson
Messages: 3
Registered: February 2006
Location: CHENNAI

Junior Member

Hi,
Is there any possibility is there to transfer image type(database item) from Forms6i to word application using DDE commend
so please inform me as soon as possible.
Advanced Thanks,
Regerds
visuvasanelson

Report message to a moderator

Previous Topic:	alter database trigger in forms
Next Topic:	Forms LOV

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:42:49 CDT 2024