No its in the Jobclosing and its very hard there with the BPM
On Wed, Sep 7, 2011 at 6:20 PM, bw2868bond <bwalker@...> wrote:
> **
>
>
> Can you use a pre process BPM to set the field to ?
>
>
> --- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
> >
> > I did . but for the dates it doesnt work it gives me teh same error about
> > null values
> >
> >
> >
> > On Wed, Sep 7, 2011 at 5:51 PM, Dan Godfrey <dgodfrey@...> wrote:
> >
> > > **
> > >
> > >
> > > Have you tried to assign a NON-used date field to the field needed to
> be
> > > cleared. I assigned some high end fields (i.e. Number20) as my nulling
> > > fields.
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > > Of Ephraim Feldman
> > > Sent: Wednesday, September 07, 2011 2:26 PM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] Setting a Date field to null value
> > >
> > > I tried both ways and still getting a error
> > >
> > > On Wed, Sep 7, 2011 at 4:44 PM, Steven Gotschall <sgotschall@...
>
> > > >wrote:
> > >
> > > > **
> > > >
> > > >
> > > > See if this works:
> > > >
> > > > edvBpmData.dataView.Table.Rows(edvBpmData.Row)("Date01").Clear()
> > > > edvBpmData.dataView.Table.Rows(edvBpmData.Row)("Date02").Clear()
> > > >
> > > > Or Try this:
> > > >
> > > >
> edvBpmData.dataView.Table.Rows(edvBpmData.Row)("Date01").PerformAction
> > > > (UltraGridAction.DeleteCells)
> > > >
> > > >
> edvBpmData.dataView.Table.Rows(edvBpmData.Row)("Date02").PerformAction
> > > > (UltraGridAction.DeleteCells)
> > > >
> > > >
> > > > From: Ephraim Feldman <effgroups@...>
>
> > > > To: vantage@yahoogroups.com
> > > > Sent: Wednesday, September 7, 2011 3:49 PM
> > > > Subject: [Vantage] Setting a Date field to null value
> > > >
> > > >
> > > >
> > > > Hi
> > > >
> > > > I want to set a datefield to Null with code .
> > > > I tried the following 2 ways and it doesnt work
> > > >
> > > > edvBpmData.dataView.Table.Rows(edvBpmData.Row)("Date01")
> > > > = DBNull.Value
> > > > edvBpmData.dataView.Table.Rows(edvBpmData.Row)("Date02")
> > > > = convert.DBNull
> > > >
> > > > I get the following error:
> > > >
> > > > The following application error was encountered:
> > > >
> > > > Conversion from type 'DBNull' to type 'Date' is not valid.
> > > >
> > > > Maybe someone knows
> > > >
> > > > Ephraim
> > > >
> > > > [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]
> > >
> > > ------------------------------------
> > >
> > >
> > > 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
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
[Non-text portions of this message have been removed]