| Please Help......Using Cursor for picking up values at runtime [message #243063] |
Tue, 05 June 2007 20:30  |
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 #243238 is a reply to message #243063] |
Wed, 06 June 2007 10:32  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
