Recent content by LeighDreyer

I have a some information that is to be hardcoded in one of my reports and may need to change and wanted to place this information in an .ini file. How do I read this data into my report in business objects ? is there a component or some kind of macro I need to write in VB ?

I tried that and got missing Expression at the WHERE statement any ideas ? Ignore my last post I understand what i happening but still get error when trying this ??

Ok but where are you getting the a. reference from I am only using one table to pull data from UPDATE GPCT_PIMS.GPCT_WARDCOUNT a SET (a.MALE_UNDER_65) = (SELECT COUNT(b.REF_DATE) AS "MALE_UNDER_65" FROM GPCT_PIMS.GPCT_WARDCOUNT b WHERE b.SEX = 'M' AND b.OVER_65 = 'N' AND...

How are you populating the combo box ? it is possible if you are using refresh methods that this may cause the combo box to create a large stack of information to be pulled from the database causing it to crash not sure but could be the problem ?.

Hi I am trying to update multiple rows from one table but keep getting the error "ORA-01427: single-row subquery returns more than one row" how can I do it here is my code statement I am trying UPDATE GPCT_PIMS.GPCT_WARDCOUNT SET (MALE_UNDER_65) = (SELECT COUNT(REF_DATE) AS...

I have a table which has 4 fields WARD_NAME, REF_DATE, SEX, OVER_65. This table holds details about patients that have been to a ward and how many days they have been in the ward and whether they are over 65 and Male or female sample table below. As you will see in Ref_date there are 2...

Hi I am Using ORACLE james have used it succesfully for the previous line of code but it seems to give me an error when doing it with age problem

Tryint to check if a persons age is over 65 if so place a Y in table else place a N in table this is my attempts with no luck it is perfomed inside a SELECT statement and not an update. line with satrs is where I need to perform DECODE SELECT A.NAME AS "WARD NAME", F.TODAYS_DATE...

maybe I should have said that I am not performing an update it is inside a select Statement as below SELECT A.NAME AS "WARD NAME", F.TODAYS_DATE AS "DATE", DECODE(C.SEXXX_REFNO,'250564','M','250416', 'F') AS "SEX", (ROUND((F.TODAYS_DATE - C.DATE_OF_BIRTH) /...

Tried the Datediff one and keep getting error on Datediff saying Invalid Coloumn name ???? case when datediff(DAY, C.DATE_OF_BIRTH, F.TODAYS_DATE)/365.25 >= 65 then 'Y' else 'N' end

Tryint to check if a persons age is over 65 if so place a Y in table else place a N in table this is my attempts with no luck Method 1 DECODE(ROUND((F.TODAYS_DATE - C.DATE_OF_BIRTH) / 365) AS "AGE" Method 2 Decode(Sign(65-ROUND((F.TODAYS_DATE - C.DATE_OF_BIRTH) / 365)), 1, N, Y )...

I need to count the number of occurances in a day for each month ?. I have 6 tables I use one holds 10 years of dates, the other one holds admittance dates and discharge dates for a patient. I need to calculate the occupancy each day of the month for a single month. example patients have...

I have a GPCT_CALENDAR table which has one Field TODAYS_DATE it stores 10 years worth of dates. I have a start_date and an end_date Parameter. I have another table which holds patient details and lists appointments with Their Appointment Date. For each date period (Start_Date and End_Date) I...

Hi yes your first statement is correct The days the patient have visited the ward are present in the database but the month days are not present in the database.

Hi I have created an object Occupancy that contains Patient Sex, Admission Date, Discharge Date, Ward Name. I need to display each months occupancy brokedown into days i.e say for january Month January Day 1 2 3 4 5 6 7 ....... 31 no.Patients 2 4 1 6 3 8 10...