Re: [Gusdev-gusdev] UpdateGusFromXML and updating records

[Angel P. <an...@pc...>]

I was actually pretty surprised that you did not run into that error 
previously. All of the GUS XML that I have dealt with had lower case 
elements for the table columns

So now we know that:
1) Elements that are table column name must be lowercase and in the 
order they appear in the view/table
2) A column must be all on one line with no leading/trailing whitespace
3) Updates are triggered by settig the PK column

angel

Kevin Murphy wrote:

> Angel Pizarro wrote:
>
>> The GUS XML parser is not a real XML parser. The order of the columns 
>> matter. Put <PROTOCOL_ID> before <PROTOCOL_TYPE_ID> 
>
>
> Here is another important note on updating records using 
> UpdateGusFromXML:
>
> If you specify the primary key, that column name must be in lower 
> case.  The other column names are not case-sensitive.
>
> Kevin Murphy
>