Thanks - yes - I see the connection now...
- Neil
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bw2868bond
Sent: Friday, 12 October 2012 9:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: VB error in edit statement - SOLVED!
But args.ProposedValue is a string when you changed the value of edvUD06Row("Character01") because that kicked off the event handler for UD06 again......
- Neil
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bw2868bond
Sent: Friday, 12 October 2012 9:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: VB error in edit statement - SOLVED!
But args.ProposedValue is a string when you changed the value of edvUD06Row("Character01") because that kicked off the event handler for UD06 again......
--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Neil Buckman <nbuckman@...<mailto:nbuckman@...>> wrote:
>
> Thanks John for the offer.
>
> I finally traced down the error by deleting all the code and putting back piece by piece.
>
> The problem was that I had an integer field (UD06.Number01) and I was testing for a change in that field. I had therefore a statement:
>
> Dim START as Integer = args.ProposedValue
>
> It seems that this was the problem and the error disappeared when I made it:
>
> Dim START as String = args.ProposedValue.ToString()
>
> The error message was quite misleading since this value was not what I was writing!
>
> Thanks again for all your help in this list!
>
> - Neil
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of John Driggers
> Sent: Friday, 12 October 2012 12:09 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Re: VB error in edit statement
>
> Can you paste the actual error you're receiving? We're missing something here.
>
> If you want, send me a copy of your customization (off-list so it doesn't get stripped) and I'll load it on my side and see what's up.
>
>
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Wed, Oct 10, 2012 at 8:08 PM, bw2868bond <bwalker@...<mailto:bwalker@...>>wrote:
>
> > **
> >
> >
> > I wonder if you are having problems because you are changing a field
> > inside of a field change event handler......
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Neil Buckman <nbuckman@> wrote:
> > >
> > > Thanks Brian,
> > >
> > > I tried that and although it compiled correctly and all it still
> > > came
> > back with a different error this time:
> > >
> > > Error Detail
> > > ============
> > > Property 'Chars' is ReadOnly.
> > >
> > >
> > > Stack Trace
> > > ===========
> > > at
> > Microsoft.VisualBasic.CompilerServices.NewLateBinding.ResolveCall(Cont
> > ainer BaseReference, String MethodName, MemberInfo[] Members, Object[]
> > Arguments, String[] ArgumentNames, Type[] TypeArguments, BindingFlags
> > LookupFlags, Boolean ReportErrors, ResolutionFailure& Failure)
> > > at
> > Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexSetComp
> > lex(Object Instance, Object[] Arguments, String[] ArgumentNames,
> > Boolean OptimisticSet, Boolean RValueBase)
> > > at Script.UD06_AfterFieldChange(Object sender,
> > > DataColumnChangeEventArgs
> > args)
> > > at System.Data.DataColumnChangeEventHandler.Invoke(Object sender,
> > DataColumnChangeEventArgs e)
> > > at System.Data.DataTable.OnColumnChanged(DataColumnChangeEventArgs
> > > e) at
> > Epicor.Mfg.BO.UD06DataSet.UD06DataTable.OnColumnChanged(DataColumnChan
> > geEventArgs
> > e)
> > > at System.Data.DataRow.set_Item(DataColumn column, Object value) at
> > > System.Data.DataRowView.SetColumnValue(DataColumn column, Object
> > value)
> > > at System.Data.DataRowView.set_Item(String property, Object value)
> > > at Epicor.Mfg.UI.FrameWork.EpiNumericEditor.TextValidate(Object
> > > sender,
> > CancelEventArgs ea)
> > >
> > > ------------------------------------
> > > Private Sub UD06_AfterFieldChange(ByVal sender As Object, ByVal args
> > > As
> > DataColumnChangeEventArgs)
> > > ' ** Argument Properties and Uses ** ' args.Row("FieldName") '
> > > args.Column, args.ProposedValue, args.Row
> > >
> > > Dim edvUD06 As EpiDataView =
> > CType(Me.oTrans.EpiDataViews("UD06"),EpiDataView)
> > > Dim edvUD06Row As System.Data.DataRow = edvUD06.CurrentDataRow
> > >
> > > Dim CodeType As String = edvUD06Row("Key1")
> > >
> > > Dim START as Integer = args.ProposedValue
> > >
> > > Select Case args.Column.ColumnName
> > >
> > > Case "Number01"
> > > If CodeType <> "PARTS" then Exit Select
> > >
> > > Dim pa As PartAdapter = New PartAdapter(UD06Form)
> > > pa.BOConnect()
> > >
> > > ...Code here...
> > >
> > > pa.Dispose()
> > >
> > > edvUD06Row.BeginEdit
> > > edvUD06Row(0)("Character01") = TheAnswer edvUD06Row.EndEdit
> > >
> > > End Select
> > > -----------------------------------
> > >
> > > - Neil
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
> > Behalf Of Brian Roberts
> > > Sent: Thursday, 11 October 2012 12:17 AM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] VB error in edit statement
> > >
> > >
> > >
> > > You're missing the row number parameter, the (0) below:
> > >
> > > edvUD06Row(0)("Character01") = "MYTEXT"
> > >
> > > Brian.
> > >
> > > 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 nbuckman@<mailto:nbuckman%40ymail.com<mailto:nbuckman@%3cmailto:nbuckman%40ymail.com>>
> >
> > > Sent: Wednesday, October 10, 2012 7:39 AM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] VB error in edit statement
> > >
> > > Am I blind? The code below throws an error at the edit statement
> > > saying that conversion of "MYTEXT" to Integer is not valid.
> > >
> > > Why is it doing that? Any suggestions welcome...
> > >
> > > ----------------------------------------------------------
> > > Private Sub UD06_AfterFieldChange(ByVal sender As Object, ByVal args
> > > As
> > > DataColumnChangeEventArgs)
> > >
> > > Dim edvUD06 As EpiDataView = CType(Me.oTrans.EpiDataViews("UD06"),
> > > EpiDataView)
> > > Dim edvUD06Row As System.Data.DataRow = edvUD06.CurrentDataRow
> > >
> > > Select Case args.Column.ColumnName
> > >
> > > Case "Number01"
> > >
> > > ...CODE HERE...
> > >
> > > edvUD06Row.BeginEdit
> > > edvUD06Row("Character01") = "MYTEXT" <== crashes here
> > > edvUD06Row.EndEdit
> > >
> > > End Select
> > > End Sub
> > > ------------------------------------------
> > >
> > > - Neil
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > Notice:This e-mail and any attachments are confidential and are only
> > > for
> > the use of the person to whom they are addressed. If you are not the
> > intended recipient please advise the sender by return e-mail and
> > delete the message and any attachments. Any use, interference with,
> > disclosure or copying of this message or any attachments is unauthorised and prohibited.
> > The sender does not warrant that the information is free of a virus or
> > any other defect or error, and any views expressed herein, unless
> > specifically indicated otherwise, are those of the individual sender.
> > >
> > > The DH Gibson Group of Companies -
> > > http://www.gibsonshopfitters.com.au
> > >
> > > P Please consider our shared environment before printing this
> > communication.
> > >
> > >
> > >
> > > [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
>
>
>
>
> Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.
>
> The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au
>
> P Please consider our shared environment before printing this communication.
>
[Non-text portions of this message have been removed]