-
function CF_3Formula return Number is
-
begin
-
IF :DLY_TYPE='BEFORETIME' THEN
-
SELECT COUNT(:DLY_TYPE)INTO :CP_1 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='BEFORETIME';
-
RETURN :CP_1;
-
ELSIF :DLY_TYPE='DELAY' THEN
-
SELECT COUNT(:DLY_TYPE)INTO :CP_2 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='DELAY';
-
RETURN :CP_2;
-
ELSIF :DLY_TYPE='ONTIME' THEN
-
SELECT COUNT(:DLY_TYPE)INTO :CP_3 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='ONTIME';
-
RETURN :CP_3;
-
ELSE
-
SELECT COUNT(:DLY_TYPE)INTO :CP_1 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='BEFORETIME';
-
--RETURN :CP_1;
-
SELECT COUNT(:DLY_TYPE)INTO :CP_2 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='DELAY';
-
--RETURN :CP_2;
-
SELECT COUNT(:DLY_TYPE)INTO :CP_3 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='ONTIME';
-
--RETURN :CP_3;
-
:CP_4 := :CP_1 || :CP_2 || :CP_3;
-
RETURN :CP_4;
-
END IF;
-
-
end;
12 1818
From your code i am not sure what are you doing , and what are you passing to the function. Are you passing a field name ?
-
function CF_3Formula return Number is
-
begin
-
IF :DLY_TYPE='BEFORETIME' THEN
-
SELECT COUNT(:DLY_TYPE)INTO :CP_1 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='BEFORETIME';
-
RETURN :CP_1;
-
ELSIF :DLY_TYPE='DELAY' THEN
-
SELECT COUNT(:DLY_TYPE)INTO :CP_2 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='DELAY';
-
RETURN :CP_2;
-
ELSIF :DLY_TYPE='ONTIME' THEN
-
SELECT COUNT(:DLY_TYPE)INTO :CP_3 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='ONTIME';
-
RETURN :CP_3;
-
ELSE
-
SELECT COUNT(:DLY_TYPE)INTO :CP_1 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='BEFORETIME';
-
--RETURN :CP_1;
-
SELECT COUNT(:DLY_TYPE)INTO :CP_2 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='DELAY';
-
--RETURN :CP_2;
-
SELECT COUNT(:DLY_TYPE)INTO :CP_3 FROM TEMP_CNS_999
-
WHERE :DLY_TYPE='ONTIME';
-
--RETURN :CP_3;
-
:CP_4 := :CP_1 || :CP_2 || :CP_3;
-
RETURN :CP_4;
-
END IF;
-
-
end;
Check for the values assigned to cp_1,cp_2 and cp_3 are they correct?
Use SRW.MESSAGE for printing the values of CP_1,2,3 as an alert during run time of the report and post back if the values of cp_1,2,3 ARE correct??
From your code i am not sure what are you doing , and what are you passing to the function. Are you passing a field name ?
:CP_1,2,3,4 IS PLACE HOLDER COULMN WHICH GETTING THE VALUES
OF DATA BASE COLUMN DLY_TYPE, CATAGORIES WISE. I WANT TO MERGE CP_1,2,3 INTO CP_4
Check for the values assigned to cp_1,cp_2 and cp_3 are they correct?
Use SRW.MESSAGE for printing the values of CP_1,2,3 as an alert during run time of the report and post back if the values of cp_1,2,3 ARE correct??
VALUES ARE GOING CORRECTLY INTO CP_1,2,3 BUT NOT IN CP_4.
I WILL TRY SRW.MESSAGE
VALUES ARE GOING CORRECTLY INTO CP_1,2,3 BUT NOT IN CP_4.
I WILL TRY SRW.MESSAGE
is CP_4 a number or string ?
:cp_4 is number.........................
:cp_4 is number.........................
then how can you use string concadination to store value in a number variable .
:cp_4 is number.........................
Could you please provide some sample data that is getting assigned to CP_1,CP_2 and CP_3 and what exactly CP_4 is returning for those values?
i am using count( ) function. and counted values are going to :cp_4 and
:cp_1,2,3 all are number data type
i am using count( ) function. and counted values are going to :cp_4 and
:cp_1,2,3 all are number data type
Hi Subash,
Please try resetting the values of CP_1,2,3,4 before assigning new values to them and check if CP_4 returns correct value?
And the way to are concatenating the values of CP_1,CP_2 and CP_3 is how you actually require?
simply concatenation and then i will go for addition
simply concatenation and then i will go for addition
Did you try resetting the values to the CP_1,2,3,4 and then assign new ones??
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Bhavin G |
last post by:
Hi there ,
I am pretty new at javascripting and i am having this huge problem. I
am using asp.net and C# webapplication.
In my asp.net aspx file I have a place holder for taking an html table...
|
by: WIWA |
last post by:
Hello,
I have written a program that gets information from Active Directory. This
is the function I'm using:
void ADSysGetUserName(IADsADSystemInfo * pSys, char * data) {
HRESULT hr;
BSTR...
|
by: Martin |
last post by:
There seems to be some strange behaviour when trying to get the
scrollHeight and scrollTop of an iframe in IE6.
I have tried several ways of getting these values when the iframe is
written into...
|
by: Mike Conklin |
last post by:
This one really has me going. Probably something silly. I'm using
dcount for a report to determine the number of different types of
tests proctored in a semester.
My report is based on a...
|
by: Chuck Faranda |
last post by:
I'm trying to debug my first C program (firmware for PIC MCU). The problem
is getting serial data back from my device. My get commands have to be sent
twice for the PIC to respond properly with...
|
by: rohitchawla |
last post by:
have a problem with this code when working in IE
it gives me 0,0 coords when i use iframe tag but gives correct coords when using firefox
function GetRealOffset(id)
{
var elem =...
|
by: chris.kemmerer |
last post by:
I am having a problem with templates and I hope someone here can help.
I am writing a library that accepts data packets, parses them and
saves the information for later use. One member of the...
|
by: dgleeson3 |
last post by:
Hello all
I have used the LoginForm1 class in a Visual studio 2005 VB
application.
Its the standard Username, Pasword request for user input.
I was hoping to use property procedures to get...
|
by: KDawg44 |
last post by:
Hi,
I have PHP function that adds a record to the database. The table has
an ID that is AUTO_INCREMENT. Is there anyway to get that ID back
when I do any kind of insert? That ID is a foreign...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| | |