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
Hey everyone, just came across this forum looks quite good so I'll give it a go smile.gif Just working through a book called 'Objects First with Java' and I'm stuck on exercise 4.31. This is about a small auction program that has 4 classes - auction, [More]
Dear All, Issue is regarding Bill Of Exports Scenario applicable to the Customer who belongs to Special Economic Zones (SEZ’s). We have two Cases: 1.     SEZ sales With Duty Draw Back i.e., Bill of Export of goods claim for duty drawback. 2.     SEZ [More]
My father bought me a prepaid iphone 4 from korea. I can't tell if the phone is unlocked or not because when I'm tring to put a diffirent miro sim other than the SK Telecom it display an error "Sim Failure". If its locked how can I contact SK Te [More]
I upgraded my SL510 with a new SSD and installed Windows 8.1 x64. Now some of my fn keys are not working anymore. For example: fn + Insert (=print) is still working, fn + F5 (=Wifi) is not working anymore. The only possible fix for this I found in my [More]
I have had an HP Pavillion dv6000 for a few years, and suddenly, it will not power up at all.  I can not determine that anything at all happens when I press the power button.  What's weird is that when I connect the power, the AC LED (the one with th [More]
Hey guys, I noticed this a couple weeks ago when I was on vacation. When my iPhone screen has direct sunlight shining on it, it has a white/gray border around the LCD (e.g., when the phone is unlocked on the home screen). I was wondering if this was [More]
Hello, I run a data recover data program last night. This morning the computer was on the screen saver mode but when I restarted it, nothing happened. I just have the Apple logo with the gray wheel or simply a white screen with a DON'T sign on it (a [More]
Dear sir I recd following error when i try to run following command in oralce 10g xe sql command select dbms_xmlgen.getxml('select doc_no from sales') xml from dual; ORA-04067: not executed, package body "EXCISE.DBMS_XMLGEN" does not exist ORA-0 [More]
Imovie cannot find songs in itunesYou need to create a play list of songs that you would use for movies - mine is called Music for Movies.  Then when you click on the music icon (the first box in the line of 5 in the grey bar across the lower third o [More]
Any thoughts anyone~been digitizing through daisy chained 4 assorted drives to find my clips consistently out of sync. Then tried straight on to one drive or on to hard drive and it seems fine. Will i lose sync through daisy chaining drives ? I had n [More]