Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Tool to icnrement all dates in a directory of tables |
Mon, Jan 23 2006 2:10 AM | Permanent Link |
"Al VAs" | 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 |
Mon, Jan 23 2006 9:44 AM | Permanent Link |
Stuart Kelly | > > 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 |
Mon, Jan 23 2006 10:27 AM | Permanent Link |
"Ralf Mimoun" | 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 |
Mon, Jan 30 2006 9:43 PM | Permanent Link |
"Al VAs" | 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 > |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |