Home » Developer & Programmer » Forms » Please Help......Using Cursor for picking up values at runtime
Please Help......Using Cursor for picking up values at runtime [message #243063] Tue, 05 June 2007 20:30 Go to next message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

Hi All
i met with a problem when i used cursors for picking up a number of records at runtime
I will make you understand this way

I got all the employees (multiple records) against the specific dept in one form at runtime (using execute_query)
When i tried to update each employee's record using cursor, cursor would only pick up the first value(employee) and leave the rest of it
I used this select statement in Cursor
Cursor c_temp is select :employee.employee_name from employee

If someone wouldn't understand it yet, i can further explain it

I will highly appreciate if someone help me in this regard

[Updated on: Tue, 05 June 2007 20:50]

Report message to a moderator

Re: Please Help......Using Cursor for picking up values at runtime [message #243110 is a reply to message #243063] Wed, 06 June 2007 02:16 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Why use cursor? If you have to, have you tried make that cursor complete with fields you want to be updated?
Re: Please Help......Using Cursor for picking up values at runtime [message #243238 is a reply to message #243063] Wed, 06 June 2007 10:32 Go to previous messageGo to next message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
when you use that SQL query in the Cursor, the cursor will keep picking up the name only for the record where the line is in the block.

the query :: select :employee.employee_name from employee however will execute and will show as many records as you have in the employee table and all with the same employee name which it is picking up from the current record of current block of the form.

regards
Re: Please Help......Using Cursor for picking up values at runtime [message #246828 is a reply to message #243238] Fri, 22 June 2007 02:26 Go to previous message
ganesh_jadhav0509
Messages: 63
Registered: May 2007
Location: Chester
Member

u can use loop with row count and rownum
Previous Topic: how to update the records
Next Topic: tree list help me experts.
Goto Forum:
  


Current Time: Thu Dec 08 14:10:39 CST 2016

Total time taken to generate the page: 0.23605 seconds