It updated the material record yes.
________________________________
From: Rob Bucek <rbucek@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tuesday, June 19, 2012 11:55 AM
Subject: RE: [Vantage] Adding checkbox to issue material
Ted,
I can't say just by glancing at it. I can almost always work through most VB code but it takes wading through it in an actual environment. Unlike some very smart folks on here (you know who you are lol) for me a lot of times its not readily apparent what the best way is. First thing I noticed is you might consider doing a getrows instead of a getbyid, it will reduce the size of your dataset greatly and improve performance (you won't need most of the data dragged over from a getbyid). But since I'm not a programmer by trade I'm never sure if I'm always doing things in the most efficient manner lol! Usually when I get a record using another adapter and subsequently update it ive done a beginedit and endedit with the changed row in between.. But there are many ways to accomplish the same thing in VB and I'm always picking up new ones. Does your code update the material record?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Tuesday, June 19, 2012 10:19 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Adding checkbox to issue material
Rob, is this how you would do it? I really didn't know what I was doing but came up with this and it appears to work. Thanks.
  Private Sub CallUpdateJobMtl()
    Try
      ' Declare and Initialize EpiDataView Variables
      Dim edvIM As EpiDataView = CType(Me.oTrans.EpiDataViews("IM"),EpiDataView)
      ' Check if valid EpiDataView Row(s) are selected
      If (edvIM.Row < 0) Then
        Return
      End If
      ' Declare and create an instance of the Adapter.
      Dim adapterJobEntry As JobEntryAdapter = New JobEntryAdapter(Me.oTrans)
      adapterJobEntry.BOConnect
      ' Declare and Initialize Variables
      Dim jobNum As String = CType(edvIM.dataView(edvIM.Row)("ToJobNum"),String)
      Dim asm As String = CType(edvIM.dataView(edvIM.Row)("ToAssemblySeq"),String)
      Dim mtlSeq As String = CType(edvIM.dataView(edvIM.Row)("ToJobSeq"),String)
      ' Call Adapter method
      Dim result As Boolean = adapterJobEntry.GetByID(jobNum)
      Dim jobDS As JobEntryDataSet = adapterJobEntry.JobEntryData
      Dim dt as new DataTable
      dt = jobDS.Tables("JobMtl")
      For i as integer = 0 To dt.rows.count - 1
        If dt.Rows(i)("JobNum") = jobNum AND dt.Rows(i)("AssemblySeq") = asm AND dt.Rows(i)("MtlSeq") = mtlSeq Then
          dt.Rows(i)("IssuedComplete") = true
        End If
      Next
      'dt.Rows(0)("IssuedComplete") = true
      Dim res As Boolean = adapterJobEntry.Update()
      ' Cleanup Adapter Reference
      adapterJobEntry.Dispose
    Catch ex As System.Exception
      ExceptionBox.Show(ex)
    End Try
  End Sub
________________________________
From: Rob Bucek <rbucek@...<mailto:rbucek%40dsmfg.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Tuesday, June 19, 2012 10:26 AM
Subject: RE: [Vantage] Adding checkbox to issue material
Jobentry would work..
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ted Koch
Sent: Tuesday, June 19, 2012 9:18 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Adding checkbox to issue material
How would you bring in the dataview if the object explorer says it's not available? Or would you use the JobEntryAdapter?
________________________________
From: John Driggers <waffqle@...<mailto:waffqle%40gmail.com><mailto:waffqle%40gmail.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Sent: Tuesday, June 19, 2012 9:51 AM
Subject: Re: [Vantage] Adding checkbox to issue material
You can either bring in the dataview, or just create a little function to
lookup the jobmtl record and toggle the bit when someone ticks the box.
*
*
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...<mailto:waffqle%40gmail.com><mailto:waffqle%40gmail.com>*
*:: NO FAXES*
*
*
________________________________
From: Rob Bucek <rbucek@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tuesday, June 19, 2012 11:55 AM
Subject: RE: [Vantage] Adding checkbox to issue material
Ted,
I can't say just by glancing at it. I can almost always work through most VB code but it takes wading through it in an actual environment. Unlike some very smart folks on here (you know who you are lol) for me a lot of times its not readily apparent what the best way is. First thing I noticed is you might consider doing a getrows instead of a getbyid, it will reduce the size of your dataset greatly and improve performance (you won't need most of the data dragged over from a getbyid). But since I'm not a programmer by trade I'm never sure if I'm always doing things in the most efficient manner lol! Usually when I get a record using another adapter and subsequently update it ive done a beginedit and endedit with the changed row in between.. But there are many ways to accomplish the same thing in VB and I'm always picking up new ones. Does your code update the material record?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Tuesday, June 19, 2012 10:19 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Adding checkbox to issue material
Rob, is this how you would do it? I really didn't know what I was doing but came up with this and it appears to work. Thanks.
  Private Sub CallUpdateJobMtl()
    Try
      ' Declare and Initialize EpiDataView Variables
      Dim edvIM As EpiDataView = CType(Me.oTrans.EpiDataViews("IM"),EpiDataView)
      ' Check if valid EpiDataView Row(s) are selected
      If (edvIM.Row < 0) Then
        Return
      End If
      ' Declare and create an instance of the Adapter.
      Dim adapterJobEntry As JobEntryAdapter = New JobEntryAdapter(Me.oTrans)
      adapterJobEntry.BOConnect
      ' Declare and Initialize Variables
      Dim jobNum As String = CType(edvIM.dataView(edvIM.Row)("ToJobNum"),String)
      Dim asm As String = CType(edvIM.dataView(edvIM.Row)("ToAssemblySeq"),String)
      Dim mtlSeq As String = CType(edvIM.dataView(edvIM.Row)("ToJobSeq"),String)
      ' Call Adapter method
      Dim result As Boolean = adapterJobEntry.GetByID(jobNum)
      Dim jobDS As JobEntryDataSet = adapterJobEntry.JobEntryData
      Dim dt as new DataTable
      dt = jobDS.Tables("JobMtl")
      For i as integer = 0 To dt.rows.count - 1
        If dt.Rows(i)("JobNum") = jobNum AND dt.Rows(i)("AssemblySeq") = asm AND dt.Rows(i)("MtlSeq") = mtlSeq Then
          dt.Rows(i)("IssuedComplete") = true
        End If
      Next
      'dt.Rows(0)("IssuedComplete") = true
      Dim res As Boolean = adapterJobEntry.Update()
      ' Cleanup Adapter Reference
      adapterJobEntry.Dispose
    Catch ex As System.Exception
      ExceptionBox.Show(ex)
    End Try
  End Sub
