gkaindia.com

Home > > Problem with ranges

Problem with ranges

Advertisement
Hi Experts,
I have created 1 range
RANGES : r_fname FOR cdpos-fname.
I want to check that value of range name is available or not.
Please give me proper example of code so i can paste and check it.
I want to append it with in loop.
Can we do this ?
Regards,
N.Master
Advertisement
Hi
Ranges is very usefull when you would like to make a SELECT with a list of values.
instead of
select ... into table ... from ... for all entries in ... where ...
you remove the "for all entries in".
It's just a problem of performance. Because for all entries make a lot of database access.
The danger with the ranges is the size, greater than 3000 entries, you will have a dump.
Read the other 3 answers
hello,       i have a screen with a lot of drop down list boxes and input output fields.       if i select from list from listboxes and press 'DISPLAY DETAILS' then i get the record with respect       to the input from a database table(i have usd tab
I've just received a Home Hub 2.0 today in order to connect BT Vision and was excited to connect it and get my Vision box set up. Having had a Voyager 2091 router before, I disconnected this and proceeded to follow the instructions to the letter to s
There is misleading information in two system views (sys.data_spaces & sys.destination_data_spaces) about the physical location of data after a partitioning MERGE and before an INDEX REBUILD operation on a partitioned table. In SQL Server 2012 SP1 CU
I am having three problems with the Range 2D Column Flash Chart. 1. Series Name: I have two series one named AAA the other BBB. AAA returns two values AAA_MIN and AAA_MAX. BBB returns two values BBB_MIN and BBB_MAX. The Legend shows two series both l
Hi, i have a problem with the command on Cisco Device when i configure a range of Interface then i have this messages: /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Normale Tabelle"; mso-tstyle-rowband-size:0; mso-tstyle-colband-
Please help JDev version JDEVADF_11.1.1.7.0_GENERIC_130226.1400.6493 I am using range paging for one of the VOs. The VO is based on single table. The VO is bounded to af:table. We need to support both Oracle and SQL server. When database is Oracle ,
I live in new York and with cable vision boost am now able to get download speeds of over30 mb/s from time capsule as long as I am within the 2.4 ghz range - I got an older base station model mb053ll a to extend the range of the network but even thou
Good morning, people of the forum ... I have the following question ... Is there any sentence that tells me if a range is contained within another range of the same type?? ThanksI think the second answer is more appropriate ... But I do not think I e
My original Aiport Express stopped working this week, just went dead, replaced it with a new 2nd gen. one .... Wheras the original extended the signal through the house particularly to the living room, with this one, there is no signal at all. It's j
My display does not show anything less than 15% of a given color (even black). My old G-4 Sawtooth with Radius 20/e monitor showed color values all the way down to 3% ...Is this a hardware/display thing, or would a calibration device help me expand t
Hi Guys,                I have used Ranges and used a select statement for selecting those ranges but I am facing a problem. RANGES: r_doctyp for EDIDC-DOCTYP. r_doctyp-sign = 'I'. r_doctyp-option = 'EQ'. r_doctyp-low  = 'DEBMAS'. append r_doctyp. r_
Dear folks,                I am facing weird problem with range table in selection query.I have problem with bold part of code.Here when i give input to both ranges r_salesno,r_brandid then and the selection occurs ,when i put black in one of those i
Hi, I am running Bridge CS3 version 2.1. 100 on a MacBook Pro 3 Intel Core Duo 2.4 GHz, 2GB ram I am having some serious Bridge issues. My problems have ranged from it just being very sluggish and slow to Bridge not applying a label to random crashes
Dear Friends , I am using Oracle10g . I have to create a range partition like below : CREATE TABLE EMP EMPNO NUMBER(4), ENAME VARCHAR2(10 BYTE), JOB VARCHAR2(9 BYTE), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2) P
I've a bit of a dilemma here with how I'm going to implement this. I want to create a parameter that takes range values.  The field that this parameter will check against is a string field.  A range search does not work well for numeric string values
Hey everyone, I am new to xcelsius and need your support . Problem: Table range with information in spreadsheet will show in chart preview but will not appear once exported in the SWF. However, half of the information does show in the exported chart
Hi everybody, I am using ranges to select data from BSEG table. In a particular case the ranges table contains around 7000 entries, hence it leads to a short dump. Is there any limitation associated with ranges? with fewer number of entries it works
Hi, I bought a Palm Centro locked to Telstra for my son.  I have made 3 attempts to get this phone unlocked from Telstra: 1. Went into a Telstra shop, they rang the number for unlocking phones and I was given the unlocking code.  Unfortunately this w
Now I know this is not a typical issue, but I was hoping some of you may have some solutions. I just purchased an iPhone 4 for my brother. He loves it, but the problem is he works in harsh environments (namely, on top of roofs in FL needless to say i