Hi,

Does anyone have a tool that wiull take a database (directory) and go
through all the tables, look for dates, and increment the date by x days?
Dont think it would be hard to write but just in case anyone has already had
a need to do this?

The main reason I want this is to increment dates for demonstrations.  Over
time the data in a demo database becomes old, especially for an application
that is very data-driven.

Thanks

Alex

>
> Does anyone have a tool that wiull take a database (directory) and go
> through all the tables, look for dates, and increment the date by x days?
> Dont think it would be hard to write but just in case anyone has already had
> a need to do this?
>

I was going to do this a while back but never got round to it.  Should
be fairly simple using the IncDay function.

You may be able to do this in SQL using an update query.  Have a look at
the EXTRACT function http://www.elevatesoft.com/dbisam4d5_functions.htm


Kind Regards

--
Stuart Kelly
mode software

Stuart Kelly wrote:
>> Does anyone have a tool that wiull take a database (directory) and go
>> through all the tables, look for dates, and increment the date by x
>> days? Dont think it would be hard to write but just in case anyone
>> has already had a need to do this?
>>
>
> I was going to do this a while back but never got round to it.  Should
> be fairly simple using the IncDay function.
>
> You may be able to do this in SQL using an update query.  Have a look
> at the EXTRACT function

Even more simple: "set DateField=DateField + x"

Ralf

Hi Guys,

Thanks for your replies.  I didnt really have a problem with how to
increment the date.  I was more looking to see whether anyone had written a
tool to recurse through a specific directory, check each DBISAM table for
dates and if found increment th dates by x.

Cheers

Alex

"Ralf Mimoun" <nospam@rad-on.de> wrote in message
news:02A2B488-A08A-4702-8FCA-8A305D553BF8@news.elevatesoft.com...
> Stuart Kelly wrote:
>>> Does anyone have a tool that wiull take a database (directory) and go
>>> through all the tables, look for dates, and increment the date by x
>>> days? Dont think it would be hard to write but just in case anyone
>>> has already had a need to do this?
>>>
>>
>> I was going to do this a while back but never got round to it.  Should
>> be fairly simple using the IncDay function.
>>
>> You may be able to do this in SQL using an update query.  Have a look
>> at the EXTRACT function
>
> Even more simple: "set DateField=DateField + x"
>
> Ralf
>