Re: making an appointment form

Meads wrote:

> hello I'm trying to set up an appointments form in Oracle forms with
> the date at the top and 10 records that display the time at each
> hourly interval. Patient details are stored with the appropriate time.
> My problem is I can't find a way to make the times stay fixed at all
> times ie when I go insert record the times dissapear. Also I want to
> insert patients at different times with some time slots being blank as
> of yet I can't insert a new record beyound the next line.
>
> If anyone has any suggestions I would appreciate it
>
> thank you

Create a stored procedure inside the database with a name such as LOAD_SCHEDULE that will perform the inserts into your schedule table and create one record for each time slot. Then when you open the form and execute a query on the block all available time slots will already exist.

After the date passes, if you wish, you can delete the unused slots or, mark them as unused for later statistical reporting purposes.

Daniel Morgan Received on Sun Sep 22 2002 - 18:08:15 CDT