Override date() vfp function

[lclock]

Hi, i'm looking form a smart solution to solve this problem:
i've a large VFP application that now at the login doesn't ask for a date.
Now i need to ask a date and use it in all point of my application when i use the date() function.
Is it possible to ovveride the vfp standard date() function with a new function that return the login date so that i can get the result without editing 150 program ?
Thanks

 

[bborissov]

Nope, you can use Tools->Code References to search and Replace every instance of DATE( TO MyDate(
As You see I didn't close the brackets, that is because DATE function has 3 optional parameters. But if you want to replace only these instances where you use DATE w/o any parameters you should use DATE() and MyDate().

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[lclock]

Thank's
i was hoping in something "like a miracle",
but this is better than nothing.

 

[Mike Lewis]

This might be a bit drastic, but there's a nice piece of freeware called RunAsDate that fools VFP (or any other app) into thinking the date is something other than what it really is. Once you've run it, the VFP DATE() function will take whatever date you set at the start.

You can find the program as

http://www.nirsoft.net.

But be sure to test it carefully, as it might have other implications for your app.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business