| insert records [message #121671] |
Tue, 31 May 2005 07:22  |
jonmich005
Messages: 53
Registered: April 2005
|
Member |
|
|
Hello
I have 2 datablocks, one with intervals and one with actions.
My datablock interval exists out of an id and a name. It has 20 reocrds.
Now my other datablock exists out of tl_grid_int_1 to tl_grid_int_20.
When I click on a button, I can insert a record in my datablock interval. I know how to do this but I can insert them in the middle of all my other items. So every item after my inserted record has to move one place to th right.
Now my question is how can I also do this for my other datablock.
I have the following code:
while act<100 loop
update lds_tl_grid
set tl_grid_int_2 = (select tl_grid_int_1 from lds_tl_grid where tl_grid_veh_id = :global.vehicle and tl_grid_scen = :global.scenario and tl_grid_id = act)
where tl_grid_veh_id = :global.vehicle
and tl_grid_scen = :global.scenario
and tl_grid_id = act;
commit;
execute_query;
act:=act+1;
end loop;
The tl_grid_int_2 has tobe replaced by something like tl_grid_int_||int_id, but this doesn't work.
Is this not possible in a select-statement?
What else can I do?
Greetings Jonas
|
|
|
|
| Re: insert records [message #121786 is a reply to message #121671] |
Wed, 01 June 2005 00:42  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
You have already put this question in, and that was only 2 hours ago. Give us some time to answer please. Go look at your first question for an answer.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
