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 have a new 2 TB Time Capsule and a new Airport Express that I puchased to update my old set-up of an Airport Express and Airport Extreme. I have the TC set-up as the primary base station in the back of the house and the airport express set-up to ex [More]
Dear Experts I am developing what I thought would be a very simple Web Module Project for a simple webservice to allow a user to logon to Netweaver Portal with a simple logon and password. I have not done this in over 8 years, and am somewhat rusty. [More]
I can't see any video previews in itunes even though I hear the audio (either in the artwork window or the itunes store window). Anyone able to help? Thanks!I could not find processor speed requirements listed anywhere. For future reference, they're [More]
My once reliable & rock-solid Apple iSight camera just started acting strange, sometimes it will provide picture perfect video and now suddenly when using Skype the picture has a venetian-blind effect with the video inverted upside down (interlacing [More]
Hi, we are currently starting with the installation of BPC 7.5 NetWeaver. The BW system is running on AIX servers, the .net servers for the BPC application are available. Next step is the installation of the BPC software and service activation on the [More]
I'm currently doing some game development, targeting iOS and Android devices using Flash Pro and AS3.  I'm doing my best to keep the code highly optomized and doing as much object pooling as possible. So far, I'm very pleased with how smooth everythi [More]
Hi All , 1. I did the test run in 'AFAB'  . SAP throwed the error becasue of some problem in Cost Center. 2. So i fixed that bug and tried again .   3. But when i see the Asset Explorer  for that asset '1234',  Asset value of the Error Doc got posted [More]
Need help getting Digital Editions to recognize new NookI'm having same problem with new iPad Mini. My public library that I connect with suggested that maybe I have too many devices (only allowed 6) attached to the Adobe ID, even though this is not [More]
I tried to install oracle 9.2.0.4.0 in redhat enterprise linux AS4.but it gives me too many errors. I Serarched throgh some documents and found that before installing it,it have to be some packages installed. So I need patch number 4198954.(compat-or [More]
I am unable to recover my purchased ringtones from the itunes store. Does anyone know how to do this?My account's balance shows at the top left of the store's page on my computer's iTunes, and by logging in to view my account via the Store > View Acc [More]