________________________________
From: Rob Bucek <rbucek@...<mailto:rbucek%40dsmfg.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Tuesday, June 19, 2012 10:26 AM
Subject: RE: [Vantage] Adding checkbox to issue material
Jobentry would work..
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ted Koch
Sent: Tuesday, June 19, 2012 9:18 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Adding checkbox to issue material
How would you bring in the dataview if the object explorer says it's not available? Or would you use the JobEntryAdapter?
________________________________
From: John Driggers <waffqle@...<mailto:waffqle%40gmail.com><mailto:waffqle%40gmail.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Sent: Tuesday, June 19, 2012 9:51 AM
Subject: Re: [Vantage] Adding checkbox to issue material
You can either bring in the dataview, or just create a little function to
lookup the jobmtl record and toggle the bit when someone ticks the box.
*
*
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...<mailto:waffqle%40gmail.com><mailto:waffqle%40gmail.com>*
*:: NO FAXES*
*
*
On Tue, Jun 19, 2012 at 9:49 AM, Ted Koch <tkoch77@...<mailto:tkoch77%40yahoo.com><mailto:tkoch77%40yahoo.com>> wrote:
> **
>
>
> Is there a way to directly update a job material record if the dataview
> isn't available?
>
> ________________________________
> From: John Driggers <waffqle@...<mailto:waffqle%40gmail.com><mailto:waffqle%40gmail.com>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> Sent: Tuesday, June 19, 2012 9:29 AM
> Subject: Re: [Vantage] Adding checkbox to issue material
>
>
> There isn't an 'issue material' table to store this on. I'd suggest you put
> some logic in your UI to go back and find the JobMtl record and mark it
> there. BPM probably isn't what you want here.
>
> *
> *
> *John Driggers*
> *High End Dev, System Design, Profit Drinking*
> *
> **:: 904.404.9233*
> *:: waffqle@...<mailto:waffqle%40gmail.com><mailto:waffqle%40gmail.com>*
> *:: NO FAXES*
>
> *
>
>
> *
>
> On Mon, Jun 18, 2012 at 5:25 PM, Ted Koch <tkoch77@...<mailto:tkoch77%40yahoo.com><mailto:tkoch77%40yahoo.com>> wrote:
>
> > **
>
> >
> >
> > What the BPM does is mark that material as being issued, but since they
> > used scrap we dont want it to mess with inventory.
> >
> > ________________________________
> > From: Rob Bucek <rbucek@...<mailto:rbucek%40dsmfg.com><mailto:rbucek%40dsmfg.com>>
> > To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>>
> > Sent: Monday, June 18, 2012 5:19 PM
> > Subject: RE: [Vantage] Adding checkbox to issue material
> >
> >
> > Ultimately what are you attempting to do? Could you do a UI
> customization
> > on an unbound checkbox and perform your logic within there?
> >
> > Rob Bucek
> > Production Control Manager
> > PH: (715) 284-5376 ext 311
> > Mobile: (715)896-0590
> > FAX: (715)284-4084
> > [Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<
> > http://www.dsmfg.com/>
> > (Click the logo to view our site)<http://www.dsmfg.com/>
> >
> > 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 tkoch77
> > Sent: Monday, June 18, 2012 3:21 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Adding checkbox to issue material
> >
> > I have added a checkbox to the Issue Material form, the user is to check
> > this checkbox if they used scrap for the issued material. I want to
> trigger
> > a bpm based off this checkbox. However the issue I am running into is
> there
> > is no UD field available for use. I tried using
> > CallContextBpmData.Checkbox01 and this doesnt seem to work.
> >
> > I also tried updating the field with some code on the checkedchanged
> event
> > for the checkbox. I know its not assigning it because in a pre-processing
> > directive and set it up to show informational message and it is saying
> the
> > value is NO for CallContextBpmData.checkbox01.
> >
> > Attempting this on the IssueReturn.PerformMaterialMovement method.
> >
> > Thanks for any help,
> >
> > Ted
> >
> > [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/><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
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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/><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
>
> [Non-text portions of this message have been removed]
>
>
>
[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/><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
[Non-text portions of this message have been removed]
[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
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[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/.%c2%a0
(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
[Non-text portions of this message have been removed]