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
Has this happen to anyone before? Will I be able to get my music, or money back?If for some reason you have failed to maintain a backup copy, then redownload it: Downloading past purchases from the App Store, iBookstore, and iTunes StoreRead other 2 [More]
I was trying to create an encrypted dmg file on a USB Drive. It was going smoothly, I had entered the password twice, and then 30 seconds later I got an error message: "unable to create "name-dmg" -illegal seek" I tried the Help menu, [More]
I am in the middle of a Exchange 2007 SP3 to Exchange 2013 Sp1/CU4 migration and am importing transport rules and it's failing. [PS] C:\Windows\system32>Import-TransportRuleCollection -FileData C:\2007TransportRules.xml -Verbose Cannot process argume [More]
I have installed EBS R12.2.0 Vision instance on Oracle Linux Server release 6.5 x86-64 with Unbreakable Enterprise Kernel release 3 (3.8.13-16.2.2.el6uek.x86_64) and then updated to R12.2.3.  Everything went smooth with the initial install, the AD an [More]
I am trying to figure out the best way to connect my iMac to a stereo receiver. Which option will result in superior sound on my home stereo: (1) running a TOSLINK cable from the iMac's optical digital audio out port to the receiver's optical input o [More]
I have converted all Framemaker v10 documents to v11 by opening and saving. However when opening the Book v11 for these documents and applying the 'clear all change bars' option a book error log message advises that the documents cannot be opened as [More]
How How do I change "Sharing & Permissions:" from "You can only read" to Read & Write on my backup Iomega like the rest of my mac?Open the Disk Utility in the /Applications/Utilities/ folder and run the Repair Disk command on i [More]
everytime i try to log in to gmail an alert comes up that says that there is an unsecure certifcate-the 1st for google that said it expired in 2009 and the next for mozilla that said it expired in 2010 and it won't let me enter into my gmail account [More]
I try to manage my n97 device to sync with Ovi and after I select my device on Ovi sync service it show that I should receive a text message to save it in order to create the sync profile in my device but nothing come and I just wait more than two da [More]
Hello, I am confused with item 4.4.1 from OBI Applications 7.9.6.3 installation manual... I´ve copied it bellow: +"The transactional (OLTP) database user that is registered in DAC should be the+ +database table owner. Alternatively, at a minimum, the [More]