> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer<ts@...> wrote:
>>
>>> I just did a test in our environment. I logged into the database and made a change. The date modified on the database file wasn't updated. But when I logged out of the database, the date modified was updated. I was the only one logged into the database at the time.
>>>
>>> I logged into a client site where many users are connected to the database. I made a change in the data, but when I logged out, the date modified on the database file was not changed.
>>>
>>> Does it have something to do with the last person having to log out of the database?
>>
>> Yes. The timestamp changes when the last connection disconnects.
>>
>>
>
> Is there anyway around this? The client runs incremental backups on their server 3 times a day. The database is getting missed because people stay logged into the database.
>
> I was wondering if there was something we could do to the database in our application that would result in the Date Modified to be updated.

Not that I know. Imagine if there is load on the database and the change
timestamp gets automatically refreshed every time ...

What are you using for creating your incremental backups?

Regards,
Thomas

> Todd
>
>> --
>> With regards,
>> Thomas Steinmaurer (^TS^)
>> Firebird Technology Evangelist
>>
>> http://www.upscene.com/
>> http://www.firebirdsql.org/en/firebird-foundation/
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>