Help with a procedure !!!

From: marcband <mlody18_at_hotmail.com>
Date: 9 Jul 2003 06:43:21 -0700
Message-ID: <fa093a03.0307090543.c4728f7_at_posting.google.com>

I'm working on a new database ..... in Oracle 8 I need to create a procedure or function that will automatilly assign tasks each week for people to work... the task are stored in a table ... tblsTasks

Name                            Null?    Type


------------------------------- -------- ----

TXTTASK                         NOT NULL VARCHAR2(255)
TXTTYPE                         NOT NULL VARCHAR2(20)
TXTDOCNAME                               VARCHAR2(25)
BCLEANMAINT                              NUMBER(1)

The scheduales are in another table tblScheduales

Name                            Null?    Type


------------------------------- -------- ----

INTCOUNTER                      NOT NULL NUMBER(11)
SLLINKID                                 NUMBER(11)
TXTITEM                         NOT NULL VARCHAR2(25)
DATESTART                       NOT NULL DATE
TXTTIME                         NOT NULL NUMBER(5)
TXTTASK                         NOT NULL VARCHAR2(255)
SCHEDCOMMENTS                            VARCHAR2(100)
CHKSATURDAY                              NUMBER(5)
TXTASSIGNEDTO                            VARCHAR2(50)
INTPRIORITY                              NUMBER(11)
CHKFIXDATE                               NUMBER(1)

I need a procedure or a function that will display new work orders for each week and If the task isn't done ... it will be assigned next week

Here is a few semples of the data in tblShedules ..

SQL> select * from tblSchedules;

INTCOUNTER  SLLINKID TXTITEM                   DATESTART   TXTTIME
---------- --------- ------------------------- --------- ---------

TXTTASK

---

SCHEDCOMMENTS

---

CHKSATURDAY TXTASSIGNEDTO INTPRIORITY CHKFIXDATE

----------- --------------------------------------------------
----------- ----------
       87       327 FE1                       26-MAY-03         4

Inspect
Outside lunchroom

         1 H&S Rep.                                                   
 1          0

       88       328 FE2                       26-MAY-03         4

Inspect
Front lobby

         1 H&S Rep.                                                   
 1          0

       89       329 FE3                       26-MAY-03         4

Inspect

         1 H&S Rep.                                                   
 1          0

Any Idea how can I do this ..... Thanx

Does anyone know any good websites with good information that talk about procedures and dates

Thank You
MB Received on Wed Jul 09 2003 - 15:43:21 CEST