Update UD field on JobOper from Job Entry

Yes to all.
No production against the job or any operation.

Guess I will not beat my head against the wall on this one and start trying to hold the data in some other tables that there may be less rules to how the records can be updated.


--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Silly question, but said job is
>
> Open, not Released not Engineered right?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Mon, Nov 12, 2012 at 12:38 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
>
> > **
> >
> >
> > That did not work either Rob, but thanks for the suggestion.
> >
> >
> > --- In vantage@yahoogroups.com, Rob Bucek <rbucek@> wrote:
> > >
> > > Try
> > >
> > > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0).BeginEdit()
> > > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") =
> > decHrs
> > > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0).EndEdit()
> > >
> > >
> > >
> > > Rob Bucek
> > > Production Control Manager
> > > PH: (715) 284-5376 ext 311
> > > Mobile: (715)896-4832
> > > FAX: (715)284-4084
> > > [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 mmcwilliams22
> > > Sent: Monday, November 12, 2012 8:53 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Update UD field on JobOper from Job Entry
> > >
> > >
> > >
> > > For testing I just have it tied to a button click..
> > > Dim decHrs As Decimal = 25.25
> > > Dim JobOperAdapt As JobOperSearchAdapter = New
> > JobOperSearchAdapter(JobEntryForm)
> > >
> > > JobOperAdapt.BOConnect()
> > >
> > > Dim jobNum As String = Jobhead.DataView(JobHead.Row)("JobNum")
> > >
> > > Dim assemblySeq As String = "0"
> > > Dim oprSeq As String = "10"
> > >
> > > Dim JobOper As Boolean = JobOperAdapt.GetByID(jobNum, assemblySeq,
> > oprSeq)
> > >
> > > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") =
> > decHrs
> > >
> > > JobOperAdapt.Update()
> > > JobOperAdapt.Dispose()
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose
> > Gomez <jose@> wrote:
> > > >
> > > > When are you doing your update? Show your code? Also make sure you are
> > not
> > > > in JobTracker been there done that.
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > > <http://www.usdoingstuff.com>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > >
> > > > On Fri, Nov 9, 2012 at 5:15 PM, mmcwilliams22 <mmcwilliams22@>wrote:
> >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > Is there any other properties of the adapter I need to set to be
> > able to
> > > > > update a UD field on JobOper. I am getting an Update Not allowed
> > error when
> > > > > executing my code.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [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]
>
Is there any other properties of the adapter I need to set to be able to update a UD field on JobOper. I am getting an Update Not allowed error when executing my code.
When are you doing your update? Show your code? Also make sure you are not
in JobTracker been there done that.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 9, 2012 at 5:15 PM, mmcwilliams22 <mmcwilliams22@...>wrote:

> **
>
>
> Is there any other properties of the adapter I need to set to be able to
> update a UD field on JobOper. I am getting an Update Not allowed error when
> executing my code.
>
>
>


[Non-text portions of this message have been removed]
For testing I just have it tied to a button click..
Dim decHrs As Decimal = 25.25
Dim JobOperAdapt As JobOperSearchAdapter = New JobOperSearchAdapter(JobEntryForm)

JobOperAdapt.BOConnect()

Dim jobNum As String = Jobhead.DataView(JobHead.Row)("JobNum")

Dim assemblySeq As String = "0"
Dim oprSeq As String = "10"

Dim JobOper As Boolean = JobOperAdapt.GetByID(jobNum, assemblySeq, oprSeq)

JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") = decHrs


JobOperAdapt.Update()
JobOperAdapt.Dispose()

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> When are you doing your update? Show your code? Also make sure you are not
> in JobTracker been there done that.
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Fri, Nov 9, 2012 at 5:15 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
>
> > **
> >
> >
> > Is there any other properties of the adapter I need to set to be able to
> > update a UD field on JobOper. I am getting an Update Not allowed error when
> > executing my code.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Wait so you are not doing this from Job Entry?


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Mon, Nov 12, 2012 at 9:52 AM, mmcwilliams22 <mmcwilliams22@...>wrote:

> **
>
>
> For testing I just have it tied to a button click..
> Dim decHrs As Decimal = 25.25
> Dim JobOperAdapt As JobOperSearchAdapter = New
> JobOperSearchAdapter(JobEntryForm)
>
> JobOperAdapt.BOConnect()
>
> Dim jobNum As String = Jobhead.DataView(JobHead.Row)("JobNum")
>
> Dim assemblySeq As String = "0"
> Dim oprSeq As String = "10"
>
> Dim JobOper As Boolean = JobOperAdapt.GetByID(jobNum, assemblySeq, oprSeq)
>
> JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") =
> decHrs
>
> JobOperAdapt.Update()
> JobOperAdapt.Dispose()
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > When are you doing your update? Show your code? Also make sure you are
> not
> > in JobTracker been there done that.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Fri, Nov 9, 2012 at 5:15 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
> >
> > > **
>
> > >
> > >
> > > Is there any other properties of the adapter I need to set to be able
> to
> > > update a UD field on JobOper. I am getting an Update Not allowed error
> when
> > > executing my code.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
Where I really want it to happen is in the Resource Scheduling board.
My code throws no error when in the RSB but does not update the record. I am just testing in JobEntry because that is where I can get the actual error returned. Should have mentioned that since JobOper is already an available dataview in JobEntry. I am not trying to update using the native dataview.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Wait so you are not doing this from Job Entry?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Mon, Nov 12, 2012 at 9:52 AM, mmcwilliams22 <mmcwilliams22@...>wrote:
>
> > **
> >
> >
> > For testing I just have it tied to a button click..
> > Dim decHrs As Decimal = 25.25
> > Dim JobOperAdapt As JobOperSearchAdapter = New
> > JobOperSearchAdapter(JobEntryForm)
> >
> > JobOperAdapt.BOConnect()
> >
> > Dim jobNum As String = Jobhead.DataView(JobHead.Row)("JobNum")
> >
> > Dim assemblySeq As String = "0"
> > Dim oprSeq As String = "10"
> >
> > Dim JobOper As Boolean = JobOperAdapt.GetByID(jobNum, assemblySeq, oprSeq)
> >
> > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") =
> > decHrs
> >
> > JobOperAdapt.Update()
> > JobOperAdapt.Dispose()
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > When are you doing your update? Show your code? Also make sure you are
> > not
> > > in JobTracker been there done that.
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > > <http://www.usdoingstuff.com>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > >
> > > On Fri, Nov 9, 2012 at 5:15 PM, mmcwilliams22 <mmcwilliams22@>wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > Is there any other properties of the adapter I need to set to be able
> > to
> > > > update a UD field on JobOper. I am getting an Update Not allowed error
> > when
> > > > executing my code.
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Try

JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0).BeginEdit()
JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") = decHrs
JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0).EndEdit()



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[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 mmcwilliams22
Sent: Monday, November 12, 2012 8:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Update UD field on JobOper from Job Entry



For testing I just have it tied to a button click..
Dim decHrs As Decimal = 25.25
Dim JobOperAdapt As JobOperSearchAdapter = New JobOperSearchAdapter(JobEntryForm)

JobOperAdapt.BOConnect()

Dim jobNum As String = Jobhead.DataView(JobHead.Row)("JobNum")

Dim assemblySeq As String = "0"
Dim oprSeq As String = "10"

Dim JobOper As Boolean = JobOperAdapt.GetByID(jobNum, assemblySeq, oprSeq)

JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") = decHrs

JobOperAdapt.Update()
JobOperAdapt.Dispose()

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@...> wrote:
>
> When are you doing your update? Show your code? Also make sure you are not
> in JobTracker been there done that.
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Fri, Nov 9, 2012 at 5:15 PM, mmcwilliams22 <mmcwilliams22@...>wrote:
>
> > **
> >
> >
> > Is there any other properties of the adapter I need to set to be able to
> > update a UD field on JobOper. I am getting an Update Not allowed error when
> > executing my code.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
That did not work either Rob, but thanks for the suggestion.

--- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
>
> Try
>
> JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0).BeginEdit()
> JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") = decHrs
> JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0).EndEdit()
>
>
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-4832
> FAX: (715)284-4084
> [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 mmcwilliams22
> Sent: Monday, November 12, 2012 8:53 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Update UD field on JobOper from Job Entry
>
>
>
> For testing I just have it tied to a button click..
> Dim decHrs As Decimal = 25.25
> Dim JobOperAdapt As JobOperSearchAdapter = New JobOperSearchAdapter(JobEntryForm)
>
> JobOperAdapt.BOConnect()
>
> Dim jobNum As String = Jobhead.DataView(JobHead.Row)("JobNum")
>
> Dim assemblySeq As String = "0"
> Dim oprSeq As String = "10"
>
> Dim JobOper As Boolean = JobOperAdapt.GetByID(jobNum, assemblySeq, oprSeq)
>
> JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") = decHrs
>
> JobOperAdapt.Update()
> JobOperAdapt.Dispose()
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@> wrote:
> >
> > When are you doing your update? Show your code? Also make sure you are not
> > in JobTracker been there done that.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Fri, Nov 9, 2012 at 5:15 PM, mmcwilliams22 <mmcwilliams22@>wrote:
> >
> > > **
> > >
> > >
> > > Is there any other properties of the adapter I need to set to be able to
> > > update a UD field on JobOper. I am getting an Update Not allowed error when
> > > executing my code.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>
Silly question, but said job is

Open, not Released not Engineered right?


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Mon, Nov 12, 2012 at 12:38 PM, mmcwilliams22 <mmcwilliams22@...>wrote:

> **
>
>
> That did not work either Rob, but thanks for the suggestion.
>
>
> --- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
> >
> > Try
> >
> > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0).BeginEdit()
> > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") =
> decHrs
> > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0).EndEdit()
> >
> >
> >
> > Rob Bucek
> > Production Control Manager
> > PH: (715) 284-5376 ext 311
> > Mobile: (715)896-4832
> > FAX: (715)284-4084
> > [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 mmcwilliams22
> > Sent: Monday, November 12, 2012 8:53 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Update UD field on JobOper from Job Entry
> >
> >
> >
> > For testing I just have it tied to a button click..
> > Dim decHrs As Decimal = 25.25
> > Dim JobOperAdapt As JobOperSearchAdapter = New
> JobOperSearchAdapter(JobEntryForm)
> >
> > JobOperAdapt.BOConnect()
> >
> > Dim jobNum As String = Jobhead.DataView(JobHead.Row)("JobNum")
> >
> > Dim assemblySeq As String = "0"
> > Dim oprSeq As String = "10"
> >
> > Dim JobOper As Boolean = JobOperAdapt.GetByID(jobNum, assemblySeq,
> oprSeq)
> >
> > JobOperAdapt.JobOperSearchData.Tables("JobOper").Rows(0)("Number01") =
> decHrs
> >
> > JobOperAdapt.Update()
> > JobOperAdapt.Dispose()
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose
> Gomez <jose@> wrote:
> > >
> > > When are you doing your update? Show your code? Also make sure you are
> not
> > > in JobTracker been there done that.
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > > <http://www.usdoingstuff.com>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > >
> > > On Fri, Nov 9, 2012 at 5:15 PM, mmcwilliams22 <mmcwilliams22@>wrote:
>
> > >
> > > > **
> > > >
> > > >
> > > > Is there any other properties of the adapter I need to set to be
> able to
> > > > update a UD field on JobOper. I am getting an Update Not allowed
> error when
> > > > executing my code.
> > > >
> > > >
> > > >
> > >
> > >
> > > [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]