| Adding item to the Datablocks [message #176917] |
Mon, 12 June 2006 00:29  |
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
|
Senior Member |
|
|
Hi,
I have 2 text boxes ,1 Button and 1 data block with 2 items.
It is like purchase entry module, whenever i press Button ,
Two values should go to datablocks.
I have attached the screen,Just go through it and tell me how to do that.Finally i have to save from that data blocks
Regards
Selva.R
|
|
|
|
|
|
|
|
|
|
| Re: Adding item to the Datablocks [message #182119 is a reply to message #181975] |
Thu, 13 July 2006 03:18  |
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
|
Senior Member |
|
|
Thanx,
But i am facing one more problem,
I have to count the number of rows in the block and i have to insert each values into database.(This process should take place after i enter the all values in the blocks)
Thanx and regards
Selva.R
|
|
|
|
| Re: Adding item to the Datablocks [message #182142 is a reply to message #182119] |
Thu, 13 July 2006 04:42 |
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
|
Senior Member |
|
|
Hi ,
I tried to use following code:To save the values from Block
its showing that unable to insert a record
Go_block('ITEM_MASTER');
First_record;
Loop
if (:item_master.item_code is not null or :item_master.numbers is not null ) then
insert into forms_ex values (:item_master.item_code,:item_master.numbers);
Exit when :item_master.item_code is null or :item_master.numbers is null;
Else
Message('Values Saved');
End if;
end loop;
Kindly go through this code and tell me the solution
Thanx and Regards
Selva.R
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
