Subject | RE: [ib-support] Dropping table from application |
---|---|
Author | Helen Borrie |
Post date | 2002-11-23T22:11:05Z |
At 11:12 AM 23-11-02 -0500, you wrote:
keep but want to make inaccessible to your applications. Include a single
byte column "IsActive". Set it to 'T' when you insert the row, set it to
'F' when you have performed whatever you want to do with it.
Have applications ignore the "disabled" rows by including
.. WHERE IsActive <> 'F'
At cleanup time, maybe as part of your end of day, use
WHERE IsActive = 'F' to select the disabled rows for deletion, archiving, etc.
heLen
> >>Cleanup is by deleting (or, preferably, disabling) that set ofIt's just a technique you can use if you are storing rows that you want to
> >>rows;
>
>Helen,
>
>What do you mean 'disabling'? I use the technique and delete the rows.
>Don't know how to disable.
keep but want to make inaccessible to your applications. Include a single
byte column "IsActive". Set it to 'T' when you insert the row, set it to
'F' when you have performed whatever you want to do with it.
Have applications ignore the "disabled" rows by including
.. WHERE IsActive <> 'F'
At cleanup time, maybe as part of your end of day, use
WHERE IsActive = 'F' to select the disabled rows for deletion, archiving, etc.
heLen