| Getting Convid but not transferring the Data [message #360663] |
Fri, 21 November 2008 23:53  |
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
|
Member |
|
|
Hello All,
I am transferring data form excel to form6i,
I am getting the Convid but my data is not getting transferred to form. same code was running last night.but today the same code is not working.
i am using
/***************************************************/
filename := GET_FILE_NAME();
MESSAGE(filename||'filename');
AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\Office10\EXCEL.EXE '||filename, DDE.APP_MODE_MINIMIZED);
MESSAGE(AppID||'AppID');
WHILE NOT conv_established LOOP
BEGIN
ConvID := DDE.Initiate('EXCEL',filename);
conv_established := TRUE;
EXCEPTION
WHEN DDE.DMLERR_NO_CONV_ESTABLISHED THEN
conv_established := FALSE;
END; -- loop
END LOOP;
MESSAGE(ConvID||'ConvID');
GO_BLOCK('JODTLS_BLK');
loop
DDE.Request(ConvID, 'R'||I||'C3', v_CTR_NO , DDE.CF_TEXT,1000);
/***************************************************
Regards:
Sunil Madnani
|
|
|
|
| Re: Getting Convid but not transferring the Data [message #360775 is a reply to message #360663] |
Mon, 24 November 2008 00:32  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
PC are mindless. If it worked yesterday it will work today unless you changed something? Did you move the form to another directory? Are you running the code from within Forms Builder or from a directory via the browser? have you tried recompiling and regenerating the form?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
