From: Ed R. <ed_...@be...> - 2004-12-08 19:40:58
|
One thing I have encountered using updategusfromxml is that it allows you to bypass the sequences that should maintain data integrity. I'm just briging this up here as a matter of concern for future development. Any ideas? -Ed > > From: Angel Pizarro <an...@pc...> > Date: 2004/12/07 Tue PM 04:51:50 EST > To: gusdev <Gus...@li...> > Subject: Re: [Gusdev-gusdev] UpdateGusFromXML and updating records > > 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 > > > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://productguide.itmanagersjournal.com/ > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > |