Sitemap

Amicuk Programming Answers

Multiple Selection on a block

-0001-11-30   Views:0

Advertisement

Hi experts, How can i make multiple selection on a detail block (in ascending order) and save the selected data on database.? can i have a sample code please? Thanks, mr. baguhanbaguhan, then replace with this code. DECLARE Num_Total_Records NUMBER;

Hi experts,
How can i make multiple selection on a detail block (in ascending order) and save the selected data on database.?
can i have a sample code please?
Thanks,
mr. baguhan

The replay answer
Advertisement
baguhan,
then replace with this code.
DECLARE
Num_Total_Records NUMBER;
Num_Loop_I           NUMBER;
BEGIN
GO_BLOCK(<BLOCK_NAME>);
FIRST_RECORD;
LAST_RECORD;
Num_Total_Records := TO_NUMBER(NAME_IN('SYSTEM.CURSOR_RECORD'));
FIRST_RECORD;
FOR Num_Loop_I IN 1..Num_Total_Records LOOP
IF <CHECKBOX> = 1 THEN
<................................................>
END IF;
NEXT_RECORD;
END LOOP;
<................................................>
END;
Regards,
Manu.

Go to See the other 8 answers

Multiple Selection on a block

Category:DefaultRelease time:-0001-11-30Views:130

Hi experts, How can i make multiple selection on a detail block (in ascending order) and save the selected data on database.? can i have a sample code please? Thanks, mr. baguhanbaguhan, then replace with this code. DECLARE Num_Total_Records NUMBER;[More]

Multiple selection in a detail block

Category:DefaultRelease time:-0001-11-30Views:130

In a scenario where there is a master-detail-detail block structure, is it possible to select several records of the first detail block and enter a record for them in the second detail block? Thanx in advance. P.S. please excuse me if the question so[More]

Create a custom multiple selection on screen - not selection-screen block

Category:DefaultRelease time:-0001-11-30Views:130

Dear expert, I created a text field on screen for input selection, e.g field bname for USR02-BNAME. How can i create a CUSTOMIZE multiple selection plus a paste (from clipboard) feature on this screen (e.g. SCREEN 0002) like standard selection-screen[More]

Multiple select staement in 1 query

Category:DefaultRelease time:2015-10-11Views:130

Hell Team, I am New to this SQL world. Please help me out with htis:- I have following queries:- #select name from v\$database; #select log_mode from v\$database; #select count(*)"INVALID_OBJECTS" from dba_objects where status='INVALID'; #select[More]

Setting property attribute values for multiple selected objects.

Category:DefaultRelease time:2015-10-11Views:130

Hello, Is there an easy way to set the attribute property values for more that one selected Table Operator Attribute (column) at a time. For example the target table has over 100 columns but I only want to INSERT/UPDATE 10 of those columns. The gener[More]

X3-02 does not support multiple selected delete me...

Category:DefaultRelease time:2015-10-11Views:130

I have call Nokia Singapore on the issues that X3-02 does not include the feature for all or multiple selective delete message receive. Imagine spam message send to your mobile phone and you have to spend time to  delete one at a time. This waste use[More]

How to disable the SELECT-OPTINS multiple selection screen's Ranges options

Category:DefaultRelease time:2015-10-11Views:130

Hi this is sekhar,                   I have used the Select-options: statement with 'No-Interval' option. Now I need to restrict the user not to enter the values in the Ranges column of multiple selection screen. How can I do it....You can also refer[More]

Multiple selection screen.

Category:DefaultRelease time:2015-10-11Views:130

hi all,        how to create multiple selection screens, i need 3 selection screens how to do it? wats the maximum number selection screen can be created in a report. regards SuprithSELECTION-SCREEN BEGIN OF SCREEN 100 AS SUBSCREEN. PARAMETERS: p1 TY[More]

Multiple selection in F4

Category:DefaultRelease time:-0001-11-30Views:130

hi, i use this code to f4 help and its working o.k. what i wont is multiple selection  like to choose 3 or more employee  how i can do that? REPORT ZV_SMART_SEND1. TABLES: PA0002. *DATA: ITAB LIKE PA0002 OCCURS 0 WITH HEADER LINE. DATA: BEGIN OF ITAB[More]

Why the multiple selection can't work in sub screen

Category:DefaultRelease time:-0001-11-30Views:130

hi experts:      when i try to use the sub-screen in the report,why the multiple selection function(SO_BCTXT) can't work normally in screen 1095: the coding as below.will reward points if solve this issue the main program in Subscreen: PROCESS BEFORE[More]

How to create multiple selection screens in reports

Category:DefaultRelease time:-0001-11-30Views:130

How to create multiple selection screens in reports Thanks, SridharEx: hope you will find an idea from the below example : SELECTION-SCREEN BEGIN OF BLOCK SEL1 WITH FRAME TITLE TIT1. PARAMETERS: CITYFR LIKE SPFLI-CITYFORM,             CITYTO LIKE SPF[More]

Hot
I am about to go from a Treo 680 to a palm pre and decided to download the 6.2.2 version of the palm software.  This is the version I need to use the 3rd party software to sinc my new palm pre and my lap top. my data is corrupted,,any suggestions,,, [More]
I have a macbook pro 2.4 ghz intel core 2 duo 2010 13" aluminum with 8gb of memory and a 250gb hard drive running version 10.6.8 with safari 5.1.4. Safari will open up intermittently on its own. System preferences and the dock isn't set up to start s [More]
I have 2 G5's, I installed Leopard and FCEHD3 on the one rig yesterday, but it doesn't see the camera (Canon XHA1) likewise using Tiger 10.5. When I go to Setup I don't have the full preference menu (only 4 settings in NTSC & PAL) What do I need to a [More]
yesYou are right, but how could i send it to Apple? when the phone company first replaced my iphone they had in stock alots of iphones and they just sent mine back to Apple and gave me a new one, so all i did is to give them my phone, but now how cou [More]
Hi Guys, Maybe someone can help me out? I just finished setting up a trial "Cisco Virtual Wireless Controller" with nearly the same configuration as our Physical "Cisco Wireless Controller" with the exception of having 2 ports.  Anyhow [More]
I have many songs on my IPod and playlists but when I put the IPod on Shuffle (as I usually do) it always seems to play from a small list of these songs and doesn't seem to shuffle through the whole playlist or library. All songs are checked in my IT [More]
Please can somebody help me? My imessage does not work, I try to activate it but it says an error ocurred during activation. try again Its possible that the server can be down now. Have you ever used it before?  If you want, try resseting the phone b [More]
Looking for a way to have a drop down of people or companies. When you select a company the city, state, etc the indo will auto fill text boxes. what is my best options to go about this? I have been trying to use this http://acrobatusers.com/tutorial [More]
Here is a weird one. When I drop a clip into the "Roadtrip" open sequence the clip somehow gets flipped. Meaning it is a mirror image of itself. Why does it do this? Also - is there anyway you can have the theme just spill over the remaining foo [More]
Hi Experts                               I am experiencing dump while attempting to create Schedule agreement/contract.                               Error analysis                               The system attempted to use dynpro 0201 in program "SAP [More]