That is right, you can prevent recycling field numbers by with the "ADD TRAILING" feature http://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html
In any case, a field created with a recycled number will not contain values from its former life if you compact the data file. > 2017/07/03 22:48、npdennis via 4D_Tech <[email protected]> のメール： > In your case just use the SQL append and you are all set. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
