| Check Box! URGENT [message #87213] |
Tue, 14 December 2004 04:37  |
Scoodels
Messages: 8
Registered: November 2004
|
Junior Member |
|
|
Hi
I have a multi record block based on a VIEW from Two tables.
When I check some of the records displayed and want to update them, all the checked records are not being updated. Only the last record checked is being updated. I know I should loop it some how.. but not able to figure it out. Could any body help me in this with a small sample code.Its kind of URGENT.
Thanks
Scoodels
|
|
|
|
| Re: Check Box! URGENT [message #87259 is a reply to message #87213] |
Wed, 15 December 2004 13:25  |
Just John
Messages: 69
Registered: November 2004
|
Member |
|
|
Not knowing you form.....
check that you have the database columns set for the item you are updating, you should be able to update via the view (check in SQL+). You shouldn't need to loop as long as you are setting the database column for each record in the block.
If this is not the case then you can perform a simple loop such as:
FIRST_RECORD;
WHILE system.last_record != 'TRUE' LOOP;
:block.item := 'value';
NEXT_RECORD;
END LOOP;
check syntax before you run it!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
