Home » Developer & Programmer » Forms » Getting Convid but not transferring the Data
Getting Convid but not transferring the Data [message #360663] Fri, 21 November 2008 23:53 Go to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Getting data from one table and saving into a new table
Next Topic: Blobs Datatypes
Goto Forum:
  


Current Time: Fri Dec 09 23:35:19 CST 2016

Total time taken to generate the page: 0.24128 seconds