Good point - I already simply forgot about trying to rename. In concept it would not be an issue as I was only going to rename a field named 'Unused' But there were other considerations to renaming that occurred to me after I posted.
in sql - if rename works, I do not see a way to redefine the column from say text to longint. I did not try changing the column definition unused as real vs existing data type of text anyway - that part of the idea is dead. Thanks! Chip On Fri, 26 Jul 2019 13:56:58 -0500, Stephen J. Orth wrote: > Chip, > > That kind of sucks because doesn't a "drop" destroy data? > > Steve > > -----Original Message----- > From: 4D_Tech <[email protected]> On Behalf Of Chip > Scheide via 4D_Tech > Sent: Friday, July 26, 2019 1:46 PM > To: Tom Benedict <[email protected]> > Cc: Chip Scheide <[email protected]>; 4D iNug Technical > <[email protected]> > Subject: Re: SQL - renaming a field > > OK > > Thanks both > > I guess rename is only possible as Drop + Add > > Chip > > --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
