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
HI I am using Transaction F110 – Automatic Payment. When I am scheduling job for printing in background,I am getting error The error <Status Text in spool > states front end unavailable. Any inputs asap plsYou are getting the error because, the prin [More]
Got an iMac with a FireWire drive set up as a TimeMachine volume. In addition, I have a MBP, connected to the network via Wifi (Airport Extreme). Under Snow Leopard, both Macs were able to do TimeMachine updates to the FireWire drive connected to the [More]
With Coherence 3.3.1/389 using extend TCP client. We have our own customized HashMap implementation which extend java.util.HashMap<String,Object>. The class are something like this : public class SimpleMapStorage<T,V> extends HashMap<T,V> [More]
Any suggestions for a good USB wireless adapter. Like to put the emac G4 upstairs in the kids room as it has been a great computer.How well such an adapter works depends on whether the eMac has USB 1.1 or USB 12.0. The fast way to tell is to do "Abou [More]
I am running Windows ME. How should I set up a Maxtor ata100 20gig HDD, Internal CDRom/writer, Internal DVD player, Internal Colorado Tape back up drive (all on IDE connectors) on the 875P motherboard, P4 2.8? I also have a 6gig Fujitsu ata33 HDD but [More]
We have created reports through report painter where we can see all the cost elements and cost cenetrs . Variance  GL accounts are not there as they have not been created as cost elements .Is there any way to get GL accounts in the report painter rep [More]
hello All Any recommendation on book for performance tuning for above thanksAnd : help on how to study for 1zo-054 One Book I would recommend is SQL Tuning by Dan Tow. Great resource for performance tuning for certification and on job.Read other 4 an [More]
Hi I've spent all day on a sequence. I then imported a project from iMovie, which was simply exported at 'Full Quality', but there were audio issues (audio fades not recognised). I tried importing the iMovie session and got a series of folders, with [More]
Unable to buy anything on my Touchpad app catalog. Error PMT03043 when trying to buy. How to clear existing catalog account and set it up again - hope this solves the problem ? There's no billing info set up in the existing account. App catalog does [More]
On a Powerbook G4 12". In both MS Word and Nisus Writer Pro the 'option+spacebar' combination that should produce a non-breaking space does nothing whatsoever. The option key works fine in other combinations but not that one. As it's across applicati [More]