8.03.4XX Customization Question

Yahoo Archive
1
The best way I have found to trigger calculations in Job Entry is
using the released checkbox click event. If you do not allow
changes to engineered jobs then they have to uncheck Engineered then
check released when they finish making the changes. The only way
this would not work is if you use order Job wizard & they release
the jobs without ever going to Job Entry.

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
>
> I take it an after_changed_value Epinotification on
JobHead.ProdQty is unreliable as a trigger?
>
> Sometimes you need multiple subs that all do the same thing but
are each triggered by the myriad of ways users can enter data in a
GUI application... Tricky part is to create them in a way that
doesn't result in them interacting as one endless processing loop.
>
> A cheap trick is to link JobHead.ProdQty to a hidden yourtextbox
and look for yourtextbox.txt value changes (when Epinotifies fail).
>
> If you try it, make sure you include an initial IF loop so if len
(yourtextbox.txt) = 0 (indicative of a row = -1 condition for a
cleared form), the sub exists gracefully.
>
> Rob
>
>
> --- On Mon, 2/9/09, melissa hietala <kevmel822@...> wrote:
>
> > From: melissa hietala <kevmel822@...>
> > Subject: [Vantage] 8.03.4XX Customization Question
> > To: vantage@yahoogroups.com
> > Date: Monday, February 9, 2009, 5:09 PM
> > I have a customization setup so that when the value of the
> > "JobHead.Number01" field changes, I have an after
> > field change event that takes the value of the
> > "JobHead.Number01" field, multiplies that number
> > times the "JobHead.ProdQty" field, and places this
> > total in the "JobHead.Number06" field. This all
> > works fine, and the code i used to do this can be seen
> > below. However, I run into problems when the
> > "JobHead.ProdQty" is changed in the job. Then my
> > code doesn't update as it should. What I need to do is
> > once the "JobHead.ProdQty" value has changed, to
> > have the formula recalculate. But the
> > "JobHead.ProdQty" field is not directly editable,
> > instead it is calculated from the values in the
> > "MakeToStock","MakeToJobs" &
> > "MakeToOrder" tabs. Does anyone have any code that
> > takes the value of the JobHead.ProdQty field once it has
> > been changed and then use it in another formula???
> >
> > Thanks,
> >
> > Dustin Biniek
> > DustinB@...
> >
> > ÂÂ
> > •Private Sub JobHead_AfterFieldChange(ByVal sender As
> > object, ByVal args As DataColumnChangeEventArgs) Handles
> > JobHead_Column.ColumnChanged
> > •       '// ** Argument Properties and Uses
> > **
> > •       '// args.Row("[FieldName]")
> >
> > •       '// args.Column, args.ProposedValue,
> > args.Row
> > •       '
> > •       'Add Event Handler Code
> > •       '
> > •       Dim edv As EpiDataView =
> > CType(oTrans.EpiDataViews("JobHead"),
> > EpiDataView)   ÂÂ
> > •          ÂÂ
> > •       Select Case args.Column.ColumnName
> > •  ÂÂ
> > •         Case "Number01"
> > •                    ÂÂ
> > edv.dataView(edv.Row)("Number06") =
> > edv.dataView(edv.Row)("Number01") *
> > edv.dataView(edv.Row)("ProdQty")
> > •         Case Else
> > •       ÂÂ
> > •    End Select
> > •   ÂÂ
> > • End Sub
> >  Dustin Biniek
> > UMC, Inc.
> > DustinB@...
> >
> >
> >
> >
> > [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/linksYahoo!
> > Groups Links
> >
> >
> >
>
2
Is there a way to have a record automatically save after a field has been changed? Basically what I am looking at doing is using the "AfterFieldChange" event in the form event wizard, and once the field has been changed, I would like the record to be saved. What is the syntax to "save" the record? Or is it not possible to do this?

Thanks!

Dustin Biniek
UMC, Inc.
DustinB@...




[Non-text portions of this message have been removed]
3
Yes. Use the VB.net form wizard to select your custom control/field and the event trigger ("AfterFieldChange" in your case) and create the basic shell of the sub routine.

Within it, add "otrans.update()" to save the record.

Careful... Too many of those can REALLY slow down applications (as it is client based processing). If you find that to be the case, try a (server based) BPM instead.

Rob

--- On Tue, 12/30/08, melissa hietala <kevmel822@...> wrote:

From: melissa hietala <kevmel822@...>
Subject: [Vantage] 8.03.4XX Customization Question
To: vantage@yahoogroups.com
Date: Tuesday, December 30, 2008, 10:24 AM






Is there a way to have a record automatically save after a field has been changed? Basically what I am looking at doing is using the "AfterFieldChange" event in the form event wizard, and once the field has been changed, I would like the record to be saved. What is the syntax to "save" the record? Or is it not possible to do this?

Thanks!

Dustin Biniek
UMC, Inc.
DustinB@ultramc. com

[Non-text portions of this message have been removed]
4
I have a customization setup so that when the value of the "JobHead.Number01" field changes, I have an after field change event that takes the value of the "JobHead.Number01" field, multiplies that number times the "JobHead.ProdQty" field, and places this total in the "JobHead.Number06" field.� This all works fine, and the code i used to do this can be seen below.� However, I run into problems when the "JobHead.ProdQty" is changed in the job.� Then my code doesn't update as it should.� What I need to do is once the "JobHead.ProdQty" value has changed, to have the formula recalculate. But the "JobHead.ProdQty" field is not directly editable, instead it is calculated from the values in the "MakeToStock","MakeToJobs" & "MakeToOrder" tabs. Does anyone have any code that takes the value of the JobHead.ProdQty field once it has been changed and then use it in another formula???

Thanks,

Dustin Biniek
DustinB@...

�
�Private Sub JobHead_AfterFieldChange(ByVal sender As object, ByVal args As DataColumnChangeEventArgs) Handles JobHead_Column.ColumnChanged
�������� '// ** Argument Properties and Uses **
�������� '// args.Row("[FieldName]")
�������� '// args.Column, args.ProposedValue, args.Row
�������� '
�������� 'Add Event Handler Code
�������� '
�������� Dim edv As EpiDataView = CType(oTrans.EpiDataViews("JobHead"), EpiDataView)����
������������
�������� Select Case args.Column.ColumnName
����
���������� Case "Number01"
���������������������� edv.dataView(edv.Row)("Number06") = edv.dataView(edv.Row)("Number01") * edv.dataView(edv.Row)("ProdQty")
���������� Case Else
���������
����� End Select
�����
��End Sub
�Dustin Biniek
UMC, Inc.
DustinB@...




[Non-text portions of this message have been removed]
5
I take it an after_changed_value Epinotification on JobHead.ProdQty is unreliable as a trigger?

Sometimes you need multiple subs that all do the same thing but are each triggered by the myriad of ways users can enter data in a GUI application... Tricky part is to create them in a way that doesn't result in them interacting as one endless processing loop.

A cheap trick is to link JobHead.ProdQty to a hidden yourtextbox and look for yourtextbox.txt value changes (when Epinotifies fail).

If you try it, make sure you include an initial IF loop so if len(yourtextbox.txt) = 0 (indicative of a row = -1 condition for a cleared form), the sub exists gracefully.

Rob


--- On Mon, 2/9/09, melissa hietala <kevmel822@...> wrote:

> From: melissa hietala <kevmel822@...>
> Subject: [Vantage] 8.03.4XX Customization Question
> To: vantage@yahoogroups.com
> Date: Monday, February 9, 2009, 5:09 PM
> I have a customization setup so that when the value of the
> "JobHead.Number01" field changes, I have an after
> field change event that takes the value of the
> "JobHead.Number01" field, multiplies that number
> times the "JobHead.ProdQty" field, and places this
> total in the "JobHead.Number06" field. This all
> works fine, and the code i used to do this can be seen
> below. However, I run into problems when the
> "JobHead.ProdQty" is changed in the job. Then my
> code doesn't update as it should. What I need to do is
> once the "JobHead.ProdQty" value has changed, to
> have the formula recalculate. But the
> "JobHead.ProdQty" field is not directly editable,
> instead it is calculated from the values in the
> "MakeToStock","MakeToJobs" &
> "MakeToOrder" tabs. Does anyone have any code that
> takes the value of the JobHead.ProdQty field once it has
> been changed and then use it in another formula???
>
> Thanks,
>
> Dustin Biniek
> DustinB@...
>
> Â
> •Private Sub JobHead_AfterFieldChange(ByVal sender As
> object, ByVal args As DataColumnChangeEventArgs) Handles
> JobHead_Column.ColumnChanged
> •       '// ** Argument Properties and Uses
> **
> •       '// args.Row("[FieldName]")
>
> •       '// args.Column, args.ProposedValue,
> args.Row
> •       '
> •       'Add Event Handler Code
> •       '
> •       Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("JobHead"),
> EpiDataView)Â Â Â Â
> •          Â
> •       Select Case args.Column.ColumnName
> •  Â
> •         Case "Number01"
> •                    Â
> edv.dataView(edv.Row)("Number06") =
> edv.dataView(edv.Row)("Number01") *
> edv.dataView(edv.Row)("ProdQty")
> •         Case Else
> •       Â
> •    End Select
> •   Â
> • End Sub
> Â Dustin Biniek
> UMC, Inc.
> DustinB@...
>
>
>
>
> [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/linksYahoo!
> Groups Links
>
>
>