Home » Developer & Programmer » Forms » THE ATTACHED FILE DIDN'T WORK WITH ME !!
icon5.gif  THE ATTACHED FILE DIDN'T WORK WITH ME !! [message #289409] Fri, 21 December 2007 07:15 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

THE ATTACHED FILE DIDN'T WORK WITH ME !!
Re: THE ATTACHED FILE DIDN'T WORK WITH ME !! [message #289410 is a reply to message #289409] Fri, 21 December 2007 07:22 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is it supposed to do? What happens when you run it? Any error message? If so, which one? Unexpected result? Something else?
icon8.gif  WELL .......... [message #289457 is a reply to message #289409] Fri, 21 December 2007 17:06 Go to previous messageGo to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

happened LIKE IN THE ATTACHED SCREEN SHOT ...... and I'm waiting for the answer

[Updated on: Fri, 21 December 2007 17:08]

Report message to a moderator

so ???? [message #289476 is a reply to message #289409] Sat, 22 December 2007 04:05 Go to previous messageGo to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

I'm still waiting for the answer !
Re: so ???? [message #289504 is a reply to message #289476] Sat, 22 December 2007 18:33 Go to previous messageGo to next message
shivaram9
Messages: 35
Registered: August 2006
Member
check if there are any records are fetched using tht cursor

first assign values then do go item.

:EMPLOYEES.EMPLOYEE_ID:=E;
:EMPLOYEES.LAST_NAME:=L;
:EMPLOYEES.HIRE_DATE:=H;
:EMPLOYEES.SALARY:=S;

use go_item(.....);

Try this, dont know if this will solve ur problem.
icon1.gif  Re: so ???? [message #289518 is a reply to message #289504] Sun, 23 December 2007 04:56 Go to previous messageGo to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

I did what you said
DECLARE
	CURSOR C1 IS SELECT EMPLOYEE_ID,LAST_NAME,HIRE_DATE,SALARY  FROM EMPLOYEES WHERE FIRST_NAME||' '||LAST_NAME = :BLOCK3.L ;
	E NUMBER;
	L VARCHAR2(22);
	H DATE;
	S NUMBER;
BEGIN
	OPEN C1;
	LOOP
		FETCH C1 INTO
		E,L,H,S;
		EXIT WHEN C1%NOTFOUND;
	END LOOP;
	
	--GO_BLOCK('EMPLOYEES');
	go_item('EMPLOYEES.EMPLOYEE_ID');
	:EMPLOYEES.EMPLOYEE_ID:=E;
	go_item('EMPLOYEES.LAST_NAME');
	:EMPLOYEES.LAST_NAME:=L;
	go_item('EMPLOYEES.HIRE_DATE');
	:EMPLOYEES.HIRE_DATE:=H;
	go_item('EMPLOYEES.SALARY');
	:EMPLOYEES.SALARY:=S;



EXECUTE_QUERY;

END;


but it still not working , and also give me 4 error messages
check out my attachment
  • Attachment: Desktop.zip
    (Size: 139.55KB, Downloaded 119 times)
Re: so ???? [message #290217 is a reply to message #289518] Fri, 28 December 2007 00:43 Go to previous message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
could you please try the following code:

DECLARE
	CURSOR C1 IS SELECT EMPLOYEE_ID,LAST_NAME,HIRE_DATE,SALARY  FROM EMPLOYEES WHERE FIRST_NAME||' '||LAST_NAME = :BLOCK3.L ;
	E NUMBER;
	L VARCHAR2(22);
	H DATE;
	S NUMBER;
BEGIN
	GO_BLOCK('EMPLOYEES');
	
	OPEN C1;
	LOOP
		FETCH C1 INTO E,L,H,S;
		EXIT WHEN C1%NOTFOUND;
		
		:EMPLOYEES.EMPLOYEE_ID:=E;
		:EMPLOYEES.LAST_NAME:=L;
		:EMPLOYEES.HIRE_DATE:=H;
		:EMPLOYEES.SALARY:=S;
	
	END LOOP;
END;
Previous Topic: problem with synchronization between multirecord block fields
Next Topic: Oracle Forms 6i Query Performance Issue and Oracle forms 6i performance issue (merged-djm)
Goto Forum:
  


Current Time: Wed Dec 07 12:37:04 CST 2016

Total time taken to generate the page: 0.08397 seconds