UD table scan for dates

Yahoo Archive
1
Thanks to Doug, here is how he told me to do it. I have not gotten around to implementing it yet, but this looks like it should work:

"You can make the 4gl code a stand alone progress program .p or .r if you compile it.
Then you can create a command line that calls prowin32 with the database name, port number, login and the 4gl program.
This command line can be added to the windows scheduler."


Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steve_E
Sent: Wednesday, July 22, 2009 9:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: UD table scan for dates



Tom,

Thanks for the infor, but I need something to run that code once a day in
the back ground. I can't find anything that fires once a day to run the 4
GL code from. Any Ideas?

Steve


-----Original Message-----
From: Thomas Rose [mailto:t.rose@...<mailto:t.rose%40electricmirror.com>]
Sent: July 22, 2009 10:07 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: UD table scan for dates

Here is some 4GL air code. Others smarter than I will likely find some
improvements:

FOR EACH UD01 WHERE UD01.Company="ZZ01":
IF UD01.Date01 > Now THEN DO:
RUN lib\UpdateTableBuffer.p(input BUFFER UD01:HANDLE, 'CheckBox01',True).
END.
END.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric <http://www.electricmirror.com>
mirror.com>

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of vantage03
Sent: Wednesday, July 22, 2009 7:40 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: UD table scan for dates

I posted this a few days ago and did not get a response. I am looking to try
to run a scan check like vantages built in quote expire system. I am using
on of the UD table that have an expiration date and want the system to
change a check box to true when one of the date fields pass the current
date. Has any one done anything like this?

Steve

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com>, "vantage03" <vantage@...> wrote:
>
> Is there any way to setup a routine to scan the a UD table and look for
dates alder then today and set a check box field.
>
> Steve
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Is there any way to setup a routine to scan the a UD table and look for dates alder then today and set a check box field.

Steve
3
I posted this a few days ago and did not get a response. I am looking to try to run a scan check like vantages built in quote expire system. I am using on of the UD table that have an expiration date and want the system to change a check box to true when one of the date fields pass the current date. Has any one done anything like this?

Steve




--- In vantage@yahoogroups.com, "vantage03" <vantage@...> wrote:
>
> Is there any way to setup a routine to scan the a UD table and look for dates alder then today and set a check box field.
>
> Steve
>
4
Here is some 4GL air code. Others smarter than I will likely find some improvements:

FOR EACH UD01 WHERE UD01.Company="ZZ01":
IF UD01.Date01 > Now THEN DO:
RUN lib\UpdateTableBuffer.p(input BUFFER UD01:HANDLE, 'CheckBox01',True).
END.
END.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of vantage03
Sent: Wednesday, July 22, 2009 7:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: UD table scan for dates



I posted this a few days ago and did not get a response. I am looking to try to run a scan check like vantages built in quote expire system. I am using on of the UD table that have an expiration date and want the system to change a check box to true when one of the date fields pass the current date. Has any one done anything like this?

Steve

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "vantage03" <vantage@...> wrote:
>
> Is there any way to setup a routine to scan the a UD table and look for dates alder then today and set a check box field.
>
> Steve
>



[Non-text portions of this message have been removed]
5
Tom,

Thanks for the infor, but I need something to run that code once a day in
the back ground. I can't find anything that fires once a day to run the 4
GL code from. Any Ideas?

Steve


-----Original Message-----
From: Thomas Rose [mailto:t.rose@...]
Sent: July 22, 2009 10:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: UD table scan for dates




Here is some 4GL air code. Others smarter than I will likely find some
improvements:

FOR EACH UD01 WHERE UD01.Company="ZZ01":
IF UD01.Date01 > Now THEN DO:
RUN lib\UpdateTableBuffer.p(input BUFFER UD01:HANDLE, 'CheckBox01',True).
END.
END.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric <http://www.electricmirror.com>
mirror.com>

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of vantage03
Sent: Wednesday, July 22, 2009 7:40 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: UD table scan for dates

I posted this a few days ago and did not get a response. I am looking to try
to run a scan check like vantages built in quote expire system. I am using
on of the UD table that have an expiration date and want the system to
change a check box to true when one of the date fields pass the current
date. Has any one done anything like this?

Steve

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com>, "vantage03" <vantage@...> wrote:
>
> Is there any way to setup a routine to scan the a UD table and look for
dates alder then today and set a check box field.
>
> Steve
>

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]