(unknown) Blank Title 59418

Yahoo Archive
1
works like a charm!

thanks bernie

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bernie Walker
Sent: Monday, September 24, 2007 1:13 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] (unknown)



Use the wizard to create an EpiViewNotification event for the dataview
that will have the date01 field updated if you do not have one already.
add this code to the event:

If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then
If (args.Row > -1) Then
If IsDBNull(view.dataView(args.Row)("Date01")) Then
view.dataView(args.Row)("Date01") = Today
End If
End If
End If

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Matt Barron
Sent: Monday, September 24, 2007 12:35 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] (unknown)

Didnt even think about that.

Yeah, I'd like for it to be filled with Sept 24 2007. Once the record is
saved, that field needs to stay Sept 24 2007.

I guess what it needs to be that once a new parent is created, the
date01 field will contain the current date.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Bernie Walker
Sent: Monday, September 24, 2007 11:29 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] (unknown)

So this date field gets filled with Sept 24 2007 today and someone calls
up that same record on Wednesday, does the date stay 9/24/2007 or does
it get changed to 9/26/2007 ??

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On Behalf Of dub554
Sent: Monday, September 24, 2007 12:19 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] (unknown)

How do I get a "Date01" field to be filled with the current day's date
every time the form is opened?

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
<http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
<http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Yahoo! Groups Links

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links






[Non-text portions of this message have been removed]
2
How do I get a "Date01" field to be filled with the current day's date
every time the form is opened?
3
So this date field gets filled with Sept 24 2007 today and someone calls up that same record on Wednesday, does the date stay 9/24/2007 or does it get changed to 9/26/2007 ??

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dub554
Sent: Monday, September 24, 2007 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] (unknown)

How do I get a "Date01" field to be filled with the current day's date every time the form is opened?



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
4
Didnt even think about that.

Yeah, I'd like for it to be filled with Sept 24 2007. Once the record
is saved, that field needs to stay Sept 24 2007.

I guess what it needs to be that once a new parent is created, the
date01 field will contain the current date.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bernie Walker
Sent: Monday, September 24, 2007 11:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)



So this date field gets filled with Sept 24 2007 today and someone calls
up that same record on Wednesday, does the date stay 9/24/2007 or does
it get changed to 9/26/2007 ??

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of dub554
Sent: Monday, September 24, 2007 12:19 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] (unknown)

How do I get a "Date01" field to be filled with the current day's date
every time the form is opened?

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links






[Non-text portions of this message have been removed]
5
I do something like this to default other VB Form fields when they are empty using a .P routine that runs on form load.
Not a date field but a sample (in 6.1 anyway) that might help would be:
-----------------------------
Define Variable POLineVar as Int.
Define Variable PORelVar as Int.

/* INCLUDE vbp/vb.i SO THAT VantageBasic FUNCTIONS ARE AVAILABLE. */
{M:\mfgsys61\vbp/vb.i}
POLineVar = getDecimalValue("POLine.scrvalue").
PORelVar = getDecimalValue("PORel.scrvalue").

if POLineVar = 0 then Do:
setDecimalValue("POLine.scrvalue":U,1.0).
End.
if PORelVar = 0 then Do:
setDecimalValue("PORel.scrvalue":U,1.0).
End.
RETURN.
-------------------------------
Which sets the PO line and release fields on a subcontract packing slip to be 1...if not already set. Testing for a date already there you might try if it is greater than some base date because I think no date would be lower than any other date.
The procedure call for the form looks like:

RUNPROG m:\mfgsys61\vbp\SubShipDefaults.P.

Anwyay, perhaps an approach to try.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Matt Barron
Sent: Monday, September 24, 2007 11:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)


Didnt even think about that.

Yeah, I'd like for it to be filled with Sept 24 2007. Once the record
is saved, that field needs to stay Sept 24 2007.

I guess what it needs to be that once a new parent is created, the
date01 field will contain the current date.

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Bernie Walker
Sent: Monday, September 24, 2007 11:29 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] (unknown)

So this date field gets filled with Sept 24 2007 today and someone calls
up that same record on Wednesday, does the date stay 9/24/2007 or does
it get changed to 9/26/2007 ??

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of dub554
Sent: Monday, September 24, 2007 12:19 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] (unknown)

How do I get a "Date01" field to be filled with the current day's date
every time the form is opened?

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links

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



________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel.com


[Non-text portions of this message have been removed]
6
Use the wizard to create an EpiViewNotification event for the dataview that will have the date01 field updated if you do not have one already.
add this code to the event:

If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then
If (args.Row > -1) Then
If IsDBNull(view.dataView(args.Row)("Date01")) Then
view.dataView(args.Row)("Date01") = Today
End If
End If
End If

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Matt Barron
Sent: Monday, September 24, 2007 12:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)

Didnt even think about that.

Yeah, I'd like for it to be filled with Sept 24 2007. Once the record is saved, that field needs to stay Sept 24 2007.

I guess what it needs to be that once a new parent is created, the
date01 field will contain the current date.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bernie Walker
Sent: Monday, September 24, 2007 11:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)



So this date field gets filled with Sept 24 2007 today and someone calls up that same record on Wednesday, does the date stay 9/24/2007 or does it get changed to 9/26/2007 ??

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of dub554
Sent: Monday, September 24, 2007 12:19 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] (unknown)

How do I get a "Date01" field to be filled with the current day's date every time the form is opened?

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links






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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links