I figured it out.
Need to set the row mod to "[Clear=ShortChar01]" and then leave that
field blank on the spreadsheet.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: Wednesday, August 12, 2009 8:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect - Delete field data
I would set literal value on the field and in the value box select the
force null value checkbox
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Matt Caldwell" <matt@...> wrote:
Behalf
Need to set the row mod to "[Clear=ShortChar01]" and then leave that
field blank on the spreadsheet.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: Wednesday, August 12, 2009 8:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect - Delete field data
I would set literal value on the field and in the value box select the
force null value checkbox
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Matt Caldwell" <matt@...> wrote:
>[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> This is where the developer guide lost me. On page 32 of the doc, it
> says that only A,U,D,blank are valid entries for row mod. But on page
> 30, it says I can use either [Delete] or Clear=colName,colName,...].
>
>
>
> So I need to enter [Clear=ShortChar02] in the row mod, and then type
> NULL in the CSV file for that column?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Behalf
> Of bw2868bondmy
> Sent: Wednesday, August 12, 2009 8:28 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Service Connect - Delete field data
>
>
>
>
>
> From Page 33 of the Web Service developers guide located in the
> webservices folder on your vantage server:
>
> Q: How do I delete a row from an object (dataset)? If I delete it in
> client application ittags
> does not get deleted in the Progress database after I call the Update
> method.
> A: The Update method has logic to support instructional processing
> which can be<mailto:vantage%40yahoogroups.com> ,
> passed in the RowMod column of a data row.
> Supported tags are:
> [Delete] - indicates the row is to be deleted
> [Clear=colName,colName, ...] - indicates that you want to
> clear the value of the specified column/columns. Columns
> names are passed as a comma separated list.
> Note that you still would need to null out the actual data
> value in the column even if you specify it in the Clear tag.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> "Matt Caldwell" <matt@> wrote:[Non-text portions of this message have been removed]
> >
> > Does anyone have a way in service connect to delete data in a field?
> > Let's say that I want to delete the contents of ShortChar02 in my
> > customer table. Does anyone have a clue as to how to do that?
> >
> >
> >
> > Matt Caldwell
> > Technical Support Analyst
> >
> > KERUSSO
> > P.O. Box 32
> > Berryville, AR 72616
> > Phone: 800-424-0943 Ext. 295 or 870-480-4530
> > Fax: 870-423-3568
> > Web Site: http://www.kerusso.com
> > ******************************************************************
> > CONFIDENTIALITY STATEMENT:
> > This message, from Kerusso Inc., contains information
> > which is privileged and confidential and is solely for the use of
> > the intended recipient. If you are not the intended recipient, be
> > aware that any review, disclosure, copying, distribution, or use
> > of the contents of this message is strictly prohibited. If you have
> > received this in error, please destroy it and notify us immediately
> > at: 800-424-0943
> > ******************************************************************
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>