Re: automating a query

[Dimitris Papageorgiou]

Peter Brawley Wrote:
-------------------------------------------------------
> Available appointment times change every time
> there's a new, changed or deleted booking, it's
> just a query that's run whenever you need the
> info.


You do not answer my question...exactly.
My problem is not the info I ask by performing a query.
My problem has to do with the info already present database....and how this should be updated.
Cause as I say...
There is a table that spans 7 months ahead in the future...this represents how far in the future a user can book an appt...namely 7 months.As time goes by though this period diminishes.After 3 months...4 months remain and the user can book an appt up to that point...nonetheless I intend having constant this 7 month period which means updating the table continuously...
And I am asking if there is an automatic way to do that...avoiding manual INSERT queries all the time.

Did you get the picture now???