Surely you'd be better off doing this in SQL with an UPDATE rather than using MODIFY.
I know MODIFY works for simple things, but once you start having selection criteria, or want to change multi-valued fields, MODIFY shows its limitations. :sql sql> UPDATE INVENTORY SET IN_BIN_LOCATION = "" WHERE ... ; sql> quit : Cheers, Ken PS Remember that "" isn't NULL, its empty. > [EMAIL PROTECTED] wrote: > MODIFY INVENTORY IN_BIN_LOCATION_2 = "" > Say "Y" to use the active select list otherwise it will modify the > entire file. > > Note that IN_BIN_LOCATION_2 has to be a "D" type dictionary. Once you > are working with a select list you can not also use selection criteria > within the Modify command. > >-----Original Message----- > >From: Jimmy Dixon > > > >I have been playing around with UDT and have hit a wall. > > > >I am trying to do a modification to a single field, but, I > >need to set that field to null, not spaces. > > > >MODIFY INVENTORY WITH IN_BIN_LOCATION_2 = "" > >(I have gone through and selected the records and saved to a > >list, and am using that list.) > > > >The system is not seeing the IN_BIN_LOCATION_2 as null. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
