Use a space instead a empty chain like this: mycollectioin!my_key = " "
regards 2010/2/27 richard terry <rte...@pacific.net.au> > Hi List, > > We debated this before and though some persons understood what I was > saying, I > don't think there was any resolution, so this time I've got a little screen > shot to visually demonstrated the problem which is. > > When one sets a collection member to any empty sting "" gambas beleives > this > is the same as null and removes the item from the collection > > ie mycollection!my_key = "Fred" is valid > mycollectioin!my_key = "" removes the key from the collection, instead of > setting its value to an empty string (ie string with no characters. > > The implications of this in data saving as illustrated by the picture are > as > follows > > Here, the persons name/firstname/salutation were Smith/Stephanie/Steph, > this > record was saved to the database. however I decided to remove salutation. > As > gambas then sets this key to null - effectively removing it from the > collection, the field in the collection is not updated, and the original > value > is left intact - ie 'steph' in the database field 'saluation', is not > re-set > to an empty string. > > I really wonder what can be done about this. > > REgards > > Richard > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user