Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LeighDreyer

    How do you read data in from .INI FILE

    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 ?
  2. LeighDreyer

    Mulitple Row update how

    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 ??
  3. LeighDreyer

    Mulitple Row update how

    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...
  4. LeighDreyer

    VB Help

    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 ?.
  5. LeighDreyer

    Mulitple Row update how

    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...
  6. LeighDreyer

    Looping and inserting thorugh table

    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...
  7. LeighDreyer

    Decode Function Inside Select

    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
  8. LeighDreyer

    Decode Function Inside Select

    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...
  9. LeighDreyer

    Decode Function

    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) /...
  10. LeighDreyer

    Decode Function

    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
  11. LeighDreyer

    Decode Function

    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 )...
  12. LeighDreyer

    Data Occurnaces for a Day

    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...
  13. LeighDreyer

    SQL LOOP Dates

    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...
  14. LeighDreyer

    Reporting on Day breakdown of a month

    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.
  15. LeighDreyer

    Reporting on Day breakdown of a month

    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...
  16. LeighDreyer

    Reporting on Day breakdown of a month

    Hi I have a report which I need to display a months figures but in a day breakdown i.e I have a hospital ward and they wish to know the occupancy for each day for the ward per month, they need to know how many patients came in the ward every day ! tried using days between but can manage to get...

Part and Inventory Search

Back
Top